|
TABLE NAME
|
TABLE DESCRIPTION
|
|
OE_ACTIONS_IFACE_ALL
|
This is a multi-org
table for sales order actions holds, booking etc. open interface.
|
|
OE_ACTION_PRE_REQS
|
A temporary table used
during the WF upgrade into R11i.
|
|
OE_ADJ_ATTRIB_EBS_LOG
|
Log table for the Euro
conversion of OE_PRICE_ADJ_ATTRIBS. This table is used only by the Euro Customer Conversion concurrent
program.
|
|
OE_AK_GEN_OBJECTS_CFG
|
No longer used
|
|
OE_AK_OBJECTS_EXT
|
Extension tables to
AK_OBJECTS which is used to store
additional data
|
|
OE_AK_OBJ_ATTR_EXT
|
Extension table to AK
Object Attributes that is used to store additional data
|
|
OE_AK_OBJ_WF_ITEMS
|
Extension table to AK
Object Attributes that is used to store additional data
|
|
OE_APPROVER_LISTS
|
This table will be
used with the OM Approvers List setup form to setup the approver Lists.
|
|
OE_APPROVER_LIST_MEMBERS
|
This table will be
used to manage all the approvers in approver lists.
|
|
OE_APPROVER_TRANSACTIONS
|
This table will be
used to manage the runtime transaction level approvals and its statuses.
|
|
OE_ATTACHMENT_OBJECT_REFS
|
No longer used
|
|
OE_ATTACHMENT_OBJECT_REFS_TL
|
No longer used
|
|
OE_ATTACHMENT_RULES
|
OE_ATTACHMENT_RULES
stores the entity to which an attachment rule should be applied.
|
|
OE_ATTACHMENT_RULE_ELEMENTS
|
OE_ATTACHMENT_RULE_ELEMENTS
stores the attributes and attribute values that make up the attachment rule.
|
|
OE_AUDIT_ATTR_HISTORY
|
Audit Trail History
Table
|
|
OE_BLANKET_HEADERS_ALL
|
Table to capture sales
agreement header details..
|
|
OE_BLANKET_HEADERS_EXT
|
Table to capture sales
agreement header details, specific to sales agreement functionality
|
|
OE_BLANKET_HEADERS_HIST
|
Table to capture sales
agreement header history. Primary for storing revisions.
|
|
OE_BLANKET_LINES_ALL
|
Table to capture sales
agreement Line details.(Attributes common between Sales Order and Sales
Agreements).
|
|
OE_BLANKET_LINES_EXT
|
Table to capture sales
agreement line details specific to sales agreement functionality.
|
|
OE_BLANKET_LINES_HIST
|
Table to capture sales
agreement lines history.
|
|
OE_BLANKET_ORG_ASSIGN
|
Not in use,
|
|
OE_CC_TEMP
|
|
|
OE_CONC_REQUEST_IFACE
|
Interface table for
the retrobilling concurrent program
|
|
OE_CONFIG_DETAILS_TMP
|
|
|
OE_CREDITS_IFACE_ALL
|
This is a multi-org table for sales
order/line credits open interface.
|
|
OE_CREDIT_BALANCES_ALL
|
Stores the current
credit exposure data for each
individual customer and site with credit limits. Each customer(or site)'s
credit limit (including default limits) will have one row for each valid
credit rule in the system. This table will
|
|
OE_CREDIT_CHECK_RULES
|
This table stores
information about the credit check rules.
|
|
OE_CREDIT_SUMMARIES
|
This summary table is
used to implement Pre-Calculated Credit Exposure.
|
|
OE_CUSTOMER_INFO_IFACE_ALL
|
Interface table to add
new customer, its address and contact info.
|
|
OE_CUSTOM_ACTIONS
|
This table stores the
information about all the actions that
are assigned to a folder.
|
|
OE_CUST_ITEM_SETTINGS
|
OE_CUST_ITEM_SETTINGS
stores the shipment and return tolerances for customer-item, item-site and item combinations
|
|
OE_CUST_MERGES_GTT
|
|
|
OE_CUST_TOTAL_AMTS_ALL
|
Stores the accumulated
order value for a customer over three periods.
|
|
OE_DEFAULT_ACTIONS
|
This table stores the
information about all the actions that are applicable to the Sales Order.
|
|
OE_DEF_ATTR_CONDNS
|
Associates the
defaulting condtion, defined at the entity level , to a specific attribute.
|
|
OE_DEF_ATTR_DEF_RULES
|
Defaulting rules for
an attribute for a defaulting condition.
|
|
OE_DEF_CONDITIONS
|
This table stores
defaulting conditions for an entity
|
|
OE_DEF_CONDITIONS_TL
|
OE_DEF_CONDITIONS_TL
stores the translated columns for defaulting conditions.
|
|
OE_DEF_CONDN_ELEMS
|
This table stores
elements (columns and column values) that makeup the defaulting condition
identified by condition_id.
|
|
OE_DOC_SEQUENCE_AUDIT
|
OE_DOC_SEQUENCE_AUDIT
is the table used by the FND module for audit purposes when the sequences
used to generate the order numbers are created.
|
|
OE_DROP_SHIP_SOURCES
|
This table stores
relationship between order lines in
oe_order_lines_all table and associated oracle purchasing requisitions in
PO_REQUISITIONS_ALL and Oracle purchasing purchase orders in PO_LINES_ALL.
|
|
OE_EM_INFORMATION_ALL
|
This table maintains
tracking information for Order Import and Electronic Messaging (EDI &
XML)
|
|
OE_EVENT_ATTRIBUTES
|
This table stores
order header and line attributes thattrigger repricing, when modified, at
various pricing events.
|
|
OE_EXPOSURE_INTERFACE
|
This table contains
Credit Exposure Data to be imported into Oracle Order Management
|
|
OE_EXP_INTERFACE_ERRORS
|
This table contains
error messages for each row of exposure data in the OE_EXPOSURE_INTERFACE
table that failed validation.
|
|
OE_FLOW_STATUS_AIA_SYNC
|
Stores the information
about which flow status code raises an O2C business event.
|
|
OE_FOLDER_EXTENSIONS
|
This table stores the
information about Folder Extensions.
|
|
OE_HEADERS_EBS_LOG
|
Log table for the Euro
conversion of OE_ORDER_LINES_ALL. This table is used only by the Euro Customer Conversion concurrent
program.
|
|
OE_HEADERS_IFACE_ALL
|
This is a multi-org
table for sales order headers open interface.
|
|
OE_HEADER_ACKS
|
This tables stores
information about the acknowledgements for Order Headers.
|
|
OE_HOLD_AUTHORIZATIONS
|
Stores information
about who has the authority to apply and release holds.
|
|
OE_HOLD_DEFINITIONS
|
This table stores
information about hold name and its validity period.
|
|
OE_HOLD_RELEASES
|
This tables stores
information about all the holds that has been released.
|
|
OE_HOLD_SOURCES_ALL
|
This table stores
information of the hold source criteria.
|
|
OE_INIT_CREDIT_SUMM_GTT
|
|
|
OE_INIT_SUMM_TMP
|
|
|
OE_INVOICE_NUMBERS
|
This table is used for
generating invoice numbers based on the delivery name.
|
|
OE_ITEMS_MV
|
|
|
OE_ITEM_CUST_VOLS_ALL
|
This table stores
accumulated order quantity and value for an item of a customer over three
periods.
|
|
OE_ITEM_ORDERABILITY
|
This tables stores
information about the general Availability of the items.
|
|
OE_ITEM_ORDERABILITY_RULES
|
This tables stores
information about the Availability Rules Set for the items.
|
|
OE_LINES_EBS_LOG
|
Log table for the Euro
conversion of OE_ORDER_LINES_ALL. This table is used only by the Euro Customer Conversion concurrent
program.
|
|
OE_LINES_IFACE_ALL
|
This is a multi-org
table for sales order lines open interface.
|
|
OE_LINE_ACKS
|
This table stores
information about the acknowledgements for Order Lines.
|
|
OE_LINE_SETS
|
This table stores
information about Sets.
|
|
OE_LINE_SPLIT_DETAILS
|
This table stores
information about all the lines getting split.
|
|
OE_LOTSERIALS_IFACE_ALL
|
This is a multi-org
table for return line lot serials open interface.
|
|
OE_LOTSERIAL_ACKS
|
This table stores
information about the acknowledgements for lot and serial numbers for return
lines.
|
|
OE_LOT_SERIAL_NUMBERS
|
This table stores
customer reported lot serial numbers for lot and / or serial number
controlled return lines.
|
|
OE_NOTES_OBJECT_REFS
|
No longer used
|
|
OE_NOTES_OBJECT_REFS_TL
|
No longer used
|
|
OE_NOTES_RULES
|
No longer used
|
|
OE_NOTES_RULE_ELEMENTS
|
No longer used
|
|
OE_ORDER_HEADERS_ALL
|
OE_ORDER_HEADERS_ALL
stores header information for orders in Order Management.
|
|
OE_ORDER_HEADERS_ALL_EFC
|
Archive for Euro
Project
|
|
OE_ORDER_HEADER_HISTORY
|
Stores history of
attribute change for Order Headers
|
|
OE_ORDER_HOLDS_ALL
|
This table stores
information of all the orders and lines that are on hold and the link to hold
sources and hold releases.
|
|
OE_ORDER_LINES_ALL
|
OE_ORDER_LINES_ALL
stores information for all order lines in Oracle Order Management.
|
|
OE_ORDER_LINES_HISTORY
|
Stores history of
attribute change for Order Lines.
|
|
OE_ORDER_NUMBER_SOURCES
|
No longer used
|
|
OE_ORDER_PRICE_ATTRIBS
|
This table stores
pricing attributes and asked for promotions, deals, and coupon number entered
by the user.
|
|
OE_ORDER_SOURCES
|
Feeder System Names
that create orders in Order Management tables.
|
|
OE_PAYMENTS
|
It holds the
commitment payment information.
|
|
OE_PAYMENTS_HISTORY
|
Table to store payment
audit trail.
|
|
OE_PAYMENTS_IFACE_ALL
|
This table is used to
store Payments data to be imported into OE_PAYMENTS table. This table will be
used by Order Import Program.
|
|
OE_PAYMENT_TYPES_ALL
|
Multiorg table to
store different payment types for each Operating Unit
|
|
OE_PAYMENT_TYPES_TL
|
This table stores the
name and description for each payment type in different languages
|
|
OE_PC_ASSIGNMENTS
|
This table stores the
responsibilities that are constrained by the constraint identified by
constraint_id.
|
|
OE_PC_CONDITIONS
|
This table stores the
conditions associated with the constraints identified by constraint_id.
|
|
OE_PC_CONDITIONS_TL
|
This table stores the
translated conditions associated with the constraints identified by
constraint_id.
|
|
OE_PC_CONSTRAINTS
|
This table stores the
constraints that prevent create/update/delete of order entities.
|
|
OE_PC_EXCLUSIONS
|
This table stores the
responsibilities that are not constrained by a particular constraint.
|
|
OE_PC_RSETS
|
This table store the
constraint record sets and the constraint conditions can be built to validate
against any or all the records in this record set.
|
|
OE_PC_RSETS_TL
|
OE_PC_RSETS_TL stores
the translated columns for record sets for constraints.
|
|
OE_PC_RSET_SEL_COLS
|
This table stores
columns to be matched for a constraint record set.
|
|
OE_PC_VALIDATION_PKGS
|
This table stores the
names of the dynamically generated constraints validation packages.
|
|
OE_PC_VTMPLTS
|
This table stores the
constraint validation templates that are used in constraint conditions.
|
|
OE_PC_VTMPLTS_TL
|
OE_PC_VTMPLTS_TL stores
the translated columns for validation templates for constraints.
|
|
OE_PC_VTMPLT_COLS
|
This table stores the
attribute validation pairs for validation templates that are based on column
values.
|
|
OE_PRICE_ADJS_HISTORY
|
Stores history of
attribute changes of Entity Price
|
|
OE_PRICE_ADJS_IFACE_ALL
|
This is a multi-org
open interface table for sales order/line price adjustments.
|
|
OE_PRICE_ADJUSTMENTS
|
This table is used to
store price adjustments that have been applied to an order or a line. It is
also used to store the freight and special charges, Tax on order line, and
Shipping Costs captured at ship confirmation.
For Tax records the
|
|
OE_PRICE_ADJ_ASSOCS
|
This table stores the
association between order lines and price adjustments and also between price
adjustments
|
|
OE_PRICE_ADJ_ATTRIBS
|
This table stores
information on qualifiers and pricing attributes, which to that corresponding
price adjustment line qualified for.
|
|
OE_PRICE_ADJ_EBS_LOG
|
Log table for the Euro
conversion of OE_PRICE_ADJUSTMENTS. This table is used only by the Euro Customer Conversion concurrent
program.
|
|
OE_PRICE_ATTRIB_EBS_LOG
|
Log table for the Euro
conversion of OE_ORDER_PRICE_ATTRIBS. This table is used only by the Euro Customer Conversion concurrent
program.
|
|
OE_PRICE_ATTS_IFACE_ALL
|
This is a multi-org
Interface table to populate OE_ORDER_PRICE_ATTRIBS.
|
|
OE_PROCESSING_MSGS
|
This table stores the
context information of the processing messages that will be generated
during Order Entry concurrent program
execution or UI process.
|
|
OE_PROCESSING_MSGS_TL
|
This table stores the
processing messages which will be generated during Order Entry concurrent
program execution or UI process. This is a multi-lingual table.
|
|
OE_PURGE_ORDERS
|
OE_PURGE_ORDERS stores
the order details for orders included in a purge set.
|
|
OE_PURGE_SETS
|
OE_PURGE_SETS stores
purge set information.
|
|
OE_REASONS
|
Table to store change
reasons for entities inserted into history tables.
|
|
OE_RESERVATION_SETS
|
Reservation Set header
table
|
|
OE_RESERVTNS_IFACE_ALL
|
This is a multi-org
table for inventory reservations open interface.
|
|
OE_RETROBILL_REQUESTS
|
Retrobill requests
table.
|
|
OE_RSV_SET_DETAILS
|
Reservation Set detail
table
|
|
OE_SALES_CREDITS
|
This table stores
information about sales credits.
|
|
OE_SALES_CREDIT_HISTORY
|
Stores history of
attribute changes of Entity Sales Credits
|
|
OE_SALES_CREDIT_TYPES
|
This table stores
information about sales credit types.
|
|
OE_SCHEDULE_LINES_TEMP
|
|
|
OE_SCH_ID_LIST_TMP
|
|
|
OE_SELECTED_ITEMS
|
Stores the inventory
items selected by users in the Advance Item Search Window.
|
|
OE_SETS
|
OE_SETS stores
information on line sets.
|
|
OE_SETS_HISTORY
|
Stores history of Set
information
|
|
OE_SYSTEM_PARAMETERS_ALL
|
This table is used for
storing all system parameter information.
|
|
OE_SYSTEM_PARAMS_UPG
|
OE_SYSTEM_PARAMS_UPG is
an intermediate table used during upgrade to 11
|
|
OE_SYS_PARAMETERS_ALL
|
OM parameter setup
table
|
|
OE_SYS_PARAMETER_DEF_B
|
OM Parameter Definiton
Table.
|
|
OE_SYS_PARAMETER_DEF_TL
|
OM Parameter
Definition Translation table
|
|
OE_TRANSACTION_TYPES_ALL
|
This table stores
information about the order and line transaction types
|
|
OE_TRANSACTION_TYPES_TL
|
This is a mult-lingual
table for OE_TRANSACTION_TYPES_ALL table.
|
|
OE_TRXN_TEMP
|
|
|
OE_UI_QUERIES_TL
|
This table stores the
user defined queries that can be administered in the Sales Order UI.
|
|
OE_UI_QUERY_COLUMNS
|
This table stores the
column values for the user defined queries that are stored in
OE_UI_QUERIES_TL table.
|
|
OE_UPGRADE_DISTRIBUTION
|
Stores the Slabs or
from and to header ids for parallel upgrade processing.
|
|
OE_UPGRADE_ERRORS
|
Stores Errors trapped
while Upgrading
|
|
OE_UPGRADE_LOG
|
Upgrade Control
Information.
|
|
OE_UPGRADE_PC_ATTR_MAP
|
Processing constraints
upgrade mapping table.
|
|
OE_UPGRADE_PC_CONDNS
|
Stores the Conditions
to be upgraded to 11i.
|
|
OE_UPGRADE_PC_SCOPE
|
Processing constraints
upgrade table.
|
|
OE_UPGRADE_PC_TEMP
|
Processing constraints
upgrade table.
|
|
OE_UPGRADE_WF_ACT_MAP
|
Wofkflow upgrade
mapping table.
|
|
OE_UPGRADE_WF_HIST_TEMP
|
This table is used
during OM upgrade for cycles to workflow conversion
|
|
OE_UPGRADE_WF_OBS_CODES
|
This table stores the
Action names and Result names which are obsoleted in R11i.
|
|
OE_UPGRADE_WF_VLD_CYC
|
Temporary table used
by OM upgrade for cycles to workflow upgrade.
|
|
OE_UPGRADE_WSH_IFACE
|
Sales Order upgrade
table - Shipping integration.
|
|
OE_WORKFLOW_ASSIGNMENTS
|
This table associates
assignments to order types and line types.
|
|
ONT_DBI_CHANGE_LOG
|
Event notification for
DBI
|
|
ONT_PRT_MARGIN_ANALYSIS
|
ONT_PRT_MARGIN_ANALYSIS
contains margin analysis information grouped by customer, item, territory,
and sales person for three different time periods, last week, last 30 days,
and last 90 days
|
|
ONT_PRT_MARGIN_ANA_ERR
|
ONT_PRT_MARGIN_ANA_ERR
contains primary key values of the failing record while building the
ONT_PRT_MARGIN_ANALYSIS table.
|
|
ONT_WF_SKIP_LOG
|
OM WorkFlow Activity
Skip Log.
|