eTRM uses javascript that opens and focuses a separate window to display reports.
Your browser does not appear to support javascript. This should not prevent you from using
eTRM but it does mean the window focus feature will not work. Please check the contents of
other windows on your desktop if you click on a link that does not appear to do anything.
Oracle eBusiness Suite Technical Reference
Release 11i - Copyright (c) 2001 - 2005 Oracle
This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is
provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and
other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to
safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or
a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential
Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c)
restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was
disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends
or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or
by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this
TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.
The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter,
please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is'
with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements.
Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this
TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's
responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the
Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs.
Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose.
Restricted Rights Legend
This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and
use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the
applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal
Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this
TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500
Oracle Parkway, Redwood City, CA 94065.
Oracle is a registered trademark. AIM Advantage, Big Business. Small Business. All Business., CDM Advantage,
.comference, ConText®, Des40®, Easy*Query, Easy*SQL®, Education Objects, EMM Advantage, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM,
GEMMS®, Gist, Hyper*SQL, instantOracle, "Internet Business Intelligence - Insight for Everyone", iSQL*Plus, JInitiator,
NLS*Workbench®, Object Marketplace, ODP Pulse, ODP Techwire, OLA,
On Oracle, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE ®, Oracle Business OnLine®,
OracleDevConnect SM, Oracle® Discoverer,
Oracle® Expert, Oracle Financials®, OracleGOLD SM,
OracleIncident SM, OracleJSP,
OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURY SM,
OracleMetaLink SM, Oraclemetals SM, OracleMobile, Oracle Names®,
Oracle NetSolutions®, Oracle® One, Oracle Open Gateways®,
Oracle OpenWorld®, OraclePLATINUM SM,
Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®,
Oracle Quality®, Oracle Secure Network Services®, OracleSILVER SM,
Oracle® SQL/Services, Oracle® SQL*TutorSM,
OracleSTERLING SM, Oracle Store®,
Oracle Transparent Gateway®, OracleWare®, Oracle8i, Oracle9i,
PC Express®, Personal Express®, PJM Advantage, PL/SQL, Pro*Ada®,
Pro*C, Pro*C/C++, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®,
Pro*PL/1®, Pro*REXX®, Profit, ProREXX, Report Card,
Secure Access 2.0, Secure Network Services®, Security Without Compromise,
SellingPoint®, SQL*Plus®, Tutor are trademarks or
registered trademarks of Oracle. Other names may be trademarks of their respective owners.
The absence of a product or service name, slogan, or logo from this list does not constitute a
waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan,
or logo.
eTRM - EC Tables and Views
TABLE - EC.ECE_ADVO_DETAILS
TABLE - EC.ECE_ADVO_DETAILS_INTERFACE
TABLE - EC.ECE_ADVO_DETAILS_INTERFACE_X
TABLE - EC.ECE_ADVO_HEADERS
TABLE - EC.ECE_ADVO_HEADERS_INTERFACE
TABLE - EC.ECE_ADVO_HEADERS_INTERFACE_X
TABLE - EC.ECE_AP_CHECKS_INTERFACE
TABLE - EC.ECE_AP_CHECKS_INTERFACE_X
TABLE - EC.ECE_AP_INVOICES_INTERFACE
TABLE - EC.ECE_AP_INVOICES_INTERFACE_X
TABLE - EC.ECE_AR_TRX_ALLOWANCE_CHARGES
TABLE - EC.ECE_AR_TRX_ALLOWANCE_CHARGES_X
TABLE - EC.ECE_AR_TRX_HEADERS
TABLE - EC.ECE_AR_TRX_HEADERS_X
TABLE - EC.ECE_AR_TRX_HEADER_1
TABLE - EC.ECE_AR_TRX_HEADER_1_X
TABLE - EC.ECE_AR_TRX_LINES
TABLE - EC.ECE_AR_TRX_LINES_X
TABLE - EC.ECE_AR_TRX_LINE_TAX
TABLE - EC.ECE_AR_TRX_LINE_TAX_X
TABLE - EC.ECE_ATTACHMENT_DETAILS
TABLE - EC.ECE_ATTACHMENT_DETAILS_X
TABLE - EC.ECE_ATTACHMENT_HEADERS
TABLE - EC.ECE_ATTACHMENT_HEADERS_X
TABLE - EC.ECE_COLUMN_RULES
TABLE - EC.ECE_COLUMN_RULES_UPG
TABLE - EC.ECE_ERROR
TABLE - EC.ECE_EXTERNAL_LEVELS
TABLE - EC.ECE_EXTERNAL_LEVELS_UPG
TABLE - EC.ECE_INTERFACE_COLS_UPG
TABLE - EC.ECE_INTERFACE_COLUMNS
TABLE - EC.ECE_INTERFACE_TABLES
TABLE - EC.ECE_INTERFACE_TBLS_UPG
TABLE - EC.ECE_LEVEL_MATRICES
TABLE - EC.ECE_LEVEL_MATRICES_UPG
TABLE - EC.ECE_MAPPINGS
TABLE - EC.ECE_MAPPINGS_UPG
TABLE - EC.ECE_MVSTO_DETAILS
TABLE - EC.ECE_MVSTO_DETAILS_X
TABLE - EC.ECE_MVSTO_HEADERS
TABLE - EC.ECE_MVSTO_HEADERS_X
TABLE - EC.ECE_MVSTO_LOCATIONS
TABLE - EC.ECE_MVSTO_LOCATIONS_X
TABLE - EC.ECE_OUTPUT
TABLE - EC.ECE_PO_DISTRIBUTIONS
TABLE - EC.ECE_PO_DISTRIBUTIONS_X
TABLE - EC.ECE_PO_INTERFACE_HEADERS
TABLE - EC.ECE_PO_INTERFACE_HEADERS_X
TABLE - EC.ECE_PO_INTERFACE_LINES
TABLE - EC.ECE_PO_INTERFACE_LINES_X
TABLE - EC.ECE_PO_INTERFACE_SHIPMENTS
TABLE - EC.ECE_PO_INTERFACE_SHIPMENTS_X
TABLE - EC.ECE_PO_PROJECT_INFO
TABLE - EC.ECE_PO_PROJECT_INFO_X
TABLE - EC.ECE_PROCEDURE_MAPPINGS
TABLE - EC.ECE_PROCESS_RULES
TABLE - EC.ECE_PROCESS_RULES_UPG
TABLE - EC.ECE_PROC_MAPPINGS_UPG
TABLE - EC.ECE_RULE_LIST
TABLE - EC.ECE_RULE_LIST_DETAILS
TABLE - EC.ECE_RULE_NULL_DEFAULT
TABLE - EC.ECE_RULE_NULL_DEP
TABLE - EC.ECE_RULE_NULL_DEP_DETAILS
TABLE - EC.ECE_RULE_SIMPLE_LOOKUP
TABLE - EC.ECE_RULE_VALUESET
TABLE - EC.ECE_RULE_VIOLATIONS
TABLE - EC.ECE_SPSO_HEADERS
TABLE - EC.ECE_SPSO_HEADERS_X
TABLE - EC.ECE_SPSO_ITEMS
TABLE - EC.ECE_SPSO_ITEMS_X
TABLE - EC.ECE_SPSO_ITEM_DET
TABLE - EC.ECE_SPSO_ITEM_DET_X
TABLE - EC.ECE_SPSO_SHIP_DET
TABLE - EC.ECE_SPSO_SHIP_DET_X
TABLE - EC.ECE_STAGE
TABLE - EC.ECE_TP_DETAILS
TABLE - EC.ECE_TP_GROUP
TABLE - EC.ECE_TP_HEADERS
TABLE - EC.ECE_TRAN_PARAMETERS
TABLE - EC.ECE_TRAN_STAGE_DATA
TABLE - EC.ECE_TRAN_STAGE_DATA_UPG
TABLE - EC.ECE_XREF_CATEGORIES
TABLE - EC.ECE_XREF_DATA
VIEW - APPS.ECE_ADVO_DETAILS_V
VIEW - APPS.ECE_ADVO_HEADERS_V
VIEW - APPS.ECE_ATTACHMENT_V
VIEW - APPS.ECE_CDMO_ALLOWANCE_CHARGES_V
VIEW - APPS.ECE_CDMO_HEADER_1_V
VIEW - APPS.ECE_CDMO_HEADER_V
VIEW - APPS.ECE_CDMO_LINE_TAX_V
VIEW - APPS.ECE_CDMO_LINE_V
VIEW - APPS.ECE_CDMO_TRX_NUMBER_V
VIEW - APPS.ECE_INO_ALLOWANCE_CHARGES_V
VIEW - APPS.ECE_INO_HEADER_1_V
VIEW - APPS.ECE_INO_HEADER_V
VIEW - APPS.ECE_INO_LINE_TAX_V
VIEW - APPS.ECE_INO_LINE_V
VIEW - APPS.ECE_LOOKUP_VALUES
VIEW - APPS.ECE_MTL_MOV_STAT_V
VIEW - APPS.ECE_MVSTO_DETAILS_V
VIEW - APPS.ECE_MVSTO_HEADERS_V
VIEW - APPS.ECE_MVSTO_LOCATIONS_V
VIEW - APPS.ECE_POCO_HEADERS_V
VIEW - APPS.ECE_POCO_LINES_V
VIEW - APPS.ECE_POCO_SHIPMENTS_V
VIEW - APPS.ECE_POO_HEADERS_V
VIEW - APPS.ECE_POO_LINES_V
VIEW - APPS.ECE_POO_SHIPMENTS_V
VIEW - APPS.ECE_PO_DISTRIBUTIONS_V
VIEW - APPS.ECE_PO_PROJECT_INFO_V
VIEW - APPS.ECE_PROFILE_OPTIONS
VIEW - APPS.ECE_PYO_INVOICE_V
VIEW - APPS.ECE_PYO_PAYMENT_V
VIEW - APPS.ECE_SPSO_HEADERS_V
VIEW - APPS.ECE_SPSO_ITEMS_V
VIEW - APPS.ECE_SSSO_HEADERS_V
VIEW - APPS.ECE_SSSO_ITEMS_V
VIEW - APPS.ECE_STAGE_LEVEL1_V
VIEW - APPS.ECE_STAGE_LEVEL2_V
Table: ECE_ADVO_DETAILS
Description: Contains the status detail for inbound transactions: Invoice (810/INVOIC), Ship Notice/Manifest (856/DESADV) and Shipment and Billing Notice (857).
Primary Key: ECE_ADVO_DETAILS_PK
ADVICE_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
ECE_ADVO_DETAILS.ADVICE_HEADER_ID
ECE_ADVO_HEADERS
[top of page]
EC.ECE_ADVO_DETAILS does not reference any database object
EC.ECE_ADVO_DETAILS is referenced by following:
EC
VIEW - ECE_ADVO_DETAILS#
[top of page]
Table: ECE_ADVO_DETAILS_INTERFACE
Description: Contains the detail data to support the outbound Application Advice (824/APERAK) transaction.
Primary Key: ECE_ADVO_DETAILS_INTERFACE_PK
RUN_ID
ADVICE_DETAIL_ID
[top of page]
EC.ECE_ADVO_DETAILS_INTERFACE does not reference any database object
EC.ECE_ADVO_DETAILS_INTERFACE is referenced by following:
EC
VIEW - ECE_ADVO_DETAILS_INTERFACE#
[top of page]
Table: ECE_ADVO_DETAILS_INTERFACE_X
Description: Extension table for ECE_ADVO_DETAILS_INTERFACE.
Primary Key: ECE_ADVO_DETAILS_INT_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_ADVO_DETAILS_INTERFACE_X does not reference any database object
EC.ECE_ADVO_DETAILS_INTERFACE_X is referenced by following:
EC
VIEW - ECE_ADVO_DETAILS_INTERFACE_X#
[top of page]
Table: ECE_ADVO_HEADERS
Description: Contains the status data for inbound transactions: Invoice (810/INVOIC), Ship Notice/Manifest (856/DESADV) and Shipment and Billing Notice (857).
Primary Key: ECE_ADVO_HEADERS_PK
ADVICE_HEADER_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
ECE_ADVO_DETAILS.ADVICE_HEADER_ID
ECE_ADVO_HEADERS
[top of page]
EC.ECE_ADVO_HEADERS does not reference any database object
EC.ECE_ADVO_HEADERS is referenced by following:
EC
VIEW - ECE_ADVO_HEADERS#
[top of page]
Table: ECE_ADVO_HEADERS_INTERFACE
Description: Contains the header data to support the outbound Application Advice (824/APERAK) transaction.
Primary Key: ECE_ADVO_HEADERS_INTERFACE_PK
ADVICE_HEADER_ID
RUN_ID
[top of page]
EC.ECE_ADVO_HEADERS_INTERFACE does not reference any database object
EC.ECE_ADVO_HEADERS_INTERFACE is referenced by following:
EC
VIEW - ECE_ADVO_HEADERS_INTERFACE#
[top of page]
Table: ECE_ADVO_HEADERS_INTERFACE_X
Description: Extension table for ECE_ADVO_HEADERS_INTERFACE.
Primary Key: ECE_ADVO_HEADERS_INT_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_ADVO_HEADERS_INTERFACE_X does not reference any database object
EC.ECE_ADVO_HEADERS_INTERFACE_X is referenced by following:
EC
VIEW - ECE_ADVO_HEADERS_INTERFACE_X#
[top of page]
Table: ECE_AP_CHECKS_INTERFACE
Description: Contains the payment data to support the outbound Payment/Remittance Advice (820/PAYORD/REMADV) transaction.
Primary Key: ECE_AP_CHECKS_INTERFACE_PK
CHECKRUN_NAME
[top of page]
EC.ECE_AP_CHECKS_INTERFACE does not reference any database object
EC.ECE_AP_CHECKS_INTERFACE is referenced by following:
EC
VIEW - ECE_AP_CHECKS_INTERFACE#
[top of page]
Table: ECE_AP_CHECKS_INTERFACE_X
Description: Extension table for ECE_AP_CHECKS_INTERFACE.
Primary Key: ECE_AP_CHECKS_INTERFACE_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_AP_CHECKS_INTERFACE_X does not reference any database object
EC.ECE_AP_CHECKS_INTERFACE_X is referenced by following:
EC
VIEW - ECE_AP_CHECKS_INTERFACE_X#
[top of page]
Table: ECE_AP_INVOICES_INTERFACE
Description: Contains the invoice data to support the outbound Payment/Remittance Advice (820/PAYORD/REMADV) transaction.
Primary Key: ECE_AP_INVOICES_INTERFACE_PK
CHECKRUN_NAME
[top of page]
EC.ECE_AP_INVOICES_INTERFACE does not reference any database object
EC.ECE_AP_INVOICES_INTERFACE is referenced by following:
EC
VIEW - ECE_AP_INVOICES_INTERFACE#
[top of page]
Table: ECE_AP_INVOICES_INTERFACE_X
Description: Extension table for ECE_AP_INVOICES_INTERFACE.
Primary Key: ECE_AP_INVOICES_INTERFACE_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_AP_INVOICES_INTERFACE_X does not reference any database object
EC.ECE_AP_INVOICES_INTERFACE_X is referenced by following:
EC
VIEW - ECE_AP_INVOICES_INTERFACE_X#
[top of page]
Table: ECE_AR_TRX_ALLOWANCE_CHARGES
Description: Contains the customer invoice allowance charges information to support the outbound Invoice (810/INVOIC) transaction.
Primary Key: ECE_AR_TRX_ALLOWANCE_CHARGE_PK
TRANSACTION_ID
[top of page]
EC.ECE_AR_TRX_ALLOWANCE_CHARGES does not reference any database object
EC.ECE_AR_TRX_ALLOWANCE_CHARGES is referenced by following:
EC
VIEW - ECE_AR_TRX_ALLOWANCE_CHARGES#
[top of page]
Table: ECE_AR_TRX_ALLOWANCE_CHARGES_X
Description: Extension table for ECE_AR_TRX_ALLOWANCE_CHARGES.
Primary Key: ECE_AR_TRX_ALLOWAN_CHARG_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_AR_TRX_ALLOWANCE_CHARGES_X does not reference any database object
EC.ECE_AR_TRX_ALLOWANCE_CHARGES_X is referenced by following:
EC
VIEW - ECE_AR_TRX_ALLOWANCE_CHARGES_#
[top of page]
Table: ECE_AR_TRX_HEADERS
Description: Contains the customer invoice header data to support the outbound Invoice (810/INVOIC) transaction.
Primary Key: TC_DOCUMENT_ID
TP_DOCUMENT_ID
[top of page]
EC.ECE_AR_TRX_HEADERS does not reference any database object
EC.ECE_AR_TRX_HEADERS is referenced by following:
EC
VIEW - ECE_AR_TRX_HEADERS#
[top of page]
Table: ECE_AR_TRX_HEADERS_X
Description: Extension table for ECE_AR_TRX_HEADERS.
Primary Key: ECE_AR_TRX_HEADERS_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_AR_TRX_HEADERS_X does not reference any database object
EC.ECE_AR_TRX_HEADERS_X is referenced by following:
EC
VIEW - ECE_AR_TRX_HEADERS_X#
[top of page]
Table: ECE_AR_TRX_HEADER_1
Description: Contains the customer invoice header data to support the outbound Invoice (810/INVOIC) transaction. Continuation of ECE_AR_TRX_HEADERS.
Primary Key: ECE_AR_TRX_HEADER_1_PK
TRANSACTION_ID
[top of page]
EC.ECE_AR_TRX_HEADER_1 does not reference any database object
EC.ECE_AR_TRX_HEADER_1 is referenced by following:
EC
VIEW - ECE_AR_TRX_HEADER_1#
[top of page]
Table: ECE_AR_TRX_HEADER_1_X
Description: Extension table for ECE_AR_TRX_HEADER_1.
Primary Key: ECE_AR_TRX_HEADER_1_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_AR_TRX_HEADER_1_X does not reference any database object
EC.ECE_AR_TRX_HEADER_1_X is referenced by following:
EC
VIEW - ECE_AR_TRX_HEADER_1_X#
[top of page]
Table: ECE_AR_TRX_LINES
Description: Contains the customer invoice line data to support the outbound Invoice (810/INVOIC) transaction.
Primary Key: ECE_AR_TRX_LINES_PK
LINE_NUMBER
[top of page]
EC.ECE_AR_TRX_LINES does not reference any database object
EC.ECE_AR_TRX_LINES is referenced by following:
EC
VIEW - ECE_AR_TRX_LINES#
[top of page]
Table: ECE_AR_TRX_LINES_X
Description: Extension table for ECE_AR_TRX_LINES.
Primary Key: ECE_AR_TRX_LINEX_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_AR_TRX_LINES_X does not reference any database object
EC.ECE_AR_TRX_LINES_X is referenced by following:
EC
VIEW - ECE_AR_TRX_LINES_X#
[top of page]
Table: ECE_AR_TRX_LINE_TAX
Description: Contains the customer invoice line tax data to support the outbound Invoice (810/INVOIC) transaction.
Primary Key: TRANSACTION_ID
TRANSACTION_ID
[top of page]
EC.ECE_AR_TRX_LINE_TAX does not reference any database object
EC.ECE_AR_TRX_LINE_TAX is referenced by following:
EC
VIEW - ECE_AR_TRX_LINE_TAX#
[top of page]
Table: ECE_AR_TRX_LINE_TAX_X
Description: Extension table for ECE_AR_TRX_LINE_TAX.
Primary Key: ECE_AR_TRX_LINE_TAX_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_AR_TRX_LINE_TAX_X does not reference any database object
EC.ECE_AR_TRX_LINE_TAX_X is referenced by following:
EC
VIEW - ECE_AR_TRX_LINE_TAX_X#
[top of page]
Table: ECE_ATTACHMENT_DETAILS
Description: Contains the temporary detail data for extracting attachments.
[top of page]
EC.ECE_ATTACHMENT_DETAILS does not reference any database object
EC.ECE_ATTACHMENT_DETAILS is referenced by following:
EC
VIEW - ECE_ATTACHMENT_DETAILS#
[top of page]
Table: ECE_ATTACHMENT_DETAILS_X
Description: Extension table for ECE_ATTACHMENT_DETAILS.
[top of page]
EC.ECE_ATTACHMENT_DETAILS_X does not reference any database object
EC.ECE_ATTACHMENT_DETAILS_X is referenced by following:
EC
VIEW - ECE_ATTACHMENT_DETAILS_X#
[top of page]
Table: ECE_ATTACHMENT_HEADERS
Description: Contains the temporary header data for extracting attachments.
[top of page]
EC.ECE_ATTACHMENT_HEADERS does not reference any database object
EC.ECE_ATTACHMENT_HEADERS is referenced by following:
EC
VIEW - ECE_ATTACHMENT_HEADERS#
[top of page]
Table: ECE_ATTACHMENT_HEADERS_X
Description: Extension table for ECE_ATTACHMENT_HEADERS.
[top of page]
EC.ECE_ATTACHMENT_HEADERS_X does not reference any database object
EC.ECE_ATTACHMENT_HEADERS_X is referenced by following:
EC
VIEW - ECE_ATTACHMENT_HEADERS_X#
[top of page]
Table: ECE_COLUMN_RULES
Description: Contains the column rule assignments.
Primary Key: ECE_COLUMN_RULES_PK
COLUMN_RULE_ID
[top of page]
EC.ECE_COLUMN_RULES does not reference any database object
EC.ECE_COLUMN_RULES is referenced by following:
EC
VIEW - ECE_COLUMN_RULES#
[top of page]
Table: ECE_COLUMN_RULES_UPG
[top of page]
EC.ECE_COLUMN_RULES_UPG does not reference any database object
EC.ECE_COLUMN_RULES_UPG is referenced by following:
EC
VIEW - ECE_COLUMN_RULES_UPG#
[top of page]
Table: ECE_ERROR
Description: Contains the Oracle EDI Gateway processing error messages used by Development for debugging purposes.
Primary Key: ECE_ERROR_PK
RUN_ID
LINE_ID
[top of page]
EC.ECE_ERROR does not reference any database object
EC.ECE_ERROR is referenced by following:
EC
VIEW - ECE_ERROR#
[top of page]
Table: ECE_EXTERNAL_LEVELS
Description: Contains the information about the external levels for a given transaction and map.
Primary Key: ECE_EXTERNAL_LEVELS_PK
EXTERNAL_LEVEL_ID
[top of page]
EC.ECE_EXTERNAL_LEVELS does not reference any database object
EC.ECE_EXTERNAL_LEVELS is referenced by following:
EC
VIEW - ECE_EXTERNAL_LEVELS#
[top of page]
Table: ECE_EXTERNAL_LEVELS_UPG
Primary Key: OCO_18586770
EXTERNAL_LEVEL_ID
[top of page]
EC.ECE_EXTERNAL_LEVELS_UPG does not reference any database object
EC.ECE_EXTERNAL_LEVELS_UPG is referenced by following:
EC
VIEW - ECE_EXTERNAL_LEVELS_UPG#
[top of page]
Table: ECE_INTERFACE_COLS_UPG
Description: Contains the interface file definitions for each EDI transaction.
Primary Key: OCO_18586803
INTERFACE_COLUMN_ID
[top of page]
EC.ECE_INTERFACE_COLS_UPG does not reference any database object
EC.ECE_INTERFACE_COLS_UPG is referenced by following:
EC
VIEW - ECE_INTERFACE_COLS_UPG#
[top of page]
Table: ECE_INTERFACE_COLUMNS
Description: Contains the interface file definitions for each EDI transaction.
Primary Key: ECE_INTERFACE_COLUMNS_PK
INTERFACE_COLUMN_ID
Primary Key: EIC1_UK
Foreign Keys from this table:
Foreign Key Column
Foreign Table
ECE_INTERFACE_COLUMNS.XREF_CATEGORY_ID
ECE_XREF_CATEGORIES
ECE_INTERFACE_COLUMNS.INTERFACE_TABLE_ID
ECE_INTERFACE_TABLES
[top of page]
EC.ECE_INTERFACE_COLUMNS does not reference any database object
EC.ECE_INTERFACE_COLUMNS is referenced by following:
EC
VIEW - ECE_INTERFACE_COLUMNS#
[top of page]
Table: ECE_INTERFACE_TABLES
Description: Contains the information regarding the interface and extension tables used to support each EDI transaction.
Primary Key: ECE_INTERFACE_TABLES_PK
INTERFACE_TABLE_ID
Primary Key: EIT1_UK
Foreign Keys to this table:
Foreign Key Column
Foreign Table
ECE_INTERFACE_COLUMNS.INTERFACE_TABLE_ID
ECE_INTERFACE_TABLES
[top of page]
EC.ECE_INTERFACE_TABLES does not reference any database object
EC.ECE_INTERFACE_TABLES is referenced by following:
EC
VIEW - ECE_INTERFACE_TABLES#
[top of page]
Table: ECE_INTERFACE_TBLS_UPG
Description: Contains the information regarding the interface and extension tables used to support each EDI transaction.
Primary Key: OCO_18586890
INTERFACE_TABLE_ID
[top of page]
EC.ECE_INTERFACE_TBLS_UPG does not reference any database object
EC.ECE_INTERFACE_TBLS_UPG is referenced by following:
EC
VIEW - ECE_INTERFACE_TBLS_UPG#
[top of page]
Table: ECE_LEVEL_MATRICES
Description: Intersection table for ECE_INTERFACE_TABLE and ECE_EXTERNAL_LEVELS.
Primary Key: ECE_LEVEL_MATRICES_PK
MATRIX_LEVEL_ID
[top of page]
EC.ECE_LEVEL_MATRICES does not reference any database object
EC.ECE_LEVEL_MATRICES is referenced by following:
EC
VIEW - ECE_LEVEL_MATRICES#
[top of page]
Table: ECE_LEVEL_MATRICES_UPG
Primary Key: OCO_18586901
MATRIX_LEVEL_ID
[top of page]
EC.ECE_LEVEL_MATRICES_UPG does not reference any database object
EC.ECE_LEVEL_MATRICES_UPG is referenced by following:
EC
VIEW - ECE_LEVEL_MATRICES_UPG#
[top of page]
Table: ECE_MAPPINGS
Description: Contains the information about maps for a given transaction.
Primary Key: ECE_MAPPINGS_PK
MAP_ID
[top of page]
EC.ECE_MAPPINGS does not reference any database object
EC.ECE_MAPPINGS is referenced by following:
EC
VIEW - ECE_MAPPINGS#
[top of page]
Table: ECE_MAPPINGS_UPG
Description: Upgrade table for ECE_MAPPINGS
Primary Key: OCO_18586913
MAP_ID
[top of page]
EC.ECE_MAPPINGS_UPG does not reference any database object
EC.ECE_MAPPINGS_UPG is referenced by following:
EC
VIEW - ECE_MAPPINGS_UPG#
[top of page]
Table: ECE_MVSTO_DETAILS
Description: Contains the detail level information for the outbound Movement Statistics transaction.
[top of page]
EC.ECE_MVSTO_DETAILS does not reference any database object
EC.ECE_MVSTO_DETAILS is referenced by following:
EC
VIEW - ECE_MVSTO_DETAILS#
[top of page]
Table: ECE_MVSTO_DETAILS_X
Description: Extension table for ECE_MVSTO_DETAILS.
[top of page]
EC.ECE_MVSTO_DETAILS_X does not reference any database object
EC.ECE_MVSTO_DETAILS_X is referenced by following:
EC
VIEW - ECE_MVSTO_DETAILS_X#
[top of page]
Table: ECE_MVSTO_HEADERS
Description: Contains the movement statistics header data to support the outbound Movement Statistics transaction.
[top of page]
EC.ECE_MVSTO_HEADERS does not reference any database object
EC.ECE_MVSTO_HEADERS is referenced by following:
EC
VIEW - ECE_MVSTO_HEADERS#
[top of page]
Table: ECE_MVSTO_HEADERS_X
Description: Extension table for ECE_MVSTO_HEADERS.
[top of page]
EC.ECE_MVSTO_HEADERS_X does not reference any database object
EC.ECE_MVSTO_HEADERS_X is referenced by following:
EC
VIEW - ECE_MVSTO_HEADERS_X#
[top of page]
Table: ECE_MVSTO_LOCATIONS
Description: Contains the location information for outbound Movement Statistics transaction.
[top of page]
EC.ECE_MVSTO_LOCATIONS does not reference any database object
EC.ECE_MVSTO_LOCATIONS is referenced by following:
EC
VIEW - ECE_MVSTO_LOCATIONS#
[top of page]
Table: ECE_MVSTO_LOCATIONS_X
Description: Extension table for ECE_MVSTO_LOCATIONS.
[top of page]
EC.ECE_MVSTO_LOCATIONS_X does not reference any database object
EC.ECE_MVSTO_LOCATIONS_X is referenced by following:
EC
VIEW - ECE_MVSTO_LOCATIONS_X#
[top of page]
Table: ECE_OUTPUT
Description: Contains the contents of the interface file to be created by the e-Commerce Gateway extract program.
Primary Key: ECE_OUTPUT_PK
RUN_ID
LINE_ID
[top of page]
EC.ECE_OUTPUT does not reference any database object
EC.ECE_OUTPUT is referenced by following:
EC
VIEW - ECE_OUTPUT#
[top of page]
Table: ECE_PO_DISTRIBUTIONS
Description: Contains temporary project data and PO distributions to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
[top of page]
EC.ECE_PO_DISTRIBUTIONS does not reference any database object
EC.ECE_PO_DISTRIBUTIONS is referenced by following:
EC
VIEW - ECE_PO_DISTRIBUTIONS#
[top of page]
Table: ECE_PO_DISTRIBUTIONS_X
Description: Extension table for ECE_PO_DISTRIBUTIONS.
[top of page]
EC.ECE_PO_DISTRIBUTIONS_X does not reference any database object
EC.ECE_PO_DISTRIBUTIONS_X is referenced by following:
EC
VIEW - ECE_PO_DISTRIBUTIONS_X#
[top of page]
Table: ECE_PO_INTERFACE_HEADERS
Description: Contains the purchase order header data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
[top of page]
EC.ECE_PO_INTERFACE_HEADERS does not reference any database object
EC.ECE_PO_INTERFACE_HEADERS is referenced by following:
EC
VIEW - ECE_PO_INTERFACE_HEADERS#
[top of page]
Table: ECE_PO_INTERFACE_HEADERS_X
Description: Extension table for ECE_PO_INTERFACE_HEADERS.
Primary Key: ECE_PO_INTERFACE_HEADERS_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_PO_INTERFACE_HEADERS_X does not reference any database object
EC.ECE_PO_INTERFACE_HEADERS_X is referenced by following:
EC
VIEW - ECE_PO_INTERFACE_HEADERS_X#
[top of page]
Table: ECE_PO_INTERFACE_LINES
Description: Contains the purchase order line data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
[top of page]
EC.ECE_PO_INTERFACE_LINES does not reference any database object
EC.ECE_PO_INTERFACE_LINES is referenced by following:
EC
VIEW - ECE_PO_INTERFACE_LINES#
[top of page]
Table: ECE_PO_INTERFACE_LINES_X
Description: Extension table for ECE_PO_INTERFACE_LINES.
Primary Key: ECE_PO_INTERFACE_LINES_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_PO_INTERFACE_LINES_X does not reference any database object
EC.ECE_PO_INTERFACE_LINES_X is referenced by following:
EC
VIEW - ECE_PO_INTERFACE_LINES_X#
[top of page]
Table: ECE_PO_INTERFACE_SHIPMENTS
Description: Contains the purchase order shipment data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
[top of page]
EC.ECE_PO_INTERFACE_SHIPMENTS does not reference any database object
EC.ECE_PO_INTERFACE_SHIPMENTS is referenced by following:
EC
VIEW - ECE_PO_INTERFACE_SHIPMENTS#
[top of page]
Table: ECE_PO_INTERFACE_SHIPMENTS_X
Description: Extension table for ECE_PO_INTERFACE_SHIPMENTS.
Primary Key: ECE_PO_INTERFACE_SHIPMENTS_X_P
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_PO_INTERFACE_SHIPMENTS_X does not reference any database object
EC.ECE_PO_INTERFACE_SHIPMENTS_X is referenced by following:
EC
VIEW - ECE_PO_INTERFACE_SHIPMENTS_X#
[top of page]
Table: ECE_PO_PROJECT_INFO
Description: Contains temporary project data to support the outbound Purchase Order (850/ORDERS) and Purchase Order Change (860/ORDCHG) transactions.
[top of page]
EC.ECE_PO_PROJECT_INFO does not reference any database object
EC.ECE_PO_PROJECT_INFO is referenced by following:
EC
VIEW - ECE_PO_PROJECT_INFO#
[top of page]
Table: ECE_PO_PROJECT_INFO_X
Description: Extension table for ECE_PO_PROJECT_INFO.
[top of page]
EC.ECE_PO_PROJECT_INFO_X does not reference any database object
EC.ECE_PO_PROJECT_INFO_X is referenced by following:
EC
VIEW - ECE_PO_PROJECT_INFO_X#
[top of page]
Table: ECE_PROCEDURE_MAPPINGS
Description: Contains the information for calling procedures.
Primary Key: ECE_PROCEDURE_MAPPINGS_PK
PROCMAP_ID
[top of page]
EC.ECE_PROCEDURE_MAPPINGS does not reference any database object
EC.ECE_PROCEDURE_MAPPINGS is referenced by following:
EC
VIEW - ECE_PROCEDURE_MAPPINGS#
[top of page]
Table: ECE_PROCESS_RULES
Description: Contains the process rule assignements.
Primary Key: ECE_PROCESS_RULES_PK
PROCESS_RULE_ID
[top of page]
EC.ECE_PROCESS_RULES does not reference any database object
EC.ECE_PROCESS_RULES is referenced by following:
EC
VIEW - ECE_PROCESS_RULES#
[top of page]
Table: ECE_PROCESS_RULES_UPG
Description: Upgrade table for ECE_PROCESS_RULES
[top of page]
EC.ECE_PROCESS_RULES_UPG does not reference any database object
EC.ECE_PROCESS_RULES_UPG is referenced by following:
EC
VIEW - ECE_PROCESS_RULES_UPG#
[top of page]
Table: ECE_PROC_MAPPINGS_UPG
Description: Upgrade table for ECE_PROCEDURE_MAPPINGS
Primary Key: OCO_18586929
PROCMAP_ID
[top of page]
EC.ECE_PROC_MAPPINGS_UPG does not reference any database object
EC.ECE_PROC_MAPPINGS_UPG is referenced by following:
EC
VIEW - ECE_PROC_MAPPINGS_UPG#
[top of page]
Table: ECE_RULE_LIST
Description: Contains the column list rule information.
Primary Key: ECE_RULE_LIST_PK
LIST_RULE_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
ECE_RULE_LIST_DETAILS.LIST_RULE_ID
ECE_RULE_LIST
[top of page]
EC.ECE_RULE_LIST does not reference any database object
EC.ECE_RULE_LIST is referenced by following:
EC
VIEW - ECE_RULE_LIST#
[top of page]
Table: ECE_RULE_LIST_DETAILS
Description: Contains the column rule list detail information.
Primary Key: ECE_RULE_LIST_DETAILS_PK
LIST_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
ECE_RULE_LIST_DETAILS.LIST_RULE_ID
ECE_RULE_LIST
[top of page]
EC.ECE_RULE_LIST_DETAILS does not reference any database object
EC.ECE_RULE_LIST_DETAILS is referenced by following:
EC
VIEW - ECE_RULE_LIST_DETAILS#
[top of page]
Table: ECE_RULE_NULL_DEFAULT
Description: Contains the column rule null default information.
Primary Key: ECE_RULE_NULL_DEFAULT_PK
NULL_DEFAULT_ID
[top of page]
EC.ECE_RULE_NULL_DEFAULT does not reference any database object
EC.ECE_RULE_NULL_DEFAULT is referenced by following:
EC
VIEW - ECE_RULE_NULL_DEFAULT#
[top of page]
Table: ECE_RULE_NULL_DEP
Description: Contains the column rule null dependency information.
Primary Key: ECE_RULE_NULL_DEP_PK
NULL_DEPENDENCY_RULE_ID
Foreign Keys to this table:
Foreign Key Column
Foreign Table
ECE_RULE_NULL_DEP_DETAILS.NULL_DEPENDENCY_RULE_ID
ECE_RULE_NULL_DEP
[top of page]
EC.ECE_RULE_NULL_DEP does not reference any database object
EC.ECE_RULE_NULL_DEP is referenced by following:
EC
VIEW - ECE_RULE_NULL_DEP#
[top of page]
Table: ECE_RULE_NULL_DEP_DETAILS
Description: Child table to ECE_RULE_NULL_DEP.
Primary Key: ECE_RULE_NULL_DEP_DETAILS_PK
NULL_DEPENDENCY_DETAIL_ID
Foreign Keys from this table:
Foreign Key Column
Foreign Table
ECE_RULE_NULL_DEP_DETAILS.NULL_DEPENDENCY_RULE_ID
ECE_RULE_NULL_DEP
[top of page]
EC.ECE_RULE_NULL_DEP_DETAILS does not reference any database object
EC.ECE_RULE_NULL_DEP_DETAILS is referenced by following:
EC
VIEW - ECE_RULE_NULL_DEP_DETAILS#
[top of page]
Table: ECE_RULE_SIMPLE_LOOKUP
Description: Contains the column rule simple lookup information.
Primary Key: ECE_RULE_SIMPLE_LOOKUP_PK
LOOKUP_RULE_ID
[top of page]
EC.ECE_RULE_SIMPLE_LOOKUP does not reference any database object
EC.ECE_RULE_SIMPLE_LOOKUP is referenced by following:
EC
VIEW - ECE_RULE_SIMPLE_LOOKUP#
[top of page]
Table: ECE_RULE_VALUESET
Description: Contains the column rule valueset information.
Primary Key: ECE_RULE_VALUESET_PK
VALUESET_RULE_ID
[top of page]
EC.ECE_RULE_VALUESET does not reference any database object
EC.ECE_RULE_VALUESET is referenced by following:
EC
VIEW - ECE_RULE_VALUESET#
[top of page]
Table: ECE_RULE_VIOLATIONS
Description: Contains the information about rule violations.
Primary Key: ECE_RULE_VIOLATIONS_PK
VIOLATION_ID
[top of page]
EC.ECE_RULE_VIOLATIONS does not reference any database object
EC.ECE_RULE_VIOLATIONS is referenced by following:
EC
VIEW - ECE_RULE_VIOLATIONS#
[top of page]
Table: ECE_SPSO_HEADERS
Description: Contains the supplier schedule header data to support the outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transactions.
Primary Key: ECE_SPSO_HEADERS_PK
SCHEDULE_ID
RUN_ID
[top of page]
EC.ECE_SPSO_HEADERS does not reference any database object
EC.ECE_SPSO_HEADERS is referenced by following:
EC
VIEW - ECE_SPSO_HEADERS#
[top of page]
Table: ECE_SPSO_HEADERS_X
Description: Extension table for ECE_SPSO_HEADERS.
Primary Key: ECE_SPSO_HEADERS_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_SPSO_HEADERS_X does not reference any database object
EC.ECE_SPSO_HEADERS_X is referenced by following:
EC
VIEW - ECE_SPSO_HEADERS_X#
[top of page]
Table: ECE_SPSO_ITEMS
Description: Contains the supplier schedule line data to support the outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transactions.
Primary Key: ECE_SPSO_ITEMS_PK
SCHEDULE_ITEM_ID
SCHEDULE_ID
RUN_ID
[top of page]
EC.ECE_SPSO_ITEMS does not reference any database object
EC.ECE_SPSO_ITEMS is referenced by following:
EC
VIEW - ECE_SPSO_ITEMS#
[top of page]
Table: ECE_SPSO_ITEMS_X
Description: Extension table for ECE_SPSO_ITEMS.
Primary Key: ECE_SPSO_ITEMS_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_SPSO_ITEMS_X does not reference any database object
EC.ECE_SPSO_ITEMS_X is referenced by following:
EC
VIEW - ECE_SPSO_ITEMS_X#
[top of page]
Table: ECE_SPSO_ITEM_DET
Description: Contains the supplier schedule item detail data to support outbound Planning Schedule (830/DELFOR) and Shipping Schedule (862/DELJIT) transactions.
Primary Key: ECE_SPSO_ITEM_DET_PK
SCHEDULE_ITEM_DETAIL_SEQUENCE
SCHEDULE_ID
SCHEDULE_ITEM_ID
RUN_ID
[top of page]
EC.ECE_SPSO_ITEM_DET does not reference any database object
EC.ECE_SPSO_ITEM_DET is referenced by following:
EC
VIEW - ECE_SPSO_ITEM_DET#
[top of page]
Table: ECE_SPSO_ITEM_DET_X
Description: Extension table for ECE_SPSO_ITEM_DET.
Primary Key: ECE_SPSO_ITEM_DET_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_SPSO_ITEM_DET_X does not reference any database object
EC.ECE_SPSO_ITEM_DET_X is referenced by following:
EC
VIEW - ECE_SPSO_ITEM_DET_X#
[top of page]
Table: ECE_SPSO_SHIP_DET
Description: ECE_SPSO_SHIP_DET
Primary Key: ECE_SPSO_SHIP_DET_PK
SCHEDULE_SHIP_ID
SCHEDULE_ID
SCHEDULE_ITEM_ID
SCHEDULE_ITEM_DETAIL_SEQUENCE
RUN_ID
[top of page]
EC.ECE_SPSO_SHIP_DET does not reference any database object
EC.ECE_SPSO_SHIP_DET is referenced by following:
EC
VIEW - ECE_SPSO_SHIP_DET#
[top of page]
Table: ECE_SPSO_SHIP_DET_X
Description: ECE_SPSO_SHIP_DET
Primary Key: ECE_SPSO_SHIP_DET_X_PK
TRANSACTION_RECORD_ID
[top of page]
EC.ECE_SPSO_SHIP_DET_X does not reference any database object
EC.ECE_SPSO_SHIP_DET_X is referenced by following:
EC
VIEW - ECE_SPSO_SHIP_DET_X#
[top of page]
Table: ECE_STAGE
Description: Inbound staging table.
Primary Key: ECE_STAGE_PK
STAGE_ID
[top of page]
EC.ECE_STAGE does not reference any database object
EC.ECE_STAGE is referenced by following:
EC
VIEW - ECE_STAGE#
[top of page]
Table: ECE_TP_DETAILS
Description: Contains the information for the trading partner processing rules.
Primary Key: ECE_TP_DETAILS_PK
TP_DETAIL_ID
Primary Key: ETD1_UK
Foreign Keys from this table:
Foreign Key Column
Foreign Table
ECE_TP_DETAILS.TP_HEADER_ID
ECE_TP_HEADERS
[top of page]
EC.ECE_TP_DETAILS does not reference any database object
EC.ECE_TP_DETAILS is referenced by following:
EC
VIEW - ECE_TP_DETAILS#
[top of page]
Table: ECE_TP_GROUP
Description: Contains the information for a trading partner group representing a collection of trading partner definitions.
Primary Key: ECE_TP_GROUP_PK
TP_GROUP_ID
Primary Key: ETG1_UK
Foreign Keys to this table:
Foreign Key Column
Foreign Table
ECE_TP_HEADERS.TP_GROUP_ID
ECE_TP_GROUP
[top of page]
EC.ECE_TP_GROUP does not reference any database object
EC.ECE_TP_GROUP is referenced by following:
EC
VIEW - ECE_TP_GROUP#
[top of page]
Table: ECE_TP_HEADERS
Description: Contains the information for trading partner address entity.
Primary Key: ECE_TP_HEADERS_PK
TP_HEADER_ID
Primary Key: ETH1_UK
Foreign Keys from this table:
Foreign Key Column
Foreign Table
ECE_TP_HEADERS.TP_GROUP_ID
ECE_TP_GROUP
Foreign Keys to this table:
Foreign Key Column
Foreign Table
AP_BANK_BRANCHES.TP_HEADER_ID
ECE_TP_HEADERS
ECE_TP_DETAILS.TP_HEADER_ID
ECE_TP_HEADERS
[top of page]
EC.ECE_TP_HEADERS does not reference any database object
EC.ECE_TP_HEADERS is referenced by following:
EC
VIEW - ECE_TP_HEADERS#
[top of page]
Table: ECE_TRAN_PARAMETERS
Description: Generic inbound/outbound execution engine seed data for the parameters corresponding to a transaction.
Primary Key: ECE_TRAN_PARAMETERS_PK
PARAMETER_ID
[top of page]
EC.ECE_TRAN_PARAMETERS does not reference any database object
EC.ECE_TRAN_PARAMETERS is referenced by following:
EC
VIEW - ECE_TRAN_PARAMETERS#
[top of page]
Table: ECE_TRAN_STAGE_DATA
Description: Contains the seed data for the dynamic execution of the inbound/outbound transactions.
Primary Key: ECE_TRAN_STAGE_DATA_PK
TRANSTAGE_ID
[top of page]
EC.ECE_TRAN_STAGE_DATA does not reference any database object
EC.ECE_TRAN_STAGE_DATA is referenced by following:
EC
VIEW - ECE_TRAN_STAGE_DATA#
[top of page]
Table: ECE_TRAN_STAGE_DATA_UPG
[top of page]
EC.ECE_TRAN_STAGE_DATA_UPG does not reference any database object
EC.ECE_TRAN_STAGE_DATA_UPG is referenced by following:
EC
VIEW - ECE_TRAN_STAGE_DATA_UPG#
[top of page]
Table: ECE_XREF_CATEGORIES
Description: Contains the code conversion categories information. Rows contain category code, description, and up to five processing flags.
Primary Key: ECE_XREF_CATEGORIES_PK
XREF_CATEGORY_ID
Primary Key: EXC1_UK
Foreign Keys to this table:
Foreign Key Column
Foreign Table
ECE_INTERFACE_COLUMNS.XREF_CATEGORY_ID
ECE_XREF_CATEGORIES
ECE_XREF_DATA.XREF_CATEGORY_ID
ECE_XREF_CATEGORIES
[top of page]
EC.ECE_XREF_CATEGORIES does not reference any database object
EC.ECE_XREF_CATEGORIES is referenced by following:
EC
VIEW - ECE_XREF_CATEGORIES#
[top of page]
Table: ECE_XREF_DATA
Description: Contains the information for code conversions which identify external values for a given Oracle internal value and vice versa.
Primary Key: ECE_XREF_DATE_PK
XREF_DATA_ID
Primary Key: EXD1_UK
Foreign Keys from this table:
Foreign Key Column
Foreign Table
ECE_XREF_DATA.XREF_CATEGORY_ID
ECE_XREF_CATEGORIES
[top of page]
EC.ECE_XREF_DATA does not reference any database object
EC.ECE_XREF_DATA is referenced by following:
EC
VIEW - ECE_XREF_DATA#
[top of page]
View: ECE_ADVO_DETAILS_V
[top of page]
APPS.ECE_ADVO_DETAILS_V references the following:
APPS
SYNONYM - ECE_ADVO_DETAILS
APPS.ECE_ADVO_DETAILS_V is not referenced by any database object
[top of page]
View: ECE_ADVO_HEADERS_V
[top of page]
APPS.ECE_ADVO_HEADERS_V references the following:
APPS
SYNONYM - ECE_ADVO_HEADERS
SYNONYM - ECE_TP_DETAILS
SYNONYM - ECE_TP_GROUP
SYNONYM - ECE_TP_HEADERS
APPS.ECE_ADVO_HEADERS_V is not referenced by any database object
[top of page]
View: ECE_ATTACHMENT_V
[top of page]
APPS.ECE_ATTACHMENT_V references the following:
APPS
SYNONYM - FND_ATTACHED_DOCUMENTS
SYNONYM - FND_DOCUMENTS
SYNONYM - FND_DOCUMENTS_LONG_TEXT
SYNONYM - FND_DOCUMENTS_SHORT_TEXT
SYNONYM - FND_DOCUMENT_CATEGORIES_TL
- FND_DOCUMENTS_VL
APPS.ECE_ATTACHMENT_V is not referenced by any database object
[top of page]
View: ECE_CDMO_ALLOWANCE_CHARGES_V
[top of page]
APPS.ECE_CDMO_ALLOWANCE_CHARGES_V references the following:
APPS
SYNONYM - RA_CUSTOMER_TRX_LINES
APPS.ECE_CDMO_ALLOWANCE_CHARGES_V is not referenced by any database object
[top of page]
View: ECE_CDMO_HEADER_1_V
[top of page]
APPS.ECE_CDMO_HEADER_1_V references the following:
APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_ORGANIZATION_INFORMATION
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
SYNONYM - RA_CUSTOMER_TRX
SYNONYM - RA_CUSTOMER_TRX_LINES
SYNONYM - WSH_DELIVERY_DETAILS
SYNONYM - WSH_DELIVERY_LEGS
SYNONYM - WSH_DOCUMENT_INSTANCES
SYNONYM - WSH_TRIPS
SYNONYM - WSH_TRIP_STOPS
- GL_SETS_OF_BOOKS
APPS.ECE_CDMO_HEADER_1_V is not referenced by any database object
[top of page]
View: ECE_CDMO_HEADER_V
[top of page]
APPS.ECE_CDMO_HEADER_V references the following:
APPS
SYNONYM - AR_BATCH_SOURCES
SYNONYM - AR_PAYMENT_SCHEDULES
SYNONYM - AR_SYSTEM_PARAMETERS
SYNONYM - ECE_TP_DETAILS
SYNONYM - ECE_TP_HEADERS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - RA_CUSTOMER_TRX
SYNONYM - RA_CUST_TRX_TYPES
VIEW - RA_SALESREPS
SYNONYM - RA_TERMS
SYNONYM - RA_TERMS_LINES
- GL_SETS_OF_BOOKS
APPS.ECE_CDMO_HEADER_V is not referenced by any database object
[top of page]
View: ECE_CDMO_LINE_TAX_V
[top of page]
APPS.ECE_CDMO_LINE_TAX_V references the following:
APPS
SYNONYM - AR_VAT_TAX
SYNONYM - RA_CUSTOMER_TRX
SYNONYM - RA_CUSTOMER_TRX_LINES
APPS.ECE_CDMO_LINE_TAX_V is not referenced by any database object
[top of page]
View: ECE_CDMO_LINE_V
[top of page]
APPS.ECE_CDMO_LINE_V references the following:
APPS
PACKAGE - FND_PROFILE
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - MTL_CUSTOMER_ITEMS
SYNONYM - MTL_PARAMETERS
SYNONYM - OE_ORDER_HEADERS
SYNONYM - OE_ORDER_LINES
SYNONYM - OE_PRICE_ADJUSTMENTS
SYNONYM - RA_CUSTOMER_TRX
SYNONYM - RA_CUSTOMER_TRX_LINES
SYNONYM - WSH_DELIVERY_LEGS
SYNONYM - WSH_DOCUMENT_INSTANCES
SYNONYM - WSH_NEW_DELIVERIES
APPS.ECE_CDMO_LINE_V is not referenced by any database object
[top of page]
View: ECE_CDMO_TRX_NUMBER_V
[top of page]
APPS.ECE_CDMO_TRX_NUMBER_V references the following:
APPS
SYNONYM - ECE_TP_DETAILS
SYNONYM - ECE_TP_HEADERS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_PARTIES
SYNONYM - RA_CUSTOMER_TRX
SYNONYM - RA_CUST_TRX_TYPES
APPS.ECE_CDMO_TRX_NUMBER_V is not referenced by any database object
[top of page]
View: ECE_INO_ALLOWANCE_CHARGES_V
[top of page]
APPS.ECE_INO_ALLOWANCE_CHARGES_V references the following:
APPS
SYNONYM - RA_CUSTOMER_TRX_LINES
APPS.ECE_INO_ALLOWANCE_CHARGES_V is not referenced by any database object
[top of page]
View: ECE_INO_HEADER_1_V
[top of page]
APPS.ECE_INO_HEADER_1_V references the following:
APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_ORGANIZATION_INFORMATION
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
SYNONYM - RA_CUSTOMER_TRX
SYNONYM - RA_CUSTOMER_TRX_LINES
- GL_SETS_OF_BOOKS
APPS.ECE_INO_HEADER_1_V is not referenced by any database object
[top of page]
View: ECE_INO_HEADER_V
[top of page]
APPS.ECE_INO_HEADER_V references the following:
APPS
SYNONYM - AR_PAYMENT_SCHEDULES
PACKAGE - ECE_AR_TRANSACTION
SYNONYM - ECE_TP_DETAILS
SYNONYM - ECE_TP_HEADERS
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
SYNONYM - RA_BATCH_SOURCES
SYNONYM - RA_CUSTOMER_TRX
SYNONYM - RA_CUST_TRX_TYPES
SYNONYM - RA_TERMS_B
SYNONYM - RA_TERMS_LINES
SYNONYM - RA_TERMS_TL
- RA_SALESREPS_ALL
APPS.ECE_INO_HEADER_V is not referenced by any database object
[top of page]
View: ECE_INO_LINE_TAX_V
[top of page]
APPS.ECE_INO_LINE_TAX_V references the following:
APPS
SYNONYM - RA_CUSTOMER_TRX
SYNONYM - RA_CUSTOMER_TRX_LINES
SYNONYM - ZX_RATES_B
SYNONYM - ZX_RATES_TL
SYNONYM - ZX_TAXES_B
APPS.ECE_INO_LINE_TAX_V is not referenced by any database object
[top of page]
View: ECE_INO_LINE_V
[top of page]
APPS.ECE_INO_LINE_V references the following:
APPS
PACKAGE - FND_PROFILE
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - MTL_CUSTOMER_ITEMS
SYNONYM - MTL_PARAMETERS
SYNONYM - OE_ORDER_HEADERS
SYNONYM - OE_ORDER_LINES
SYNONYM - OE_PRICE_ADJUSTMENTS
SYNONYM - RA_CUSTOMER_TRX
SYNONYM - RA_CUSTOMER_TRX_LINES
SYNONYM - WSH_DELIVERY_LEGS
SYNONYM - WSH_DOCUMENT_INSTANCES
SYNONYM - WSH_NEW_DELIVERIES
APPS.ECE_INO_LINE_V is not referenced by any database object
[top of page]
View: ECE_LOOKUP_VALUES
[top of page]
APPS.ECE_LOOKUP_VALUES references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - FND_LOOKUP_VALUES
APPS.ECE_LOOKUP_VALUES is not referenced by any database object
[top of page]
View: ECE_MTL_MOV_STAT_V
[top of page]
APPS.ECE_MTL_MOV_STAT_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - MTL_MOVEMENT_STATISTICS
- FND_LOOKUPS
APPS.ECE_MTL_MOV_STAT_V is referenced by following:
APPS
VIEW - ECE_MVSTO_HEADERS_V
[top of page]
View: ECE_MVSTO_DETAILS_V
[top of page]
APPS.ECE_MVSTO_DETAILS_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - MTL_MOVEMENT_STATISTICS
- FND_LOOKUPS
APPS.ECE_MVSTO_DETAILS_V is not referenced by any database object
[top of page]
View: ECE_MVSTO_HEADERS_V
[top of page]
APPS.ECE_MVSTO_HEADERS_V references the following:
APPS
VIEW - ECE_MTL_MOV_STAT_V
SYNONYM - ECE_TP_DETAILS
SYNONYM - ECE_TP_HEADERS
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
- HR_ORGANIZATION_UNITS
- HR_LEGAL_ENTITIES
- HR_LOCATIONS
APPS.ECE_MVSTO_HEADERS_V is not referenced by any database object
[top of page]
View: ECE_MVSTO_LOCATIONS_V
[top of page]
APPS.ECE_MVSTO_LOCATIONS_V references the following:
APPS
PACKAGE - FND_GLOBAL
SYNONYM - HZ_CUST_ACCOUNTS
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_PARTY_SITES
VIEW - PO_VENDORS
- PO_VENDOR_SITES
APPS.ECE_MVSTO_LOCATIONS_V is not referenced by any database object
[top of page]
View: ECE_POCO_HEADERS_V
[top of page]
APPS.ECE_POCO_HEADERS_V references the following:
APPS
SYNONYM - AP_CARDS
SYNONYM - AP_CARD_PROFILES
SYNONYM - AP_CARD_PROGRAMS
SYNONYM - AP_CARD_SUPPLIERS
SYNONYM - ECE_TP_DETAILS
SYNONYM - ECE_TP_HEADERS
SYNONYM - FINANCIALS_SYSTEM_PARAMETERS
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - IBY_CREDITCARD
SYNONYM - PER_ADDRESSES
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_PHONES
SYNONYM - PO_HEADERS
SYNONYM - PO_HEADERS_ARCHIVE
SYNONYM - PO_LINE_LOCATIONS
SYNONYM - PO_RELEASES
SYNONYM - PO_RELEASES_ARCHIVE
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
- PO_VENDOR_SITES
- HR_LOCATIONS
- AP_TERMS
- FND_CURRENCIES_VL
APPS.ECE_POCO_HEADERS_V is not referenced by any database object
[top of page]
View: ECE_POCO_LINES_V
[top of page]
APPS.ECE_POCO_LINES_V references the following:
APPS
SYNONYM - FINANCIALS_SYSTEM_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_B
SYNONYM - PO_HAZARD_CLASSES_B
SYNONYM - PO_HAZARD_CLASSES_TL
SYNONYM - PO_HEADERS
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS
SYNONYM - PO_RELEASES
SYNONYM - PO_UN_NUMBERS_B
SYNONYM - PO_UN_NUMBERS_TL
- PO_LINE_TYPES
APPS.ECE_POCO_LINES_V is not referenced by any database object
[top of page]
View: ECE_POCO_SHIPMENTS_V
[top of page]
APPS.ECE_POCO_SHIPMENTS_V references the following:
APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - OE_DROP_SHIP_SOURCES
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PO_LINE_LOCATIONS
APPS.ECE_POCO_SHIPMENTS_V is not referenced by any database object
[top of page]
View: ECE_POO_HEADERS_V
[top of page]
APPS.ECE_POO_HEADERS_V references the following:
APPS
SYNONYM - AP_CARDS
SYNONYM - AP_CARD_PROFILES
SYNONYM - AP_CARD_PROGRAMS
SYNONYM - AP_CARD_SUPPLIERS
SYNONYM - ECE_TP_DETAILS
SYNONYM - ECE_TP_HEADERS
SYNONYM - FINANCIALS_SYSTEM_PARAMETERS
PACKAGE - FND_GLOBAL
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - IBY_CREDITCARD
SYNONYM - PER_ADDRESSES
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_PHONES
SYNONYM - PO_HEADERS
SYNONYM - PO_HEADERS_ARCHIVE
SYNONYM - PO_RELEASES
SYNONYM - PO_RELEASES_ARCHIVE
VIEW - PO_VENDORS
VIEW - PO_VENDOR_CONTACTS
- PO_VENDOR_SITES
- HR_LOCATIONS
- AP_TERMS
- FND_CURRENCIES_VL
APPS.ECE_POO_HEADERS_V is not referenced by any database object
[top of page]
View: ECE_POO_LINES_V
[top of page]
APPS.ECE_POO_LINES_V references the following:
APPS
SYNONYM - FINANCIALS_SYSTEM_PARAMETERS
SYNONYM - MTL_SYSTEM_ITEMS_B
SYNONYM - PO_HAZARD_CLASSES_B
SYNONYM - PO_HAZARD_CLASSES_TL
SYNONYM - PO_HEADERS_ALL
SYNONYM - PO_LINES
SYNONYM - PO_LINES_ALL
SYNONYM - PO_LINE_LOCATIONS
SYNONYM - PO_RELEASES
SYNONYM - PO_UN_NUMBERS_B
SYNONYM - PO_UN_NUMBERS_TL
- PO_LINE_TYPES
APPS.ECE_POO_LINES_V is not referenced by any database object
[top of page]
View: ECE_POO_SHIPMENTS_V
[top of page]
APPS.ECE_POO_SHIPMENTS_V references the following:
APPS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
PACKAGE - HR_GENERAL
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - HR_LOCATIONS_ALL_TL
SYNONYM - HZ_CUST_ACCOUNT_ROLES
SYNONYM - HZ_CUST_ACCT_SITES_ALL
SYNONYM - HZ_CUST_SITE_USES_ALL
SYNONYM - HZ_LOCATIONS
SYNONYM - HZ_ORG_CONTACTS
SYNONYM - HZ_PARTIES
SYNONYM - HZ_RELATIONSHIPS
SYNONYM - OE_DROP_SHIP_SOURCES
SYNONYM - OE_ORDER_HEADERS_ALL
SYNONYM - PER_ALL_ASSIGNMENTS_F
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PO_LINE_LOCATIONS
APPS.ECE_POO_SHIPMENTS_V is not referenced by any database object
[top of page]
View: ECE_PO_DISTRIBUTIONS_V
[top of page]
APPS.ECE_PO_DISTRIBUTIONS_V references the following:
APPS
SYNONYM - HR_LOCATIONS_ALL
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PO_DISTRIBUTIONS
SYNONYM - PO_LINE_LOCATIONS
SYNONYM - PO_RELEASES
APPS.ECE_PO_DISTRIBUTIONS_V is not referenced by any database object
[top of page]
View: ECE_PO_PROJECT_INFO_V
[top of page]
APPS.ECE_PO_PROJECT_INFO_V references the following:
APPS
PACKAGE - FND_PROFILE
PACKAGE - PA_CROSS_BUSINESS_GRP
SYNONYM - PA_TASKS
SYNONYM - PO_DISTRIBUTIONS
- PA_PROJECT_UTILS
- PA_PROJECTS_EXPEND_V
APPS.ECE_PO_PROJECT_INFO_V is not referenced by any database object
[top of page]
View: ECE_PROFILE_OPTIONS
[top of page]
APPS.ECE_PROFILE_OPTIONS references the following:
APPS
SYNONYM - FND_PROFILE_OPTION_VALUES
- FND_PROFILE_OPTIONS_VL
APPS.ECE_PROFILE_OPTIONS is not referenced by any database object
[top of page]
View: ECE_PYO_INVOICE_V
[top of page]
APPS.ECE_PYO_INVOICE_V references the following:
APPS
TABLE - IBY_PYO_INVOICE_GT
APPS.ECE_PYO_INVOICE_V is not referenced by any database object
[top of page]
View: ECE_PYO_PAYMENT_V
[top of page]
APPS.ECE_PYO_PAYMENT_V references the following:
APPS
TABLE - IBY_PYO_PAYMENT_GT
APPS.ECE_PYO_PAYMENT_V is not referenced by any database object
[top of page]
View: ECE_SPSO_HEADERS_V
[top of page]
APPS.ECE_SPSO_HEADERS_V references the following:
APPS
SYNONYM - CHV_CUM_PERIODS
SYNONYM - CHV_ITEM_ORDERS
SYNONYM - CHV_ORG_OPTIONS
SYNONYM - CHV_SCHEDULE_HEADERS
SYNONYM - ECE_TP_DETAILS
SYNONYM - ECE_TP_HEADERS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
VIEW - PO_VENDORS
- HR_LOCATIONS
- PO_VENDOR_SITES
APPS.ECE_SPSO_HEADERS_V is not referenced by any database object
[top of page]
View: ECE_SPSO_ITEMS_V
[top of page]
APPS.ECE_SPSO_ITEMS_V references the following:
APPS
SYNONYM - CHV_CUM_PERIODS
SYNONYM - CHV_ITEM_ORDERS
SYNONYM - CHV_ORG_OPTIONS
SYNONYM - CHV_SCHEDULE_HEADERS
SYNONYM - CHV_SCHEDULE_ITEMS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_PHONES
SYNONYM - PO_HAZARD_CLASSES_B
SYNONYM - PO_HAZARD_CLASSES_TL
SYNONYM - PO_HEADERS
SYNONYM - PO_LINES
SYNONYM - PO_UN_NUMBERS_B
SYNONYM - PO_UN_NUMBERS_TL
- MTL_UNITS_OF_MEASURE
- HR_LOCATIONS
- MTL_ITEM_FLEXFIELDS
APPS.ECE_SPSO_ITEMS_V is not referenced by any database object
[top of page]
View: ECE_SSSO_HEADERS_V
[top of page]
APPS.ECE_SSSO_HEADERS_V references the following:
APPS
SYNONYM - CHV_CUM_PERIODS
SYNONYM - CHV_ITEM_ORDERS
SYNONYM - CHV_ORG_OPTIONS
SYNONYM - CHV_SCHEDULE_HEADERS
SYNONYM - ECE_TP_DETAILS
SYNONYM - ECE_TP_HEADERS
PACKAGE - FND_GLOBAL
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
VIEW - PO_VENDORS
- HR_LOCATIONS
- PO_VENDOR_SITES
APPS.ECE_SSSO_HEADERS_V is not referenced by any database object
[top of page]
View: ECE_SSSO_ITEMS_V
[top of page]
APPS.ECE_SSSO_ITEMS_V references the following:
APPS
SYNONYM - CHV_CUM_PERIODS
SYNONYM - CHV_ITEM_ORDERS
SYNONYM - CHV_ORG_OPTIONS
SYNONYM - CHV_SCHEDULE_HEADERS
SYNONYM - CHV_SCHEDULE_ITEMS
SYNONYM - HR_ALL_ORGANIZATION_UNITS
SYNONYM - HR_ALL_ORGANIZATION_UNITS_TL
PACKAGE - HR_GENERAL
PACKAGE - HR_SECURITY
SYNONYM - MTL_PARAMETERS
SYNONYM - PER_ALL_PEOPLE_F
SYNONYM - PER_PHONES
SYNONYM - PO_HAZARD_CLASSES_B
SYNONYM - PO_HAZARD_CLASSES_TL
SYNONYM - PO_HEADERS
SYNONYM - PO_LINES
SYNONYM - PO_UN_NUMBERS_B
SYNONYM - PO_UN_NUMBERS_TL
- MTL_UNITS_OF_MEASURE
- HR_LOCATIONS
- MTL_ITEM_FLEXFIELDS
APPS.ECE_SSSO_ITEMS_V is not referenced by any database object
[top of page]
View: ECE_STAGE_LEVEL1_V
[top of page]
APPS.ECE_STAGE_LEVEL1_V references the following:
APPS
SYNONYM - ECE_STAGE
APPS.ECE_STAGE_LEVEL1_V is not referenced by any database object
[top of page]
View: ECE_STAGE_LEVEL2_V
[top of page]
APPS.ECE_STAGE_LEVEL2_V references the following:
APPS
SYNONYM - ECE_STAGE
APPS.ECE_STAGE_LEVEL2_V is not referenced by any database object
[top of page]