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®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, 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.
| Description: | OPM acquisition costs entered against Oracle Purchasing PO |
|---|
GML.CPG_COST_DTL does not reference any database object
GML.CPG_COST_DTL is referenced by following:
| Description: | Archive table for mapping between Oracle Purchase Order and Purchase Order created in OPM |
|---|
GML.CPG_ORAGEMS_ARCH does not reference any database object
GML.CPG_ORAGEMS_ARCH is referenced by following:
| Description: | Maps a standard or planned purchase order entered in Oracle Purchasing with the PO or BPO created in OPM |
|---|
GML.CPG_ORAGEMS_MAPPING does not reference any database object
GML.CPG_ORAGEMS_MAPPING is referenced by following:
| Description: | Archive table for OPM Common Purchasing interface. |
|---|
GML.CPG_PURCHASING_ARCH does not reference any database object
GML.CPG_PURCHASING_ARCH is referenced by following:
| Description: | Interface table used by OPM Common Purchasing. |
|---|
GML.CPG_PURCHASING_INTERFACE does not reference any database object
GML.CPG_PURCHASING_INTERFACE is referenced by following:
| Description: | OM batch reservations history table |
|---|
GML.GML_BATCH_SO_ALLOC_HISTORY does not reference any database object
GML.GML_BATCH_SO_ALLOC_HISTORY is referenced by following:
| Description: | OM batch reservations |
|---|
GML.GML_BATCH_SO_RESERVATIONS does not reference any database object
GML.GML_BATCH_SO_RESERVATIONS is referenced by following:
| Description: | OM Batch reservations rules |
|---|
GML.GML_BATCH_SO_RULES does not reference any database object
GML.GML_BATCH_SO_RULES is referenced by following:
| Description: | OM Batch Reservation Rule Assignments |
|---|
GML.GML_BATCH_SO_RULE_ASSIGNMENTS does not reference any database object
GML.GML_BATCH_SO_RULE_ASSIGNMENTS is referenced by following:
| Description: | OM Batch reservation workflow |
|---|
GML.GML_BATCH_SO_WORKFLOW does not reference any database object
GML.GML_BATCH_SO_WORKFLOW is referenced by following:
| Description: | Temporary Table for Batch Reservations |
|---|
GML.GML_BATCH_TMP does not reference any database object
GML.GML_BATCH_TMP is referenced by following:
| Description: | Contains detail line data of the order that the shipment generated from. |
|---|
GML.GML_GASNO_DETAILS does not reference any database object
GML.GML_GASNO_DETAILS is referenced by following:
| Description: | Extension table of GML_GASNO_DETAILS. |
|---|
GML.GML_GASNO_DETAILS_X does not reference any database object
GML.GML_GASNO_DETAILS_X is referenced by following:
| Description: | Contains information about lot, location and pending transaction for an order line of an order that the shipment generated from for GASNO transaction. |
|---|
GML.GML_GASNO_DETAIL_ALLOCATIONS does not reference any database object
GML.GML_GASNO_DETAIL_ALLOCATIONS is referenced by following:
| Description: | Extension table of GML_GASNO_DETAIL_ALLOCATIONS. |
|---|
GML.GML_GASNO_DETAIL_ALLOCATIONS_X does not reference any database object
GML.GML_GASNO_DETAIL_ALLOCATIONS_X is referenced by following:
| Description: | Contains key charge data for a line that the shipment generated from for the GASNO transaction. |
|---|
GML.GML_GASNO_DETAIL_CHARGES does not reference any database object
GML.GML_GASNO_DETAIL_CHARGES is referenced by following:
| Description: | Extension table of GML_GASNO_DETAIL_CHARGES. |
|---|
GML.GML_GASNO_DETAIL_CHARGES_X does not reference any database object
GML.GML_GASNO_DETAIL_CHARGES_X is referenced by following:
| Description: | Contains text data for a line that the shipment generated from for the GASNO transaction. |
|---|
GML.GML_GASNO_DETAIL_TEXT does not reference any database object
GML.GML_GASNO_DETAIL_TEXT is referenced by following:
| Description: | Extension table of GML_GASNO_DETAIL_TEXT. |
|---|
GML.GML_GASNO_DETAIL_TEXT_X does not reference any database object
GML.GML_GASNO_DETAIL_TEXT_X is referenced by following:
| Description: | Contains key order data that the shipment generated from for the GASNO transaction. |
|---|
GML.GML_GASNO_ORDERS does not reference any database object
GML.GML_GASNO_ORDERS is referenced by following:
| Description: | Extension table of GML_GASNO_ORDERS. |
|---|
GML.GML_GASNO_ORDERS_X does not reference any database object
GML.GML_GASNO_ORDERS_X is referenced by following:
| Description: | Contains key charge data for an order that the shipment generated from for the GASNO transaction. |
|---|
GML.GML_GASNO_ORDER_CHARGES does not reference any database object
GML.GML_GASNO_ORDER_CHARGES is referenced by following:
| Description: | Extension table of GML_GASNO_ORDER_CHARGES. |
|---|
GML.GML_GASNO_ORDER_CHARGES_X does not reference any database object
GML.GML_GASNO_ORDER_CHARGES_X is referenced by following:
| Description: | Contains text data for a line that the shipment generated from for the GASNO transaction. |
|---|
GML.GML_GASNO_ORDER_TEXT does not reference any database object
GML.GML_GASNO_ORDER_TEXT is referenced by following:
| Description: | Extension table of GML_GASNO_ORDER_TEXT. |
|---|
GML.GML_GASNO_ORDER_TEXT_X does not reference any database object
GML.GML_GASNO_ORDER_TEXT_X is referenced by following:
| Description: | Contains shipping and associated trading partner data for the GASNO transaction. |
|---|
GML.GML_GASNO_SHIPMENTS does not reference any database object
GML.GML_GASNO_SHIPMENTS is referenced by following:
| Description: | Extension table of GML_GASNO_SHIPMENTS. |
|---|
GML.GML_GASNO_SHIPMENTS_X does not reference any database object
GML.GML_GASNO_SHIPMENTS_X is referenced by following:
| Description: | Contains text data for a line that the shipment generated from for the GASNO transaction. |
|---|
GML.GML_GASNO_SHIPMENT_TEXT does not reference any database object
GML.GML_GASNO_SHIPMENT_TEXT is referenced by following:
| Description: | Extension table of GML_GASNO_SHIPMENT_TEXT. |
|---|
GML.GML_GASNO_SHIPMENT_TEXT_X does not reference any database object
GML.GML_GASNO_SHIPMENT_TEXT_X is referenced by following:
| Description: | Contains order line detail data to support the edi outbound transaction GPOAO (OPM Outbound Purchase Order Acknowledgment (855/ORDRSP). |
|---|
GML.GML_GPOAO_DETAILS does not reference any database object
GML.GML_GPOAO_DETAILS is referenced by following:
| Description: | Extension table for GML_GPOAO_DETAILS |
|---|
GML.GML_GPOAO_DETAILS_X does not reference any database object
GML.GML_GPOAO_DETAILS_X is referenced by following:
| Description: | Contains order line detail allocation data to support the edi outbound transaction GPOAO (OPM Outbound Purchase Order Acknowledgment (855/ORDRSP). |
|---|
GML.GML_GPOAO_DETAIL_ALLOCATIONS does not reference any database object
GML.GML_GPOAO_DETAIL_ALLOCATIONS is referenced by following:
| Description: | Extension table for GML_GPOAO_DETAIL_ALLOCATIONS. |
|---|
GML.GML_GPOAO_DETAIL_ALLOCATIONS_X does not reference any database object
GML.GML_GPOAO_DETAIL_ALLOCATIONS_X is referenced by following:
| Description: | Contains order line detail charges to support the edi outbound transaction GPOAO (OPM Outbound Purchase Order Acknowledgment (855/ORDRSP). |
|---|
GML.GML_GPOAO_DETAIL_CHARGES does not reference any database object
GML.GML_GPOAO_DETAIL_CHARGES is referenced by following:
| Description: | Extension table for GML_GPOAO_DETAIL_CHARGES. |
|---|
GML.GML_GPOAO_DETAIL_CHARGES_X does not reference any database object
GML.GML_GPOAO_DETAIL_CHARGES_X is referenced by following:
| Description: | Contains order line detail text to support the edi outbound transaction GPOAO (OPM Outbound Purchase Order Acknowledgment (855/ORDRSP). |
|---|
GML.GML_GPOAO_DETAIL_TEXT does not reference any database object
GML.GML_GPOAO_DETAIL_TEXT is referenced by following:
| Description: | Extension table for GML_GPOAO_DETAIL_TEXT. |
|---|
GML.GML_GPOAO_DETAIL_TEXT_X does not reference any database object
GML.GML_GPOAO_DETAIL_TEXT_X is referenced by following:
| Description: | Contains order data to support the edi outbound transaction GPOAO. |
|---|
GML.GML_GPOAO_ORDERS does not reference any database object
GML.GML_GPOAO_ORDERS is referenced by following:
| Description: | Extension table for GML_GPOAO_ORDERS. |
|---|
GML.GML_GPOAO_ORDERS_X does not reference any database object
GML.GML_GPOAO_ORDERS_X is referenced by following:
| Description: | Contains charge data to support the OPM Outbound Purchase Order Acknowledgment (855/ORDRSP) EDI transaction. |
|---|
GML.GML_GPOAO_ORDER_CHARGES does not reference any database object
GML.GML_GPOAO_ORDER_CHARGES is referenced by following:
| Description: | Extension table for GML_GPOAO_ORDER_CHARGES. |
|---|
GML.GML_GPOAO_ORDER_CHARGES_X does not reference any database object
GML.GML_GPOAO_ORDER_CHARGES_X is referenced by following:
| Description: | Contains text data to support the OPM Outbound Purchase Order Acknowledgment (855/ORDRSP) EDI transaction. |
|---|
GML.GML_GPOAO_ORDER_TEXT does not reference any database object
GML.GML_GPOAO_ORDER_TEXT is referenced by following:
| Description: | Extension table for GML_GPOAO_ORDER_TEXT. |
|---|
GML.GML_GPOAO_ORDER_TEXT_X does not reference any database object
GML.GML_GPOAO_ORDER_TEXT_X is referenced by following:
| Description: | Table contains customer records that failed to synch from Oracle Receivables to OPM. |
|---|
GML.GML_INVALID_CUSTOMERS does not reference any database object
GML.GML_INVALID_CUSTOMERS is referenced by following:
| Description: | Migration errors reporting table from Common Purchasing to Common Receiving |
|---|
GML.GML_PO_MIG_ERRORS does not reference any database object
GML.GML_PO_MIG_ERRORS is referenced by following:
| Description: | Table to maintain log of migrated records in receiving lots |
|---|
GML.GML_RCV_LOTS_MIGRATION does not reference any database object
GML.GML_RCV_LOTS_MIGRATION is referenced by following:
| Description: | OPM receipt adjustment errors |
|---|
GML.GML_RECV_ADJUST_ERRORS does not reference any database object
GML.GML_RECV_ADJUST_ERRORS is referenced by following:
| Description: | Mapping of receipts in OPM and Oracle Receiving. |
|---|
GML.GML_RECV_TRANS_MAP does not reference any database object
GML.GML_RECV_TRANS_MAP is referenced by following:
| Description: | Allocation parameters by customer and item class. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ALOT_PRM.PREFQC_GRADE | GMD_GRADES_B |
| OP_ALOT_PRM.CUST_ID | OP_CUST_MST |
| OP_ALOT_PRM.TEXT_CODE | OP_TEXT_HDR |
| OP_ALOT_PRM.PREFQC_GRADE | QC_GRAD_MST |
GML.OP_ALOT_PRM does not reference any database object
GML.OP_ALOT_PRM is referenced by following:
| Description: | Sales Order Audit Trail by order line |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_AUDT_DTL.CHANGEORDER_ID | OP_AUDT_MST |
| OP_AUDT_DTL.LINE_ID | OP_ORDR_DTL |
GML.OP_AUDT_DTL does not reference any database object
GML.OP_AUDT_DTL is referenced by following:
| Description: | Header record which links all change records for a sales orderdetail line. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_AUDT_MST.ORDER_ID | OP_ORDR_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_AUDT_DTL.CHANGEORDER_ID | OP_AUDT_MST |
GML.OP_AUDT_MST does not reference any database object
GML.OP_AUDT_MST is referenced by following:
| Description: | Header information for a shipment. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_BILL_LAD.DEMURRAGE_CURRENCY | GL_CURR_MST |
| OP_BILL_LAD.EMBARKATION_PORT | OP_PORT_MST |
| OP_BILL_LAD.DEBARKATION_PORT | OP_PORT_MST |
| OP_BILL_LAD.SHIPPER_CODE | OP_SHIP_MST |
| OP_BILL_LAD.TEXT_CODE | OP_TEXT_HDR |
| OP_BILL_LAD.BOLADDR_ID | SY_ADDR_MST |
| OP_BILL_LAD.ORGN_CODE | SY_ORGN_MST_B |
| OP_BILL_LAD.ORGN_CODE | SY_ORGN_MST |
| OP_BILL_LAD.BOL_UM | SY_UOMS_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ORDR_DTL.BOL_ID | OP_BILL_LAD |
GML.OP_BILL_LAD does not reference any database object
GML.OP_BILL_LAD is referenced by following:
| Description: | Customer GL account classes |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CGLD_CLS.TEXT_CODE | OP_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_MAP.CUSTGL_CLASS | OP_CGLD_CLS |
| OP_CUST_MST_OPM.CUSTGL_CLASS | OP_CGLD_CLS |
| OP_CUST_MST.CUSTGL_CLASS | OP_CGLD_CLS |
GML.OP_CGLD_CLS does not reference any database object
GML.OP_CGLD_CLS is referenced by following:
| Description: | Charge breaks. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CHRG_BRK.CHARGE_ID | OP_CHRG_MST |
GML.OP_CHRG_BRK does not reference any database object
GML.OP_CHRG_BRK is referenced by following:
| Description: | Ancillary charge tax classes |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CHRG_CLS.TEXT_CODE | OP_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CHRG_MST.CHGTAX_CLASS | OP_CHRG_CLS |
| TX_TAXA_DTL.CHGTAX_CLASS | OP_CHRG_CLS |
GML.OP_CHRG_CLS does not reference any database object
GML.OP_CHRG_CLS is referenced by following:
| Description: | Charges for items or item classes and customers. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CHRG_ITM.ITEM_ID | IC_ITEM_MST_B |
| OP_CHRG_ITM.ITEM_ID | IC_ITEM_MST |
| OP_CHRG_ITM.ICPRICE_CLASS | IC_PRCE_CLS |
| OP_CHRG_ITM.CHARGE_ID | OP_CHRG_MST |
| OP_CHRG_ITM.CUST_ID | OP_CUST_MST |
GML.OP_CHRG_ITM does not reference any database object
GML.OP_CHRG_ITM is referenced by following:
| Description: | Charge master. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CHRG_MST.CURRENCY_CODE | GL_CURR_MST |
| OP_CHRG_MST.CHGTAX_CLASS | OP_CHRG_CLS |
| OP_CHRG_MST.TEXT_CODE | OP_TEXT_HDR |
| OP_CHRG_MST.CHARGE_UOM | SY_UOMS_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_MAP.CHARGE_ID | OP_CHRG_MST |
| OP_CHRG_BRK.CHARGE_ID | OP_CHRG_MST |
| OP_CHRG_ITM.CHARGE_ID | OP_CHRG_MST |
| OP_INVC_CHG.CHARGE_ID | OP_CHRG_MST |
| OP_ORDR_CHG.CHARGE_ID | OP_CHRG_MST |
| OP_PRCE_EFF.CHARGE_ID | OP_CHRG_MST |
| OP_PRSL_CHG.CHARGE_ID | OP_CHRG_MST |
GML.OP_CHRG_MST does not reference any database object
GML.OP_CHRG_MST is referenced by following:
| Description: | Price breaks for contracts. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CNTR_BRK.PRICE_ID | OP_CNTR_DTL |
GML.OP_CNTR_BRK does not reference any database object
GML.OP_CNTR_BRK is referenced by following:
| Description: | Item prices on a contract. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CNTR_DTL.QC_GRADE | GMD_GRADES_B |
| OP_CNTR_DTL.ITEM_ID | IC_ITEM_MST_B |
| OP_CNTR_DTL.ITEM_ID | IC_ITEM_MST |
| OP_CNTR_DTL.PRICE_CLASS | IC_PRCE_CLS |
| OP_CNTR_DTL.CONTRACT_ID | OP_CNTR_HDR |
| OP_CNTR_DTL.FRTBILL_MTHD | OP_FRGT_MTH |
| OP_CNTR_DTL.TEXT_CODE | OP_TEXT_HDR |
| OP_CNTR_DTL.QC_GRADE | QC_GRAD_MST |
| OP_CNTR_DTL.PRICE_UM | SY_UOMS_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CNTR_BRK.PRICE_ID | OP_CNTR_DTL |
GML.OP_CNTR_DTL does not reference any database object
GML.OP_CNTR_DTL is referenced by following:
| Description: | Contract header. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CNTR_HDR.CONTRACT_CURRENCY | GL_CURR_MST |
| OP_CNTR_HDR.BASE_CURRENCY | GL_CURR_MST |
| OP_CNTR_HDR.TEXT_CODE | OP_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CNTR_DTL.CONTRACT_ID | OP_CNTR_HDR |
| OP_PRCE_EFF.CONTRACT_ID | OP_CNTR_HDR |
GML.OP_CNTR_HDR does not reference any database object
GML.OP_CNTR_HDR is referenced by following:
| Description: | Shadow table of OP_CNTR_HDR for EFC migration. |
|---|
GML.OP_CNTR_HDR_EFC does not reference any database object
GML.OP_CNTR_HDR_EFC is referenced by following:
| Description: | Commission code header. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_COMM_CDS.COMMISSION_CODE | OP_COMMISSION |
| OP_CUST_MST_OPM.COMMISSION_CODE | OP_COMMISSION |
| OP_CUST_MST.COMMISSION_CODE | OP_COMMISSION |
| OP_ORDR_DTL.COMMISSION_CODE | OP_COMMISSION |
| OP_ORDR_HDR.COMMISSION_CODE | OP_COMMISSION |
| OP_PRSL_DTL.COMMISSION_CODE | OP_COMMISSION |
| OP_PRSL_HDR.COMMISSION_CODE | OP_COMMISSION |
| OP_SLSR_MST.COMMISSION_CODE | OP_COMMISSION |
GML.OP_COMMISSION does not reference any database object
GML.OP_COMMISSION is referenced by following:
| Description: | Commission code detail. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_COMM_CDS.COMMISSION_CODE | OP_COMMISSION |
| OP_COMM_CDS.SLSREP_CODE | OP_SLSR_MST |
| OP_COMM_CDS.TEXT_CODE | OP_TEXT_HDR |
GML.OP_COMM_CDS does not reference any database object
GML.OP_COMM_CDS is referenced by following:
| Description: | Customer Price Classes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CPRC_CLS.TEXT_CODE | OP_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_MST_OPM.CUSTPRICE_CLASS | OP_CPRC_CLS |
| OP_CUST_MST.CUSTPRICE_CLASS | OP_CPRC_CLS |
| OP_PRCE_EFF.CUSTPRICE_CLASS | OP_CPRC_CLS |
GML.OP_CPRC_CLS does not reference any database object
GML.OP_CPRC_CLS is referenced by following:
| Description: | Customer Trade Classes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CTRD_CLS.TEXT_CODE | OP_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_MST_OPM.CUSTTRADE_CLASS | OP_CTRD_CLS |
| OP_CUST_MST.CUSTTRADE_CLASS | OP_CTRD_CLS |
| OP_PRSL_HDR.CUSTTRADE_CLASS | OP_CTRD_CLS |
GML.OP_CTRD_CLS does not reference any database object
GML.OP_CTRD_CLS is referenced by following:
| Description: | Customer relationships |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_ASC.CUST_ID | OP_CUST_MST |
| OP_CUST_ASC.ASSOCCUST_ID | OP_CUST_MST |
| OP_CUST_ASC.TEXT_CODE | OP_TEXT_HDR |
GML.OP_CUST_ASC does not reference any database object
GML.OP_CUST_ASC is referenced by following:
| Description: | General customer classes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_CLS.TEXT_CODE | OP_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_MST_OPM.CUST_CLASS | OP_CUST_CLS |
| OP_CUST_MST.CUST_CLASS | OP_CUST_CLS |
GML.OP_CUST_CLS does not reference any database object
GML.OP_CUST_CLS is referenced by following:
| Description: | Customer contact information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_CON.CUST_ID | OP_CUST_MST |
| OP_CUST_CON.ADDR_ID | SY_ADDR_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ORDR_DTL.CONTACT_ID | OP_CUST_CON |
| OP_ORDR_HDR.CONTACT_ID | OP_CUST_CON |
| OP_PRSL_DTL.CONTACT_ID | OP_CUST_CON |
| OP_PRSL_HDR.CONTACT_ID | OP_CUST_CON |
GML.OP_CUST_CON does not reference any database object
GML.OP_CUST_CON is referenced by following:
| Description: | Interface table used to move customer contact information from Oracle Receivables into OPM. |
|---|
GML.OP_CUST_CON_INT does not reference any database object
GML.OP_CUST_CON_INT is referenced by following:
| Description: | Customer item information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_ITM.ITEM_ID | IC_ITEM_MST_B |
| OP_CUST_ITM.ITEM_ID | IC_ITEM_MST |
| OP_CUST_ITM.WHSE_CODE | IC_WHSE_MST |
| OP_CUST_ITM.CUST_ID | OP_CUST_MST |
| OP_CUST_ITM.SALESPKG_ID | OP_PKGD_ITM |
GML.OP_CUST_ITM does not reference any database object
GML.OP_CUST_ITM is referenced by following:
| Description: | Customer Interface table for data transferred from Oracle Receivables into the OPM customer master. |
|---|
GML.OP_CUST_MST_INT does not reference any database object
GML.OP_CUST_MST_INT is referenced by following:
| Description: | Customer master. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_MST_OPM.COMMISSION_CODE | OP_COMMISSION |
| OP_CUST_MST_OPM.CO_CODE | SY_ORGN_MST_B |
| OP_CUST_MST_OPM.FROM_WHSE | IC_WHSE_MST |
| OP_CUST_MST_OPM.TO_WHSE | IC_WHSE_MST |
| OP_CUST_MST_OPM.ADDR_ID | SY_ADDR_MST |
| OP_CUST_MST_OPM.MAILADDR_ID | SY_ADDR_MST |
| OP_CUST_MST_OPM.CUST_CURRENCY | GL_CURR_MST |
| OP_CUST_MST_OPM.CUSTGL_CLASS | OP_CGLD_CLS |
| OP_CUST_MST_OPM.CUSTPRICE_CLASS | OP_CPRC_CLS |
| OP_CUST_MST_OPM.CUSTTRADE_CLASS | OP_CTRD_CLS |
| OP_CUST_MST_OPM.CUST_CLASS | OP_CUST_CLS |
| OP_CUST_MST_OPM.FOB_CODE | OP_FOBC_MST |
| OP_CUST_MST_OPM.FRTBILL_MTHD | OP_FRGT_MTH |
| OP_CUST_MST_OPM.LOCKBOX_CODE | OP_LKBX_MST |
| OP_CUST_MST_OPM.SLSREP_CODE | OP_SLSR_MST |
| OP_CUST_MST_OPM.TERMS_CODE | OP_TERM_MST |
| OP_CUST_MST_OPM.TEXT_CODE | OP_TEXT_HDR |
| OP_CUST_MST_OPM.TAXCALC_CODE | TX_CALC_MST |
| OP_CUST_MST_OPM.TAXLOC_CODE | TX_TLOC_CDS |
GML.OP_CUST_MST_OPM does not reference any database object
GML.OP_CUST_MST_OPM is referenced by following:
| Description: | Preferred shippers (carriers) and ship methods for customers. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_SHP.TEXT_CODE | OP_TEXT_HDR |
| OP_CUST_SHP.ICSHIP_CLASS | IC_SHIP_CLS |
| OP_CUST_SHP.WHSE_CODE | IC_WHSE_MST |
| OP_CUST_SHP.CUST_ID | OP_CUST_MST |
| OP_CUST_SHP.SHIPPER_CODE | OP_SHIP_MST |
| OP_CUST_SHP.SHIP_MTHD | OP_SHIP_MTH |
GML.OP_CUST_SHP does not reference any database object
GML.OP_CUST_SHP is referenced by following:
| Description: | Free on Board (FOB) codes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_FOBC_MST.TEXT_CODE | OP_TEXT_HDR |
| OP_FOBC_MST.ADDR_ID | SY_ADDR_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_MST_OPM.FOB_CODE | OP_FOBC_MST |
| OP_CUST_MST.FOB_CODE | OP_FOBC_MST |
| OP_ORDR_DTL.FOB_CODE | OP_FOBC_MST |
| OP_ORDR_HDR.FOB_CODE | OP_FOBC_MST |
| OP_PRSL_HDR.FOB_CODE | OP_FOBC_MST |
| PO_BPOS_DTL.FOB_CODE | OP_FOBC_MST |
| PO_BPOS_HDR.FOB_CODE | OP_FOBC_MST |
| PO_ORDR_DTL.FOB_CODE | OP_FOBC_MST |
| PO_ORDR_HDR.FOB_CODE | OP_FOBC_MST |
| PO_RECV_DTL.FOB_CODE | OP_FOBC_MST |
GML.OP_FOBC_MST does not reference any database object
GML.OP_FOBC_MST is referenced by following:
| Description: | This table is not used in 11i. |
|---|
GML.OP_FOBC_MST_INT does not reference any database object
GML.OP_FOBC_MST_INT is referenced by following:
| Description: | Freight bill method codes . |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_FRGT_MTH.TEXT_CODE | OP_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CNTR_DTL.FRTBILL_MTHD | OP_FRGT_MTH |
| OP_CUST_MST_OPM.FRTBILL_MTHD | OP_FRGT_MTH |
| OP_CUST_MST.FRTBILL_MTHD | OP_FRGT_MTH |
| OP_ORDR_DTL.FRTBILL_MTHD | OP_FRGT_MTH |
| OP_ORDR_HDR.FRTBILL_MTHD | OP_FRGT_MTH |
| OP_PRCE_ITM.FRTBILL_MTHD | OP_FRGT_MTH |
| OP_PRSL_DTL.FRTBILL_MTHD | OP_FRGT_MTH |
| OP_PRSL_HDR.FRTBILL_MTHD | OP_FRGT_MTH |
| PO_BPOS_DTL.FRTBILL_MTHD | OP_FRGT_MTH |
| PO_BPOS_HDR.FRTBILL_MTHD | OP_FRGT_MTH |
| PO_ORDR_DTL.FRTBILL_MTHD | OP_FRGT_MTH |
| PO_ORDR_HDR.FRTBILL_MTHD | OP_FRGT_MTH |
| PO_RECV_DTL.FRTBILL_MTHD | OP_FRGT_MTH |
| PO_VEND_MST.FRTBILL_MTHD | OP_FRGT_MTH |
GML.OP_FRGT_MTH does not reference any database object
GML.OP_FRGT_MTH is referenced by following:
| Description: | Customer and generic (alternate) names for items. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_GNRC_ITM.ITEM_ID | IC_ITEM_MST_B |
| OP_GNRC_ITM.ITEM_ID | IC_ITEM_MST |
| OP_GNRC_ITM.CUST_ID | OP_CUST_MST |
| OP_GNRC_ITM.TEXT_CODE | OP_TEXT_HDR |
| OP_GNRC_ITM.VENDOR_ID | PO_VEND_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ORDR_DTL.GENERIC_ID | OP_GNRC_ITM |
| OP_PRSL_DTL.GENERIC_ID | OP_GNRC_ITM |
| PO_BPOS_DTL.GENERIC_ID | OP_GNRC_ITM |
| PO_ORDR_DTL.GENERIC_ID | OP_GNRC_ITM |
GML.OP_GNRC_ITM does not reference any database object
GML.OP_GNRC_ITM is referenced by following:
| Description: | Sales order hold reason codes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_HOLD_CDS.TEXT_CODE | OP_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ORDR_DTL.HOLDREAS_CODE | OP_HOLD_CDS |
| OP_ORDR_HDR.HOLDREAS_CODE | OP_HOLD_CDS |
| OP_PRSL_DTL.HOLDREAS_CODE | OP_HOLD_CDS |
| OP_PRSL_HDR.HOLDREAS_CODE | OP_HOLD_CDS |
GML.OP_HOLD_CDS does not reference any database object
GML.OP_HOLD_CDS is referenced by following:
| Description: | Tax details for an order line. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_INVC_CHG.CHARGE_ID | OP_CHRG_MST |
| OP_INVC_CHG.TAXRATE_ID | TX_TAXA_DTL |
| OP_INVC_CHG.TAX_STATUS | TX_TAXA_STS |
GML.OP_INVC_CHG does not reference any database object
GML.OP_INVC_CHG is referenced by following:
| Description: | Lockbox codes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_LKBX_MST.ADDR_ID | SY_ADDR_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_MST_OPM.LOCKBOX_CODE | OP_LKBX_MST |
| OP_CUST_MST.LOCKBOX_CODE | OP_LKBX_MST |
| OP_ORDR_DTL.LOCKBOX_CODE | OP_LKBX_MST |
| OP_ORDR_HDR.LOCKBOX_CODE | OP_LKBX_MST |
| OP_PRSL_DTL.REMIT_TO_LOCKBOX | OP_LKBX_MST |
| OP_PRSL_HDR.REMIT_TO_LOCKBOX | OP_LKBX_MST |
GML.OP_LKBX_MST does not reference any database object
GML.OP_LKBX_MST is referenced by following:
| Description: | Order and order line charges. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ORDR_CHG.CHARGE_ID | OP_CHRG_MST |
| OP_ORDR_CHG.LINE_ID | OP_ORDR_DTL |
| OP_ORDR_CHG.ORDER_ID | OP_ORDR_HDR |
| OP_ORDR_CHG.PRESALES_CHARGELINE_ID | OP_PRSL_CHG |
GML.OP_ORDR_CHG does not reference any database object
GML.OP_ORDR_CHG is referenced by following:
| Description: | Order Entry Open Interface Detail Charges table. |
|---|
GML.OP_ORDR_DAC_INTERFACE does not reference any database object
GML.OP_ORDR_DAC_INTERFACE is referenced by following:
| Description: | Order detail (order lines). |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ORDR_DTL.BILLING_CURRENCY | GL_CURR_MST |
| OP_ORDR_DTL.BASE_CURRENCY | GL_CURR_MST |
| OP_ORDR_DTL.QC_GRADE_WANTED | GMD_GRADES_B |
| OP_ORDR_DTL.ITEM_ID | IC_ITEM_MST_B |
| OP_ORDR_DTL.ITEM_ID | IC_ITEM_MST |
| OP_ORDR_DTL.TO_WHSE | IC_WHSE_MST |
| OP_ORDR_DTL.FROM_WHSE | IC_WHSE_MST |
| OP_ORDR_DTL.BOL_ID | OP_BILL_LAD |
| OP_ORDR_DTL.COMMISSION_CODE | OP_COMMISSION |
| OP_ORDR_DTL.CONTACT_ID | OP_CUST_CON |
| OP_ORDR_DTL.SHIPCUST_ID | OP_CUST_MST |
| OP_ORDR_DTL.CONSIGNEE_ID | OP_CUST_MST |
| OP_ORDR_DTL.ULTIMATE_SHIPCUST_ID | OP_CUST_MST |
| OP_ORDR_DTL.SOLDTOCUST_ID | OP_CUST_MST |
| OP_ORDR_DTL.FOB_CODE | OP_FOBC_MST |
| OP_ORDR_DTL.FRTBILL_MTHD | OP_FRGT_MTH |
| OP_ORDR_DTL.GENERIC_ID | OP_GNRC_ITM |
| OP_ORDR_DTL.HOLDREAS_CODE | OP_HOLD_CDS |
| OP_ORDR_DTL.LOCKBOX_CODE | OP_LKBX_MST |
| OP_ORDR_DTL.ORDER_ID | OP_ORDR_HDR |
| OP_ORDR_DTL.LINE_STATUS | OP_ORDR_STS_B |
| OP_ORDR_DTL.SALESPKG_ID | OP_PKGD_ITM |
| OP_ORDR_DTL.EMBARKATION_PORT | OP_PORT_MST |
| OP_ORDR_DTL.DEBARKATION_PORT | OP_PORT_MST |
| OP_ORDR_DTL.PRICEREAS_CODE | OP_PRCE_CDS |
| OP_ORDR_DTL.PRICEFF_ID | OP_PRCE_EFF |
| OP_ORDR_DTL.PRESALES_ORDLINE_ID | OP_PRSL_DTL |
| OP_ORDR_DTL.SHIPPER_CODE | OP_SHIP_MST |
| OP_ORDR_DTL.SHIP_MTHD | OP_SHIP_MTH |
| OP_ORDR_DTL.SLSREP_CODE | OP_SLSR_MST |
| OP_ORDR_DTL.TERMS_CODE | OP_TERM_MST |
| OP_ORDR_DTL.TEXT_CODE | OP_TEXT_HDR |
| OP_ORDR_DTL.QC_GRADE_WANTED | QC_GRAD_MST |
| OP_ORDR_DTL.SHIPADDR_ID | SY_ADDR_MST |
| OP_ORDR_DTL.CHANGEREAS_CODE | SY_REAS_CDS_B |
| OP_ORDR_DTL.CHANGEREAS_CODE | SY_REAS_CDS |
| OP_ORDR_DTL.ORDER_UM1 | SY_UOMS_MST |
| OP_ORDR_DTL.ORDER_UM2 | SY_UOMS_MST |
| OP_ORDR_DTL.SHIPWT_UM | SY_UOMS_MST |
| OP_ORDR_DTL.SHIPVOLUME_UM | SY_UOMS_MST |
| OP_ORDR_DTL.PRICE_UM | SY_UOMS_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| CR_DOPR_TBL.LINE_ID | OP_ORDR_DTL |
| OP_AUDT_DTL.LINE_ID | OP_ORDR_DTL |
| OP_ORDR_CHG.LINE_ID | OP_ORDR_DTL |
GML.OP_ORDR_DTL does not reference any database object
GML.OP_ORDR_DTL is referenced by following:
| Description: | Shadow table of OP_ORDR_DTL for EFC migration. |
|---|
GML.OP_ORDR_DTL_EFC does not reference any database object
GML.OP_ORDR_DTL_EFC is referenced by following:
| Description: | Order Entry Open Interface Detail table. |
|---|
GML.OP_ORDR_DTL_INTERFACE does not reference any database object
GML.OP_ORDR_DTL_INTERFACE is referenced by following:
| Description: | Order Entry Open Interface Detail Text table. |
|---|
GML.OP_ORDR_DTX_INTERFACE does not reference any database object
GML.OP_ORDR_DTX_INTERFACE is referenced by following:
| Description: | Order Entry Open Interface Header Charges table. |
|---|
GML.OP_ORDR_HAC_INTERFACE does not reference any database object
GML.OP_ORDR_HAC_INTERFACE is referenced by following:
| Description: | Sales Order Header table. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ORDR_HDR.BILLING_CURRENCY | GL_CURR_MST |
| OP_ORDR_HDR.FROM_WHSE | IC_WHSE_MST |
| OP_ORDR_HDR.TO_WHSE | IC_WHSE_MST |
| OP_ORDR_HDR.COMMISSION_CODE | OP_COMMISSION |
| OP_ORDR_HDR.CONTACT_ID | OP_CUST_CON |
| OP_ORDR_HDR.BILLCUST_ID | OP_CUST_MST |
| OP_ORDR_HDR.SHIPCUST_ID | OP_CUST_MST |
| OP_ORDR_HDR.ULTIMATE_SHIPCUST_ID | OP_CUST_MST |
| OP_ORDR_HDR.SOLDTOCUST_ID | OP_CUST_MST |
| OP_ORDR_HDR.CONSIGNEE_ID | OP_CUST_MST |
| OP_ORDR_HDR.FOB_CODE | OP_FOBC_MST |
| OP_ORDR_HDR.FRTBILL_MTHD | OP_FRGT_MTH |
| OP_ORDR_HDR.HOLDREAS_CODE | OP_HOLD_CDS |
| OP_ORDR_HDR.LOCKBOX_CODE | OP_LKBX_MST |
| OP_ORDR_HDR.ORDER_STATUS | OP_ORDR_STS_B |
| OP_ORDR_HDR.ORDER_TYPE | OP_ORDR_TYP_B |
| OP_ORDR_HDR.DEBARKATION_PORT | OP_PORT_MST |
| OP_ORDR_HDR.EMBARKATION_PORT | OP_PORT_MST |
| OP_ORDR_HDR.PRESALES_ORD_ID | OP_PRSL_HDR |
| OP_ORDR_HDR.SHIPPER_CODE | OP_SHIP_MST |
| OP_ORDR_HDR.SHIP_MTHD | OP_SHIP_MTH |
| OP_ORDR_HDR.SLSREP_CODE | OP_SLSR_MST |
| OP_ORDR_HDR.TERMS_CODE | OP_TERM_MST |
| OP_ORDR_HDR.TEXT_CODE | OP_TEXT_HDR |
| OP_ORDR_HDR.SHIPADDR_ID | SY_ADDR_MST |
| OP_ORDR_HDR.ORGN_CODE | SY_ORGN_MST_B |
| OP_ORDR_HDR.ORGN_CODE | SY_ORGN_MST |
| OP_ORDR_HDR.CHANGEREAS_CODE | SY_REAS_CDS_B |
| OP_ORDR_HDR.CHANGEREAS_CODE | SY_REAS_CDS |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_AUDT_MST.ORDER_ID | OP_ORDR_HDR |
| OP_ORDR_CHG.ORDER_ID | OP_ORDR_HDR |
| OP_ORDR_DTL.ORDER_ID | OP_ORDR_HDR |
GML.OP_ORDR_HDR does not reference any database object
GML.OP_ORDR_HDR is referenced by following:
| Description: | Order Header open interface table. |
|---|
GML.OP_ORDR_HDR_INTERFACE does not reference any database object
GML.OP_ORDR_HDR_INTERFACE is referenced by following:
| Description: | Order Entry Open Interface Header Text table. |
|---|
GML.OP_ORDR_HTX_INTERFACE does not reference any database object
GML.OP_ORDR_HTX_INTERFACE is referenced by following:
| Description: | Order status codes and descriptions. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ORDR_DTL.LINE_STATUS | OP_ORDR_STS_B |
| OP_ORDR_HDR.ORDER_STATUS | OP_ORDR_STS_B |
GML.OP_ORDR_STS_B does not reference any database object
GML.OP_ORDR_STS_B is referenced by following:
| Description: | Translations for Order Status Codes and Descriptions. |
|---|
GML.OP_ORDR_STS_TL does not reference any database object
GML.OP_ORDR_STS_TL is referenced by following:
| Description: | Mapping table for GML and OM order types. |
|---|
GML.OP_ORDR_TYPE_MIGRATION does not reference any database object
GML.OP_ORDR_TYPE_MIGRATION is referenced by following:
| Description: | User-defined order types and descriptions. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ORDR_HDR.ORDER_TYPE | OP_ORDR_TYP_B |
GML.OP_ORDR_TYP_B does not reference any database object
GML.OP_ORDR_TYP_B is referenced by following:
| Description: | Translations for OrderType Codes and Descriptions. |
|---|
GML.OP_ORDR_TYP_TL does not reference any database object
GML.OP_ORDR_TYP_TL is referenced by following:
| Description: | Packaged item names and shipping weights. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_PKGD_ITM.BULK_ITEM_ID | IC_ITEM_MST_B |
| OP_PKGD_ITM.BULK_ITEM_ID | IC_ITEM_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_ITM.SALESPKG_ID | OP_PKGD_ITM |
| OP_ORDR_DTL.SALESPKG_ID | OP_PKGD_ITM |
| OP_PRSL_DTL.SALESPKG_ID | OP_PKGD_ITM |
GML.OP_PKGD_ITM does not reference any database object
GML.OP_PKGD_ITM is referenced by following:
| Description: | Shipping/receiving port codes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_PORT_MST.TEXT_CODE | OP_TEXT_HDR |
| OP_PORT_MST.ADDR_ID | SY_ADDR_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_BILL_LAD.EMBARKATION_PORT | OP_PORT_MST |
| OP_BILL_LAD.DEBARKATION_PORT | OP_PORT_MST |
| OP_ORDR_DTL.EMBARKATION_PORT | OP_PORT_MST |
| OP_ORDR_DTL.DEBARKATION_PORT | OP_PORT_MST |
| OP_ORDR_HDR.DEBARKATION_PORT | OP_PORT_MST |
| OP_ORDR_HDR.EMBARKATION_PORT | OP_PORT_MST |
| OP_PRSL_DTL.EMBARKATION_PORT | OP_PORT_MST |
| OP_PRSL_DTL.DEBARKATION_PORT | OP_PORT_MST |
| OP_PRSL_HDR.EMBARKATION_PORT | OP_PORT_MST |
| OP_PRSL_HDR.DEBARKATION_PORT | OP_PORT_MST |
| PO_RECV_HDR.DEBARKATION_PORT | OP_PORT_MST |
| PO_RECV_HDR.EMBARKATION_PORT | OP_PORT_MST |
GML.OP_PORT_MST does not reference any database object
GML.OP_PORT_MST is referenced by following:
| Description: | Price breaks for items on a pricelist. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_PRCE_BRK.PRICE_ID | OP_PRCE_ITM |
GML.OP_PRCE_BRK does not reference any database object
GML.OP_PRCE_BRK is referenced by following:
| Description: | Order Entry Price Reason Codes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ORDR_DTL.PRICEREAS_CODE | OP_PRCE_CDS |
GML.OP_PRCE_CDS does not reference any database object
GML.OP_PRCE_CDS is referenced by following:
| Description: | Pricing effectivities to establish active price lists, contracts or charges. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_PRCE_EFF.CHARGE_ID | OP_CHRG_MST |
| OP_PRCE_EFF.CONTRACT_ID | OP_CNTR_HDR |
| OP_PRCE_EFF.CUSTPRICE_CLASS | OP_CPRC_CLS |
| OP_PRCE_EFF.CUST_ID | OP_CUST_MST |
| OP_PRCE_EFF.PRICELIST_ID | OP_PRCE_MST |
| OP_PRCE_EFF.TEXT_CODE | OP_TEXT_HDR |
| OP_PRCE_EFF.ORGN_CODE | SY_ORGN_MST_B |
| OP_PRCE_EFF.ORGN_CODE | SY_ORGN_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ORDR_DTL.PRICEFF_ID | OP_PRCE_EFF |
GML.OP_PRCE_EFF does not reference any database object
GML.OP_PRCE_EFF is referenced by following:
| Description: | Item prices on a pricelist. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_PRCE_ITM.QC_GRADE | GMD_GRADES_B |
| OP_PRCE_ITM.ITEM_ID | IC_ITEM_MST_B |
| OP_PRCE_ITM.ITEM_ID | IC_ITEM_MST |
| OP_PRCE_ITM.PRICE_CLASS | IC_PRCE_CLS |
| OP_PRCE_ITM.WHSE_CODE | IC_WHSE_MST |
| OP_PRCE_ITM.FRTBILL_MTHD | OP_FRGT_MTH |
| OP_PRCE_ITM.PRICELIST_ID | OP_PRCE_MST |
| OP_PRCE_ITM.TEXT_CODE | OP_TEXT_HDR |
| OP_PRCE_ITM.QC_GRADE | QC_GRAD_MST |
| OP_PRCE_ITM.PRICE_UM | SY_UOMS_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_PRCE_BRK.PRICE_ID | OP_PRCE_ITM |
GML.OP_PRCE_ITM does not reference any database object
GML.OP_PRCE_ITM is referenced by following:
| Description: | Price list header. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_PRCE_MST.CURRENCY_CODE | GL_CURR_MST |
| OP_PRCE_MST.TEXT_CODE | OP_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_PRCE_EFF.PRICELIST_ID | OP_PRCE_MST |
| OP_PRCE_ITM.PRICELIST_ID | OP_PRCE_MST |
GML.OP_PRCE_MST does not reference any database object
GML.OP_PRCE_MST is referenced by following:
| Description: | This table is not used in 11i. |
|---|
GML.OP_PRSL_AUD does not reference any database object
GML.OP_PRSL_AUD is referenced by following:
| Description: | Charges for an entire order profile and/or order profile lines. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_PRSL_CHG.CHARGE_ID | OP_CHRG_MST |
| OP_PRSL_CHG.PRESALES_ORDLINE_ID | OP_PRSL_DTL |
| OP_PRSL_CHG.PRESALES_ORD_ID | OP_PRSL_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ORDR_CHG.PRESALES_CHARGELINE_ID | OP_PRSL_CHG |
GML.OP_PRSL_CHG does not reference any database object
GML.OP_PRSL_CHG is referenced by following:
| Description: | Order profile lines and blanket sales order lines. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_PRSL_DTL.BILLING_CURRENCY | GL_CURR_MST |
| OP_PRSL_DTL.QC_GRADE_WANTED | GMD_GRADES_B |
| OP_PRSL_DTL.ITEM_ID | IC_ITEM_MST_B |
| OP_PRSL_DTL.ITEM_ID | IC_ITEM_MST |
| OP_PRSL_DTL.FROM_WHSE | IC_WHSE_MST |
| OP_PRSL_DTL.COMMISSION_CODE | OP_COMMISSION |
| OP_PRSL_DTL.CONTACT_ID | OP_CUST_CON |
| OP_PRSL_DTL.BILLCUST_ID | OP_CUST_MST |
| OP_PRSL_DTL.SHIPCUST_ID | OP_CUST_MST |
| OP_PRSL_DTL.CONSIGNEE_ID | OP_CUST_MST |
| OP_PRSL_DTL.ULTIMATE_SHIPCUST_ID | OP_CUST_MST |
| OP_PRSL_DTL.SOLDTOCUST_ID | OP_CUST_MST |
| OP_PRSL_DTL.FRTBILL_MTHD | OP_FRGT_MTH |
| OP_PRSL_DTL.GENERIC_ID | OP_GNRC_ITM |
| OP_PRSL_DTL.HOLDREAS_CODE | OP_HOLD_CDS |
| OP_PRSL_DTL.REMIT_TO_LOCKBOX | OP_LKBX_MST |
| OP_PRSL_DTL.SALESPKG_ID | OP_PKGD_ITM |
| OP_PRSL_DTL.EMBARKATION_PORT | OP_PORT_MST |
| OP_PRSL_DTL.DEBARKATION_PORT | OP_PORT_MST |
| OP_PRSL_DTL.PRESALES_ORD_ID | OP_PRSL_HDR |
| OP_PRSL_DTL.SHIPPER_CODE | OP_SHIP_MST |
| OP_PRSL_DTL.SHIP_MTHD | OP_SHIP_MTH |
| OP_PRSL_DTL.SLSREP_CODE | OP_SLSR_MST |
| OP_PRSL_DTL.TERMS_CODE | OP_TERM_MST |
| OP_PRSL_DTL.TEXT_CODE | OP_TEXT_HDR |
| OP_PRSL_DTL.QC_GRADE_WANTED | QC_GRAD_MST |
| OP_PRSL_DTL.SHIPADDR_ID | SY_ADDR_MST |
| OP_PRSL_DTL.ORDER_UM1 | SY_UOMS_MST |
| OP_PRSL_DTL.ORDER_UM2 | SY_UOMS_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ORDR_DTL.PRESALES_ORDLINE_ID | OP_PRSL_DTL |
| OP_PRSL_CHG.PRESALES_ORDLINE_ID | OP_PRSL_DTL |
| OP_RELS_SCH.PRESALES_ORDLINE_ID | OP_PRSL_DTL |
GML.OP_PRSL_DTL does not reference any database object
GML.OP_PRSL_DTL is referenced by following:
| Description: | Shadow table of OP_PRSL_DTL for EFC migration. |
|---|
GML.OP_PRSL_DTL_EFC does not reference any database object
GML.OP_PRSL_DTL_EFC is referenced by following:
| Description: | Order Profile Header and Blanket Sales Order Header. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_PRSL_HDR.BILLING_CURRENCY | GL_CURR_MST |
| OP_PRSL_HDR.FROM_WHSE | IC_WHSE_MST |
| OP_PRSL_HDR.TO_WHSE | IC_WHSE_MST |
| OP_PRSL_HDR.COMMISSION_CODE | OP_COMMISSION |
| OP_PRSL_HDR.CUSTTRADE_CLASS | OP_CTRD_CLS |
| OP_PRSL_HDR.CONTACT_ID | OP_CUST_CON |
| OP_PRSL_HDR.SHIPCUST_ID | OP_CUST_MST |
| OP_PRSL_HDR.BILLCUST_ID | OP_CUST_MST |
| OP_PRSL_HDR.ULTIMATE_SHIPCUST_ID | OP_CUST_MST |
| OP_PRSL_HDR.SOLDTOCUST_ID | OP_CUST_MST |
| OP_PRSL_HDR.CONSIGNEE_ID | OP_CUST_MST |
| OP_PRSL_HDR.FOB_CODE | OP_FOBC_MST |
| OP_PRSL_HDR.FRTBILL_MTHD | OP_FRGT_MTH |
| OP_PRSL_HDR.HOLDREAS_CODE | OP_HOLD_CDS |
| OP_PRSL_HDR.REMIT_TO_LOCKBOX | OP_LKBX_MST |
| OP_PRSL_HDR.EMBARKATION_PORT | OP_PORT_MST |
| OP_PRSL_HDR.DEBARKATION_PORT | OP_PORT_MST |
| OP_PRSL_HDR.PRESALES_ORD_TYPE | OP_PRSL_TYP_B |
| OP_PRSL_HDR.SHIPPER_CODE | OP_SHIP_MST |
| OP_PRSL_HDR.SHIP_MTHD | OP_SHIP_MTH |
| OP_PRSL_HDR.SLSREP_CODE | OP_SLSR_MST |
| OP_PRSL_HDR.TERMS_CODE | OP_TERM_MST |
| OP_PRSL_HDR.TEXT_CODE | OP_TEXT_HDR |
| OP_PRSL_HDR.SHIPADDR_ID | SY_ADDR_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ORDR_HDR.PRESALES_ORD_ID | OP_PRSL_HDR |
| OP_PRSL_CHG.PRESALES_ORD_ID | OP_PRSL_HDR |
| OP_PRSL_DTL.PRESALES_ORD_ID | OP_PRSL_HDR |
GML.OP_PRSL_HDR does not reference any database object
GML.OP_PRSL_HDR is referenced by following:
| Description: | Shadow table of OP_PRSL_HDRL for EFC migration. |
|---|
GML.OP_PRSL_HDR_EFC does not reference any database object
GML.OP_PRSL_HDR_EFC is referenced by following:
| Description: | This table is not used in 11i. |
|---|
GML.OP_PRSL_MOD does not reference any database object
GML.OP_PRSL_MOD is referenced by following:
| Description: | This table is not used in 11i. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_PRSL_HDR.PRESALES_ORD_TYPE | OP_PRSL_TYP_B |
GML.OP_PRSL_TYP_B does not reference any database object
GML.OP_PRSL_TYP_B is referenced by following:
| Description: | This table is not used in 11i. |
|---|
GML.OP_PRSL_TYP_TL does not reference any database object
GML.OP_PRSL_TYP_TL is referenced by following:
| Description: | Blanket Sales Order Release Schedules. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_RELS_SCH.TO_WHSE | IC_WHSE_MST |
| OP_RELS_SCH.FROM_WHSE | IC_WHSE_MST |
| OP_RELS_SCH.PRESALES_ORDLINE_ID | OP_PRSL_DTL |
| OP_RELS_SCH.SHIPPER_CODE | OP_SHIP_MST |
| OP_RELS_SCH.SHIP_MTHD | OP_SHIP_MTH |
| OP_RELS_SCH.TEXT_CODE | OP_TEXT_HDR |
| OP_RELS_SCH.SHIPADDR_ID | SY_ADDR_MST |
| OP_RELS_SCH.ORDER_UM1 | SY_UOMS_MST |
| OP_RELS_SCH.ORDER_UM2 | SY_UOMS_MST |
GML.OP_RELS_SCH does not reference any database object
GML.OP_RELS_SCH is referenced by following:
| Description: | Carrier (shipper) codes . |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_SHIP_MST.TEXT_CODE | OP_TEXT_HDR |
| OP_SHIP_MST.ADDR_ID | SY_ADDR_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_BILL_LAD.SHIPPER_CODE | OP_SHIP_MST |
| OP_CUST_SHP.SHIPPER_CODE | OP_SHIP_MST |
| OP_ORDR_DTL.SHIPPER_CODE | OP_SHIP_MST |
| OP_ORDR_HDR.SHIPPER_CODE | OP_SHIP_MST |
| OP_PRSL_DTL.SHIPPER_CODE | OP_SHIP_MST |
| OP_PRSL_HDR.SHIPPER_CODE | OP_SHIP_MST |
| OP_RELS_SCH.SHIPPER_CODE | OP_SHIP_MST |
| OP_SHIP_MTH.PREFERRED_SHIPPER | OP_SHIP_MST |
| PO_BPOS_DTL.SHIPPER_CODE | OP_SHIP_MST |
| PO_BPOS_HDR.SHIPPER_CODE | OP_SHIP_MST |
| PO_ORDR_DTL.SHIPPER_CODE | OP_SHIP_MST |
| PO_ORDR_HDR.SHIPPER_CODE | OP_SHIP_MST |
| PO_RECV_DTL.SHIPPER_CODE | OP_SHIP_MST |
| PO_RECV_HDR.SHIPPER_CODE | OP_SHIP_MST |
| PO_RELS_SCH.SHIPPER_CODE | OP_SHIP_MST |
| PO_RTRN_HDR.SHIPPER_CODE | OP_SHIP_MST |
GML.OP_SHIP_MST does not reference any database object
GML.OP_SHIP_MST is referenced by following:
| Description: | Shipping method codes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_SHIP_MTH.PREFERRED_SHIPPER | OP_SHIP_MST |
| OP_SHIP_MTH.TEXT_CODE | OP_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_SHP.SHIP_MTHD | OP_SHIP_MTH |
| OP_ORDR_DTL.SHIP_MTHD | OP_SHIP_MTH |
| OP_ORDR_HDR.SHIP_MTHD | OP_SHIP_MTH |
| OP_PRSL_DTL.SHIP_MTHD | OP_SHIP_MTH |
| OP_PRSL_HDR.SHIP_MTHD | OP_SHIP_MTH |
| OP_RELS_SCH.SHIP_MTHD | OP_SHIP_MTH |
| PO_BPOS_DTL.SHIP_MTHD | OP_SHIP_MTH |
| PO_BPOS_HDR.SHIP_MTHD | OP_SHIP_MTH |
| PO_ORDR_DTL.SHIP_MTHD | OP_SHIP_MTH |
| PO_ORDR_HDR.SHIP_MTHD | OP_SHIP_MTH |
| PO_RECV_DTL.SHIP_MTHD | OP_SHIP_MTH |
| PO_RECV_HDR.SHIP_MTHD | OP_SHIP_MTH |
| PO_RELS_SCH.SHIP_MTHD | OP_SHIP_MTH |
GML.OP_SHIP_MTH does not reference any database object
GML.OP_SHIP_MTH is referenced by following:
| Description: | Sales representative classes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_SLSR_CLS.TEXT_CODE | OP_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_SLSR_MST.SLSREP_CLASS | OP_SLSR_CLS |
GML.OP_SLSR_CLS does not reference any database object
GML.OP_SLSR_CLS is referenced by following:
| Description: | Sales representative master table. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_SLSR_MST.COMMISSION_CODE | OP_COMMISSION |
| OP_SLSR_MST.SLSREP_CLASS | OP_SLSR_CLS |
| OP_SLSR_MST.TEXT_CODE | OP_TEXT_HDR |
| OP_SLSR_MST.ADDR_ID | SY_ADDR_MST |
| OP_SLSR_MST.CO_CODE | SY_ORGN_MST_B |
| OP_SLSR_MST.CO_CODE | SY_ORGN_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_COMM_CDS.SLSREP_CODE | OP_SLSR_MST |
| OP_CUST_MST_OPM.SLSREP_CODE | OP_SLSR_MST |
| OP_CUST_MST.SLSREP_CODE | OP_SLSR_MST |
| OP_ORDR_DTL.SLSREP_CODE | OP_SLSR_MST |
| OP_ORDR_HDR.SLSREP_CODE | OP_SLSR_MST |
| OP_PRSL_DTL.SLSREP_CODE | OP_SLSR_MST |
| OP_PRSL_HDR.SLSREP_CODE | OP_SLSR_MST |
GML.OP_SLSR_MST does not reference any database object
GML.OP_SLSR_MST is referenced by following:
| Description: | Sales representative interface table used to transfer data from Oracle Receivables. |
|---|
GML.OP_SLSR_MST_INT does not reference any database object
GML.OP_SLSR_MST_INT is referenced by following:
| Description: | Payment terms codes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_TERM_MST.TEXT_CODE | OP_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_MST_OPM.TERMS_CODE | OP_TERM_MST |
| OP_CUST_MST.TERMS_CODE | OP_TERM_MST |
| OP_ORDR_DTL.TERMS_CODE | OP_TERM_MST |
| OP_ORDR_HDR.TERMS_CODE | OP_TERM_MST |
| OP_PRSL_DTL.TERMS_CODE | OP_TERM_MST |
| OP_PRSL_HDR.TERMS_CODE | OP_TERM_MST |
| PO_BPOS_DTL.TERMS_CODE | OP_TERM_MST |
| PO_BPOS_HDR.TERMS_CODE | OP_TERM_MST |
| PO_ORDR_DTL.TERMS_CODE | OP_TERM_MST |
| PO_ORDR_HDR.TERMS_CODE | OP_TERM_MST |
| PO_VEND_MST.TERMS_CODE | OP_TERM_MST |
GML.OP_TERM_MST does not reference any database object
GML.OP_TERM_MST is referenced by following:
| Description: | This table is not used in 11i. |
|---|
GML.OP_TERM_MST_INT does not reference any database object
GML.OP_TERM_MST_INT is referenced by following:
| Description: | Header text table for the Order Fulfillment application. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_ALOT_PRM.TEXT_CODE | OP_TEXT_HDR |
| OP_BILL_LAD.TEXT_CODE | OP_TEXT_HDR |
| OP_CGLD_CLS.TEXT_CODE | OP_TEXT_HDR |
| OP_CHRG_CLS.TEXT_CODE | OP_TEXT_HDR |
| OP_CHRG_MST.TEXT_CODE | OP_TEXT_HDR |
| OP_CNTR_DTL.TEXT_CODE | OP_TEXT_HDR |
| OP_CNTR_HDR.TEXT_CODE | OP_TEXT_HDR |
| OP_COMM_CDS.TEXT_CODE | OP_TEXT_HDR |
| OP_CPRC_CLS.TEXT_CODE | OP_TEXT_HDR |
| OP_CTRD_CLS.TEXT_CODE | OP_TEXT_HDR |
| OP_CUST_ASC.TEXT_CODE | OP_TEXT_HDR |
| OP_CUST_CLS.TEXT_CODE | OP_TEXT_HDR |
| OP_CUST_MST_OPM.TEXT_CODE | OP_TEXT_HDR |
| OP_CUST_MST.TEXT_CODE | OP_TEXT_HDR |
| OP_CUST_SHP.TEXT_CODE | OP_TEXT_HDR |
| OP_FOBC_MST.TEXT_CODE | OP_TEXT_HDR |
| OP_FRGT_MTH.TEXT_CODE | OP_TEXT_HDR |
| OP_GNRC_ITM.TEXT_CODE | OP_TEXT_HDR |
| OP_HOLD_CDS.TEXT_CODE | OP_TEXT_HDR |
| OP_ORDR_DTL.TEXT_CODE | OP_TEXT_HDR |
| OP_ORDR_HDR.TEXT_CODE | OP_TEXT_HDR |
| OP_PORT_MST.TEXT_CODE | OP_TEXT_HDR |
| OP_PRCE_EFF.TEXT_CODE | OP_TEXT_HDR |
| OP_PRCE_ITM.TEXT_CODE | OP_TEXT_HDR |
| OP_PRCE_MST.TEXT_CODE | OP_TEXT_HDR |
| OP_PRSL_DTL.TEXT_CODE | OP_TEXT_HDR |
| OP_PRSL_HDR.TEXT_CODE | OP_TEXT_HDR |
| OP_RELS_SCH.TEXT_CODE | OP_TEXT_HDR |
| OP_SHIP_MST.TEXT_CODE | OP_TEXT_HDR |
| OP_SHIP_MTH.TEXT_CODE | OP_TEXT_HDR |
| OP_SLSR_CLS.TEXT_CODE | OP_TEXT_HDR |
| OP_SLSR_MST.TEXT_CODE | OP_TEXT_HDR |
| OP_TERM_MST.TEXT_CODE | OP_TEXT_HDR |
| OP_TXCU_ASC.TEXT_CODE | OP_TEXT_HDR |
GML.OP_TEXT_HDR does not reference any database object
GML.OP_TEXT_HDR is referenced by following:
| Description: | Text for the Order Fulfillment Application. |
|---|
GML.OP_TEXT_TBL_TL does not reference any database object
GML.OP_TEXT_TBL_TL is referenced by following:
| Description: | Table used by automatic inventory allocation in Shipping. |
|---|
GML.OP_TRAN_TMP does not reference any database object
GML.OP_TRAN_TMP is referenced by following:
| Description: | Customer tax exemption information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| OP_TXCU_ASC.CUST_ID | OP_CUST_MST |
| OP_TXCU_ASC.TEXT_CODE | OP_TEXT_HDR |
| OP_TXCU_ASC.TAXAUTH_ID | TX_TAXA_MST |
| OP_TXCU_ASC.TAX_STATUS | TX_TAXA_STS |
GML.OP_TXCU_ASC does not reference any database object
GML.OP_TXCU_ASC is referenced by following:
| Description: | Table used by the " Update Customer Balance Report". |
|---|
GML.OP_UPDT_BAL_WK does not reference any database object
GML.OP_UPDT_BAL_WK is referenced by following:
| Description: | Blanket purchase order lines. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_BPOS_DTL.QC_GRADE_WANTED | GMD_GRADES_B |
| PO_BPOS_DTL.ITEM_ID | IC_ITEM_MST_B |
| PO_BPOS_DTL.ITEM_ID | IC_ITEM_MST |
| PO_BPOS_DTL.ICPURCH_CLASS | IC_PRCH_CLS |
| PO_BPOS_DTL.FROM_WHSE | IC_WHSE_MST |
| PO_BPOS_DTL.TO_WHSE | IC_WHSE_MST |
| PO_BPOS_DTL.FOB_CODE | OP_FOBC_MST |
| PO_BPOS_DTL.FRTBILL_MTHD | OP_FRGT_MTH |
| PO_BPOS_DTL.GENERIC_ID | OP_GNRC_ITM |
| PO_BPOS_DTL.SHIPPER_CODE | OP_SHIP_MST |
| PO_BPOS_DTL.SHIP_MTHD | OP_SHIP_MTH |
| PO_BPOS_DTL.TERMS_CODE | OP_TERM_MST |
| PO_BPOS_DTL.BPO_ID | PO_BPOS_HDR |
| PO_BPOS_DTL.TEXT_CODE | PO_TEXT_HDR |
| PO_BPOS_DTL.SHIPVEND_ID | PO_VEND_MST |
| PO_BPOS_DTL.QC_GRADE_WANTED | QC_GRAD_MST |
| PO_BPOS_DTL.RECVADDR_ID | SY_ADDR_MST |
| PO_BPOS_DTL.BPOHOLD_CODE | SY_REAS_CDS_B |
| PO_BPOS_DTL.CANCELLATION_CODE | SY_REAS_CDS_B |
| PO_BPOS_DTL.CLOSURE_CODE | SY_REAS_CDS_B |
| PO_BPOS_DTL.BPOHOLD_CODE | SY_REAS_CDS |
| PO_BPOS_DTL.CANCELLATION_CODE | SY_REAS_CDS |
| PO_BPOS_DTL.CLOSURE_CODE | SY_REAS_CDS |
| PO_BPOS_DTL.ITEM_UM | SY_UOMS_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| PO_ORDR_DTL.BPO_LINE_ID | PO_BPOS_DTL |
| PO_RELS_SCH.BPOLINE_ID | PO_BPOS_DTL |
GML.PO_BPOS_DTL does not reference any database object
GML.PO_BPOS_DTL is referenced by following:
| Description: | Header information for blanket purchase orders. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_BPOS_HDR.CONTRACT_CURRENCY | GL_CURR_MST |
| PO_BPOS_HDR.ICPURCH_CLASS | IC_PRCH_CLS |
| PO_BPOS_HDR.FOB_CODE | OP_FOBC_MST |
| PO_BPOS_HDR.FRTBILL_MTHD | OP_FRGT_MTH |
| PO_BPOS_HDR.SHIPPER_CODE | OP_SHIP_MST |
| PO_BPOS_HDR.SHIP_MTHD | OP_SHIP_MTH |
| PO_BPOS_HDR.TERMS_CODE | OP_TERM_MST |
| PO_BPOS_HDR.TEXT_CODE | PO_TEXT_HDR |
| PO_BPOS_HDR.PAYVEND_ID | PO_VEND_MST |
| PO_BPOS_HDR.SHIPVEND_ID | PO_VEND_MST |
| PO_BPOS_HDR.ORGNADDR_ID | SY_ADDR_MST |
| PO_BPOS_HDR.ORGN_CODE | SY_ORGN_MST_B |
| PO_BPOS_HDR.ORGN_CODE | SY_ORGN_MST |
| PO_BPOS_HDR.BPOHOLD_CODE | SY_REAS_CDS_B |
| PO_BPOS_HDR.CANCELLATION_CODE | SY_REAS_CDS_B |
| PO_BPOS_HDR.CLOSURE_CODE | SY_REAS_CDS_B |
| PO_BPOS_HDR.BPOHOLD_CODE | SY_REAS_CDS |
| PO_BPOS_HDR.CANCELLATION_CODE | SY_REAS_CDS |
| PO_BPOS_HDR.CLOSURE_CODE | SY_REAS_CDS |
| Foreign Key Column | Foreign Table |
|---|---|
| PO_BPOS_DTL.BPO_ID | PO_BPOS_HDR |
| PO_ORDR_HDR.BPO_ID | PO_BPOS_HDR |
GML.PO_BPOS_HDR does not reference any database object
GML.PO_BPOS_HDR is referenced by following:
| Description: | Shadow table of PO_BPOS_HDR for EFC migration. |
|---|
GML.PO_BPOS_HDR_EFC does not reference any database object
GML.PO_BPOS_HDR_EFC is referenced by following:
| Description: | Acquistion cost details for a purchase order or a stock receipt. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_COST_DTL.AQUI_COST_ID | PO_COST_MST |
| PO_COST_DTL.TEXT_CODE | PO_TEXT_HDR |
| PO_COST_DTL.DOC_TYPE | SY_DOCS_MST |
GML.PO_COST_DTL does not reference any database object
GML.PO_COST_DTL is referenced by following:
| Description: | Acquisition costs master table. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_COST_MST.ANALYSIS_CODE | CM_ALYS_MST |
| PO_COST_MST.CMPNTCLS_ID | CM_CMPT_MST_B |
| PO_COST_MST.CMPNTCLS_ID | CM_CMPT_MST |
| PO_COST_MST.TEXT_CODE | PO_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_MAP.AQUI_COST_ID | PO_COST_MST |
| PO_COST_DTL.AQUI_COST_ID | PO_COST_MST |
| PO_DIST_DTL.AQUI_COST_ID | PO_COST_MST |
GML.PO_COST_MST does not reference any database object
GML.PO_COST_MST is referenced by following:
| Description: | General Ledger (GL) distribution for purchase orders and stock receipt transactions. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_DIST_DTL.ACCT_ID | GL_ACCT_MST |
| PO_DIST_DTL.ACCT_TTL_TYPE | GL_ACCT_TTL |
| PO_DIST_DTL.ACCTG_UNIT_ID | GL_ACCU_MST |
| PO_DIST_DTL.CURRENCY_TRANS | GL_CURR_MST |
| PO_DIST_DTL.CURRENCY_BASE | GL_CURR_MST |
| PO_DIST_DTL.LEDGER_CODE | GL_LDGR_MST |
| PO_DIST_DTL.ITEM_ID | IC_ITEM_MST_B |
| PO_DIST_DTL.ITEM_ID | IC_ITEM_MST |
| PO_DIST_DTL.AQUI_COST_ID | PO_COST_MST |
| PO_DIST_DTL.TEXT_CODE | PO_TEXT_HDR |
| PO_DIST_DTL.DOC_TYPE | SY_DOCS_MST |
| PO_DIST_DTL.CO_CODE | SY_ORGN_MST_B |
| PO_DIST_DTL.CO_CODE | SY_ORGN_MST |
| PO_DIST_DTL.QUANTITY_UM | SY_UOMS_MST |
GML.PO_DIST_DTL does not reference any database object
GML.PO_DIST_DTL is referenced by following:
| Description: | Shadow table of PO_DIST_DTL for EFC migration. |
|---|
GML.PO_DIST_DTL_EFC does not reference any database object
GML.PO_DIST_DTL_EFC is referenced by following:
| Description: | Purchase order lines. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_ORDR_DTL.QC_GRADE_WANTED | GMD_GRADES_B |
| PO_ORDR_DTL.ITEM_ID | IC_ITEM_MST_B |
| PO_ORDR_DTL.ITEM_ID | IC_ITEM_MST |
| PO_ORDR_DTL.ICPURCH_CLASS | IC_PRCH_CLS |
| PO_ORDR_DTL.FROM_WHSE | IC_WHSE_MST |
| PO_ORDR_DTL.TO_WHSE | IC_WHSE_MST |
| PO_ORDR_DTL.FOB_CODE | OP_FOBC_MST |
| PO_ORDR_DTL.FRTBILL_MTHD | OP_FRGT_MTH |
| PO_ORDR_DTL.GENERIC_ID | OP_GNRC_ITM |
| PO_ORDR_DTL.SHIPPER_CODE | OP_SHIP_MST |
| PO_ORDR_DTL.SHIP_MTHD | OP_SHIP_MTH |
| PO_ORDR_DTL.TERMS_CODE | OP_TERM_MST |
| PO_ORDR_DTL.BPO_LINE_ID | PO_BPOS_DTL |
| PO_ORDR_DTL.PO_ID | PO_ORDR_HDR |
| PO_ORDR_DTL.TEXT_CODE | PO_TEXT_HDR |
| PO_ORDR_DTL.SHIPVEND_ID | PO_VEND_MST |
| PO_ORDR_DTL.QC_GRADE_WANTED | QC_GRAD_MST |
| PO_ORDR_DTL.RECVADDR_ID | SY_ADDR_MST |
| PO_ORDR_DTL.POHOLD_CODE | SY_REAS_CDS_B |
| PO_ORDR_DTL.CANCELLATION_CODE | SY_REAS_CDS_B |
| PO_ORDR_DTL.POHOLD_CODE | SY_REAS_CDS |
| PO_ORDR_DTL.CANCELLATION_CODE | SY_REAS_CDS |
| PO_ORDR_DTL.ORDER_UM1 | SY_UOMS_MST |
| PO_ORDR_DTL.ORDER_UM2 | SY_UOMS_MST |
| PO_ORDR_DTL.PRICE_UM | SY_UOMS_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| PO_RECV_DTL.POLINE_ID | PO_ORDR_DTL |
| PO_RELS_SCH.POLINE_ID | PO_ORDR_DTL |
| PO_RTRN_DTL.POLINE_ID | PO_ORDR_DTL |
GML.PO_ORDR_DTL does not reference any database object
GML.PO_ORDR_DTL is referenced by following:
| Description: | Purchase order header. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_ORDR_HDR.BILLING_CURRENCY | GL_CURR_MST |
| PO_ORDR_HDR.ICPURCH_CLASS | IC_PRCH_CLS |
| PO_ORDR_HDR.FROM_WHSE | IC_WHSE_MST |
| PO_ORDR_HDR.TO_WHSE | IC_WHSE_MST |
| PO_ORDR_HDR.FOB_CODE | OP_FOBC_MST |
| PO_ORDR_HDR.FRTBILL_MTHD | OP_FRGT_MTH |
| PO_ORDR_HDR.SHIPPER_CODE | OP_SHIP_MST |
| PO_ORDR_HDR.SHIP_MTHD | OP_SHIP_MTH |
| PO_ORDR_HDR.TERMS_CODE | OP_TERM_MST |
| PO_ORDR_HDR.BPO_ID | PO_BPOS_HDR |
| PO_ORDR_HDR.TEXT_CODE | PO_TEXT_HDR |
| PO_ORDR_HDR.PAYVEND_ID | PO_VEND_MST |
| PO_ORDR_HDR.SHIPVEND_ID | PO_VEND_MST |
| PO_ORDR_HDR.RECVADDR_ID | SY_ADDR_MST |
| PO_ORDR_HDR.ORGN_CODE | SY_ORGN_MST_B |
| PO_ORDR_HDR.ORGN_CODE | SY_ORGN_MST |
| PO_ORDR_HDR.POHOLD_CODE | SY_REAS_CDS_B |
| PO_ORDR_HDR.CANCELLATION_CODE | SY_REAS_CDS_B |
| PO_ORDR_HDR.POHOLD_CODE | SY_REAS_CDS |
| PO_ORDR_HDR.CANCELLATION_CODE | SY_REAS_CDS |
| Foreign Key Column | Foreign Table |
|---|---|
| PO_ORDR_DTL.PO_ID | PO_ORDR_HDR |
| PO_RECV_DTL.PO_ID | PO_ORDR_HDR |
| PO_RTRN_DTL.PO_ID | PO_ORDR_HDR |
GML.PO_ORDR_HDR does not reference any database object
GML.PO_ORDR_HDR is referenced by following:
| Description: | Shadow table of PO_ORDR_HDR for EFC migration. |
|---|
GML.PO_ORDR_HDR_EFC does not reference any database object
GML.PO_ORDR_HDR_EFC is referenced by following:
| Description: | Receipt lines. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_RECV_DTL.ITEM_ID | IC_ITEM_MST_B |
| PO_RECV_DTL.ITEM_ID | IC_ITEM_MST |
| PO_RECV_DTL.TO_WHSE | IC_WHSE_MST |
| PO_RECV_DTL.FROM_WHSE | IC_WHSE_MST |
| PO_RECV_DTL.FOB_CODE | OP_FOBC_MST |
| PO_RECV_DTL.FRTBILL_MTHD | OP_FRGT_MTH |
| PO_RECV_DTL.SHIPPER_CODE | OP_SHIP_MST |
| PO_RECV_DTL.SHIP_MTHD | OP_SHIP_MTH |
| PO_RECV_DTL.POLINE_ID | PO_ORDR_DTL |
| PO_RECV_DTL.PO_ID | PO_ORDR_HDR |
| PO_RECV_DTL.RECV_ID | PO_RECV_HDR |
| PO_RECV_DTL.TEXT_CODE | PO_TEXT_HDR |
| PO_RECV_DTL.SHIPVEND_ID | PO_VEND_MST |
| PO_RECV_DTL.RECVADDR_ID | SY_ADDR_MST |
| PO_RECV_DTL.RECV_UM1 | SY_UOMS_MST |
| PO_RECV_DTL.RECV_UM2 | SY_UOMS_MST |
| PO_RECV_DTL.PRICE_UM | SY_UOMS_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| PO_RTRN_DTL.RECVLINE_ID | PO_RECV_DTL |
GML.PO_RECV_DTL does not reference any database object
GML.PO_RECV_DTL is referenced by following:
| Description: | Receipt header. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_RECV_HDR.DEMURRAGE_CURRENCY | GL_CURR_MST |
| PO_RECV_HDR.BILLING_CURRENCY | GL_CURR_MST |
| PO_RECV_HDR.TO_WHSE | IC_WHSE_MST |
| PO_RECV_HDR.DEBARKATION_PORT | OP_PORT_MST |
| PO_RECV_HDR.EMBARKATION_PORT | OP_PORT_MST |
| PO_RECV_HDR.SHIPPER_CODE | OP_SHIP_MST |
| PO_RECV_HDR.SHIP_MTHD | OP_SHIP_MTH |
| PO_RECV_HDR.TEXT_CODE | PO_TEXT_HDR |
| PO_RECV_HDR.SHIPVEND_ID | PO_VEND_MST |
| PO_RECV_HDR.PAYVEND_ID | PO_VEND_MST |
| PO_RECV_HDR.ORGN_CODE | SY_ORGN_MST_B |
| PO_RECV_HDR.ORGN_CODE | SY_ORGN_MST |
| PO_RECV_HDR.REASON_CODE | SY_REAS_CDS_B |
| PO_RECV_HDR.REASON_CODE | SY_REAS_CDS |
| PO_RECV_HDR.BOL_UM | SY_UOMS_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| PO_RECV_DTL.RECV_ID | PO_RECV_HDR |
| PO_RTRN_DTL.RECV_ID | PO_RECV_HDR |
GML.PO_RECV_HDR does not reference any database object
GML.PO_RECV_HDR is referenced by following:
| Description: | Shadow table of PO_RECV_HDR for EFC migration. |
|---|
GML.PO_RECV_HDR_EFC does not reference any database object
GML.PO_RECV_HDR_EFC is referenced by following:
| Description: | Audit trail of quantity and price changes made to a receipt or return line. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_RECV_HST.SUB_EVENT_TYPE | GL_SEVT_MST |
| PO_RECV_HST.TO_WHSE | IC_WHSE_MST |
| PO_RECV_HST.TEXT_CODE | PO_TEXT_HDR |
| PO_RECV_HST.PRICE_UM | SY_UOMS_MST |
GML.PO_RECV_HST does not reference any database object
GML.PO_RECV_HST is referenced by following:
| Description: | Shadow table of PO_RECV_HST for EFC migration. |
|---|
GML.PO_RECV_HST_EFC does not reference any database object
GML.PO_RECV_HST_EFC is referenced by following:
| Description: | Release schedules for a blanket purchase order. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_RELS_SCH.FROM_WHSE | IC_WHSE_MST |
| PO_RELS_SCH.TO_WHSE | IC_WHSE_MST |
| PO_RELS_SCH.SHIPPER_CODE | OP_SHIP_MST |
| PO_RELS_SCH.SHIP_MTHD | OP_SHIP_MTH |
| PO_RELS_SCH.BPOLINE_ID | PO_BPOS_DTL |
| PO_RELS_SCH.POLINE_ID | PO_ORDR_DTL |
| PO_RELS_SCH.TEXT_CODE | PO_TEXT_HDR |
| PO_RELS_SCH.RECVADDR_ID | SY_ADDR_MST |
| PO_RELS_SCH.ORDER_UM1 | SY_UOMS_MST |
| PO_RELS_SCH.ORDER_UM2 | SY_UOMS_MST |
GML.PO_RELS_SCH does not reference any database object
GML.PO_RELS_SCH is referenced by following:
| Description: | Return lines. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_RTRN_DTL.ITEM_ID | IC_ITEM_MST_B |
| PO_RTRN_DTL.ITEM_ID | IC_ITEM_MST |
| PO_RTRN_DTL.POLINE_ID | PO_ORDR_DTL |
| PO_RTRN_DTL.PO_ID | PO_ORDR_HDR |
| PO_RTRN_DTL.RECVLINE_ID | PO_RECV_DTL |
| PO_RTRN_DTL.RECV_ID | PO_RECV_HDR |
| PO_RTRN_DTL.RETURN_ID | PO_RTRN_HDR |
| PO_RTRN_DTL.TEXT_CODE | PO_TEXT_HDR |
| PO_RTRN_DTL.RETURN_CODE | SY_REAS_CDS_B |
| PO_RTRN_DTL.RETURN_CODE | SY_REAS_CDS |
| PO_RTRN_DTL.RETURN_UM1 | SY_UOMS_MST |
| PO_RTRN_DTL.RETURN_UM2 | SY_UOMS_MST |
GML.PO_RTRN_DTL does not reference any database object
GML.PO_RTRN_DTL is referenced by following:
| Description: | Return header. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_RTRN_HDR.SHIPPER_CODE | OP_SHIP_MST |
| PO_RTRN_HDR.TEXT_CODE | PO_TEXT_HDR |
| PO_RTRN_HDR.RETURN_VENDOR_ID | PO_VEND_MST |
| PO_RTRN_HDR.RTRNADDR_ID | SY_ADDR_MST |
| PO_RTRN_HDR.ORGN_CODE | SY_ORGN_MST_B |
| PO_RTRN_HDR.ORGN_CODE | SY_ORGN_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| PO_RTRN_DTL.RETURN_ID | PO_RTRN_HDR |
GML.PO_RTRN_HDR does not reference any database object
GML.PO_RTRN_HDR is referenced by following:
| Description: | Header text table for OPM Purchasing application. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_BPOS_DTL.TEXT_CODE | PO_TEXT_HDR |
| PO_BPOS_HDR.TEXT_CODE | PO_TEXT_HDR |
| PO_COST_DTL.TEXT_CODE | PO_TEXT_HDR |
| PO_COST_MST.TEXT_CODE | PO_TEXT_HDR |
| PO_DIST_DTL.TEXT_CODE | PO_TEXT_HDR |
| PO_ORDR_DTL.TEXT_CODE | PO_TEXT_HDR |
| PO_ORDR_HDR.TEXT_CODE | PO_TEXT_HDR |
| PO_RECV_DTL.TEXT_CODE | PO_TEXT_HDR |
| PO_RECV_HDR.TEXT_CODE | PO_TEXT_HDR |
| PO_RECV_HST.TEXT_CODE | PO_TEXT_HDR |
| PO_RELS_SCH.TEXT_CODE | PO_TEXT_HDR |
| PO_RTRN_DTL.TEXT_CODE | PO_TEXT_HDR |
| PO_RTRN_HDR.TEXT_CODE | PO_TEXT_HDR |
| PO_VEND_ASC.TEXT_CODE | PO_TEXT_HDR |
| PO_VEND_CLS.TEXT_CODE | PO_TEXT_HDR |
| PO_VEND_MST.TEXT_CODE | PO_TEXT_HDR |
| PO_VGLD_CLS.TEXT_CODE | PO_TEXT_HDR |
| PO_VTRD_CLS.TEXT_CODE | PO_TEXT_HDR |
GML.PO_TEXT_HDR does not reference any database object
GML.PO_TEXT_HDR is referenced by following:
| Description: | Text for the OPM Purchasing application. |
|---|
GML.PO_TEXT_TBL_TL does not reference any database object
GML.PO_TEXT_TBL_TL is referenced by following:
| Description: | Vendor associations/relationships. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_VEND_ASC.TEXT_CODE | PO_TEXT_HDR |
| PO_VEND_ASC.ASSOCVEND_ID | PO_VEND_MST |
| PO_VEND_ASC.VEND_ID | PO_VEND_MST |
GML.PO_VEND_ASC does not reference any database object
GML.PO_VEND_ASC is referenced by following:
| Description: | Vendor classes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_VEND_CLS.TEXT_CODE | PO_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| PO_VEND_MST.VEND_CLASS | PO_VEND_CLS |
GML.PO_VEND_CLS does not reference any database object
GML.PO_VEND_CLS is referenced by following:
| Description: | Vendor master. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_VEND_MST.DEFAULT_CURRENCY | GL_CURR_MST |
| PO_VEND_MST.FRTBILL_MTHD | OP_FRGT_MTH |
| PO_VEND_MST.TERMS_CODE | OP_TERM_MST |
| PO_VEND_MST.TEXT_CODE | PO_TEXT_HDR |
| PO_VEND_MST.VEND_CLASS | PO_VEND_CLS |
| PO_VEND_MST.VENDGL_CLASS | PO_VGLD_CLS |
| PO_VEND_MST.VENDTRADE_CLASS | PO_VTRD_CLS |
| PO_VEND_MST.ADDR_ID | SY_ADDR_MST |
| PO_VEND_MST.MAILADDR_ID | SY_ADDR_MST |
| PO_VEND_MST.CO_CODE | SY_ORGN_MST_B |
| PO_VEND_MST.CO_CODE | SY_ORGN_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_MAP.VENDOR_ID | PO_VEND_MST |
| IC_LOTS_MST.SHIPVEND_ID | PO_VEND_MST |
| OP_GNRC_ITM.VENDOR_ID | PO_VEND_MST |
| PO_BPOS_DTL.SHIPVEND_ID | PO_VEND_MST |
| PO_BPOS_HDR.PAYVEND_ID | PO_VEND_MST |
| PO_BPOS_HDR.SHIPVEND_ID | PO_VEND_MST |
| PO_ORDR_DTL.SHIPVEND_ID | PO_VEND_MST |
| PO_ORDR_HDR.PAYVEND_ID | PO_VEND_MST |
| PO_ORDR_HDR.SHIPVEND_ID | PO_VEND_MST |
| PO_RECV_DTL.SHIPVEND_ID | PO_VEND_MST |
| PO_RECV_HDR.SHIPVEND_ID | PO_VEND_MST |
| PO_RECV_HDR.PAYVEND_ID | PO_VEND_MST |
| PO_RTRN_HDR.RETURN_VENDOR_ID | PO_VEND_MST |
| PO_VEND_ASC.ASSOCVEND_ID | PO_VEND_MST |
| PO_VEND_ASC.VEND_ID | PO_VEND_MST |
| PO_VNIT_MST.VENDOR_ID | PO_VEND_MST |
| QC_RSLT_MST.VENDOR_ID | PO_VEND_MST |
| QC_SMPL_MST.VENDOR_ID | PO_VEND_MST |
| QC_SPEC_MST.VENDOR_ID | PO_VEND_MST |
GML.PO_VEND_MST does not reference any database object
GML.PO_VEND_MST is referenced by following:
| Description: | This table is not used in 11i. |
|---|
GML.PO_VEND_MST_INT does not reference any database object
GML.PO_VEND_MST_INT is referenced by following:
| Description: | Vendor GL (General Ledger) classes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_VGLD_CLS.TEXT_CODE | PO_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_MAP.VENDGL_CLASS | PO_VGLD_CLS |
| PO_VEND_MST.VENDGL_CLASS | PO_VGLD_CLS |
GML.PO_VGLD_CLS does not reference any database object
GML.PO_VGLD_CLS is referenced by following:
| Description: | Vendor Item Table not supported in OPM Purchasing. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_VNIT_MST.ITEM_ID | IC_ITEM_MST_B |
| PO_VNIT_MST.ITEM_ID | IC_ITEM_MST |
| PO_VNIT_MST.WHSE_CODE | IC_WHSE_MST |
| PO_VNIT_MST.VENDOR_ID | PO_VEND_MST |
GML.PO_VNIT_MST does not reference any database object
GML.PO_VNIT_MST is referenced by following:
| Description: | Vendor trade class. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| PO_VTRD_CLS.TEXT_CODE | PO_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| PO_VEND_MST.VENDTRADE_CLASS | PO_VTRD_CLS |
GML.PO_VTRD_CLS does not reference any database object
GML.PO_VTRD_CLS is referenced by following:
| Description: | Tax calculation codes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| TX_CALC_MST.TEXT_CODE | TX_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_CUST_MST_OPM.TAXCALC_CODE | TX_CALC_MST |
| OP_CUST_MST.TAXCALC_CODE | TX_CALC_MST |
GML.TX_CALC_MST does not reference any database object
GML.TX_CALC_MST is referenced by following:
| Description: | This table is not used in 11i. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| TX_HIST_TAX.ICTAX_CLASS | IC_TAXN_CLS |
| TX_HIST_TAX.TAXAUTH_ID | TX_TAXA_MST |
GML.TX_HIST_TAX does not reference any database object
GML.TX_HIST_TAX is referenced by following:
| Description: | Tax rates by item and/or charge class for a tax authority. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| TX_TAXA_DTL.ICTAX_CLASS | IC_TAXN_CLS |
| TX_TAXA_DTL.CHGTAX_CLASS | OP_CHRG_CLS |
| TX_TAXA_DTL.TAXAUTH_ID | TX_TAXA_MST |
| TX_TAXA_DTL.TEXT_CODE | TX_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_INVC_CHG.TAXRATE_ID | TX_TAXA_DTL |
GML.TX_TAXA_DTL does not reference any database object
GML.TX_TAXA_DTL is referenced by following:
| Description: | Tax Authorities. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| TX_TAXA_MST.ADDR_ID | SY_ADDR_MST |
| TX_TAXA_MST.TEXT_CODE | TX_TEXT_HDR |
| TX_TAXA_MST.TAXRPT_CLASS | TX_TXRP_CLS |
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_MAP.TAXAUTH_ID | TX_TAXA_MST |
| OP_TXCU_ASC.TAXAUTH_ID | TX_TAXA_MST |
| TX_HIST_TAX.TAXAUTH_ID | TX_TAXA_MST |
| TX_TAXA_DTL.TAXAUTH_ID | TX_TAXA_MST |
| TX_TLOC_ASC.TAXAUTH_ID | TX_TAXA_MST |
GML.TX_TAXA_MST does not reference any database object
GML.TX_TAXA_MST is referenced by following:
| Description: | Tax status codes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| TX_TAXA_STS.TEXT_CODE | TX_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| OP_INVC_CHG.TAX_STATUS | TX_TAXA_STS |
| OP_TXCU_ASC.TAX_STATUS | TX_TAXA_STS |
GML.TX_TAXA_STS does not reference any database object
GML.TX_TAXA_STS is referenced by following:
| Description: | Header table for text for the Tax application in OPM. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| TX_CALC_MST.TEXT_CODE | TX_TEXT_HDR |
| TX_TAXA_DTL.TEXT_CODE | TX_TEXT_HDR |
| TX_TAXA_MST.TEXT_CODE | TX_TEXT_HDR |
| TX_TAXA_STS.TEXT_CODE | TX_TEXT_HDR |
| TX_TLOC_ASC.TEXT_CODE | TX_TEXT_HDR |
| TX_TLOC_CDS.TEXT_CODE | TX_TEXT_HDR |
| TX_TOFR_ASC.TEXT_CODE | TX_TEXT_HDR |
| TX_TXRE_CDS.TEXT_CODE | TX_TEXT_HDR |
| TX_TXRP_CLS.TEXT_CODE | TX_TEXT_HDR |
GML.TX_TEXT_HDR does not reference any database object
GML.TX_TEXT_HDR is referenced by following:
| Description: | Text for the Tax Application. |
|---|
GML.TX_TEXT_TBL_TL does not reference any database object
GML.TX_TEXT_TBL_TL is referenced by following:
| Description: | Tax Authorities that apply for a pair of tax locations. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| TX_TLOC_ASC.TAXAUTH_ID | TX_TAXA_MST |
| TX_TLOC_ASC.TEXT_CODE | TX_TEXT_HDR |
| TX_TLOC_ASC.TAXLOC_ID | TX_TOFR_ASC |
GML.TX_TLOC_ASC does not reference any database object
GML.TX_TLOC_ASC is referenced by following:
| Description: | Tax Location Codes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| TX_TLOC_CDS.TEXT_CODE | TX_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| IC_WHSE_MST.TAXLOC_CODE | TX_TLOC_CDS |
| OP_CUST_MST_OPM.TAXLOC_CODE | TX_TLOC_CDS |
| OP_CUST_MST.TAXLOC_CODE | TX_TLOC_CDS |
| SY_ORGN_MST_B.TAXLOC_CODE | TX_TLOC_CDS |
| SY_ORGN_MST.TAXLOC_CODE | TX_TLOC_CDS |
| TX_TOFR_ASC.TAXLOC_FROM | TX_TLOC_CDS |
| TX_TOFR_ASC.TAXLOC_TO | TX_TLOC_CDS |
GML.TX_TLOC_CDS does not reference any database object
GML.TX_TLOC_CDS is referenced by following:
| Description: | Pairing of Tax Locations as Ship-From and Ship-To Locations. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| TX_TOFR_ASC.TAXLOC_FROM | TX_TLOC_CDS |
| TX_TOFR_ASC.TEXT_CODE | TX_TEXT_HDR |
| TX_TOFR_ASC.TAXLOC_TO | TX_TLOC_CDS |
| Foreign Key Column | Foreign Table |
|---|---|
| TX_TLOC_ASC.TAXLOC_ID | TX_TOFR_ASC |
GML.TX_TOFR_ASC does not reference any database object
GML.TX_TOFR_ASC is referenced by following:
| Description: | Tax Exemption Reason Codes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| TX_TXRE_CDS.TEXT_CODE | TX_TEXT_HDR |
GML.TX_TXRE_CDS does not reference any database object
GML.TX_TXRE_CDS is referenced by following:
| Description: | Tax reporting classes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| TX_TXRP_CLS.TEXT_CODE | TX_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| TX_TAXA_MST.TAXRPT_CLASS | TX_TXRP_CLS |
GML.TX_TXRP_CLS does not reference any database object
GML.TX_TXRP_CLS is referenced by following:
APPS.CPG_CP_BLAN_PO_HDR_MCH_V is not referenced by any database object
APPS.CPG_CP_BLAN_PO_LINE_MCH_V is not referenced by any database object
APPS.CPG_CP_PO_HDR_MCH_V is not referenced by any database object
APPS.CPG_CP_PO_LINE_MCH_V is not referenced by any database object
APPS.GML_BATCH_SO_RESERVATIONS_V1 is not referenced by any database object
APPS.GML_GASNO_DETAILS_V is not referenced by any database object
APPS.GML_GASNO_DETAIL_ALLOCATIONS_V is not referenced by any database object
APPS.GML_GASNO_DETAIL_CHARGES_V is not referenced by any database object
APPS.GML_GASNO_DETAIL_TEXT_V is not referenced by any database object
APPS.GML_GASNO_ORDERS_V is not referenced by any database object
APPS.GML_GASNO_ORDER_CHARGES_V is not referenced by any database object
APPS.GML_GASNO_ORDER_TEXT_V is not referenced by any database object
APPS.GML_GASNO_SHIPMENTS_V is not referenced by any database object
APPS.GML_GASNO_SHIPMENT_TEXT_V is not referenced by any database object
APPS.GML_GPOAO_DETAILS_V is not referenced by any database object
APPS.GML_GPOAO_DETAIL_ALLOCATIONS_V is not referenced by any database object
APPS.GML_GPOAO_DETAIL_CHARGES_V is not referenced by any database object
APPS.GML_GPOAO_DETAIL_TEXT_V is not referenced by any database object
APPS.GML_GPOAO_ORDERS_V is not referenced by any database object
APPS.GML_GPOAO_ORDER_CHARGES_V is not referenced by any database object
APPS.GML_GPOAO_ORDER_TEXT_V is not referenced by any database object
APPS.GML_GRP_RCV_ERV is not referenced by any database object
APPS.GML_LN_RCV_ERV is not referenced by any database object
APPS.GML_SO_RESERVATIONS_V is not referenced by any database object
APPS.OF_PO_VEND_ASC_VW is not referenced by any database object
APPS.OP_CNTR_DTL_VL is not referenced by any database object
APPS.OP_CUST_ASC_VW1 is not referenced by any database object
APPS.OP_CUST_MSTI2_VW1 is not referenced by any database object
APPS.OP_CUST_MST_V1 is not referenced by any database object
APPS.OP_GNRC_ITM_VW1 is not referenced by any database object
APPS.OP_GNRC_ITM_VW2 is not referenced by any database object
APPS.OP_ORDR_HDR_VW1 is not referenced by any database object
APPS.OP_PRCE_ITM_VL is not referenced by any database object
APPS.OP_PRSL_TYP_VL is not referenced by any database object
APPS.OP_TRAN_TMP_V is not referenced by any database object
APPS.PO_LOTNOS_V is not referenced by any database object
APPS.PO_SUBLOTNOS_V is not referenced by any database object
APPS.PO_TEXT_TBL_VL is not referenced by any database object
APPS.PO_VEND_MSTI2_VW1 is not referenced by any database object
APPS.PO_VEND_MST_V1 is not referenced by any database object
APPS.TX_TEXT_TBL_VL is not referenced by any database object
|
|
|
| Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |