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: | The Actual Cost Process Error Message Table will provide the user a list of inconsistencies found during the actual cost process. These error messages will be used by the OPM user to evaluate performance and accuracy of the process and if |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_ACER_MSG.ACPROC_ID | CM_ACPR_CTL |
GMF.CM_ACER_MSG does not reference any database object
GMF.CM_ACER_MSG is referenced by following:
| Description: | The Actual Cost Process Control Table will allow the OPM user to communicate with the Actual Cost Process as it is running in the background . Using this table, the user may also review past runs and also if necessary force the process to a |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_ACER_MSG.ACPROC_ID | CM_ACPR_CTL |
| CM_ACST_LED.ACPROC_ID | CM_ACPR_CTL |
| CM_CMPT_DTL.ACPROC_ID | CM_ACPR_CTL |
GMF.CM_ACPR_CTL does not reference any database object
GMF.CM_ACPR_CTL is referenced by following:
| Description: | Actual Costing Ledger Table. The purpose of this table is to serve as a depository of all actual costing transactions. These transactions may originate from Production Batch details (pm_matl_dtl) or POC resource details (pm_oprn_dtl) or Pu |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_ACST_LED.ACPROC_ID | CM_ACPR_CTL |
| CM_ACST_LED.COST_ANALYSIS_CODE | CM_ALYS_MST |
|
CM_ACST_LED.CALENDAR_CODE
CM_ACST_LED.PERIOD_CODE |
CM_CLDR_DTL |
| CM_ACST_LED.CMPNTCOST_ID | CM_CMPT_DTL |
| CM_ACST_LED.COST_CMPNTCLS_ID | CM_CMPT_MST_B |
| CM_ACST_LED.COST_CMPNTCLS_ID | CM_CMPT_MST |
| CM_ACST_LED.COST_MTHD_CODE | CM_MTHD_MST |
| CM_ACST_LED.ITEM_ID | IC_ITEM_MST_B |
| CM_ACST_LED.ITEM_ID | IC_ITEM_MST |
| CM_ACST_LED.WHSE_CODE | IC_WHSE_MST |
GMF.CM_ACST_LED does not reference any database object
GMF.CM_ACST_LED is referenced by following:
| Description: | Shadow table of CM_ACST_LED for EFC migration. Stores the original values of columns of CM_ACST_LED that are to be converted tothe Euro currency as a part of EFC migration. The table consists of the primary key columns of CM_ACST_LED and |
|---|
GMF.CM_ACST_LED_EFC does not reference any database object
GMF.CM_ACST_LED_EFC is referenced by following:
| Description: | The Actual Cost Adjustments Details table - contains the adjustments details required and entered for cost adjustments. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_ADJS_DTL.COST_ANALYSIS_CODE | CM_ALYS_MST |
|
CM_ADJS_DTL.CALENDAR_CODE
CM_ADJS_DTL.PERIOD_CODE |
CM_CLDR_DTL |
| CM_ADJS_DTL.COST_CMPNTCLS_ID | CM_CMPT_MST_B |
| CM_ADJS_DTL.COST_CMPNTCLS_ID | CM_CMPT_MST |
| CM_ADJS_DTL.COST_MTHD_CODE | CM_MTHD_MST |
| CM_ADJS_DTL.REASON_CODE | CM_REAS_CDS |
| CM_ADJS_DTL.TEXT_CODE | CM_TEXT_HDR |
| CM_ADJS_DTL.ITEM_ID | IC_ITEM_MST_B |
| CM_ADJS_DTL.ITEM_ID | IC_ITEM_MST |
| CM_ADJS_DTL.WHSE_CODE | IC_WHSE_MST |
| CM_ADJS_DTL.ADJUST_QTY_UM | SY_UOMS_MST |
GMF.CM_ADJS_DTL does not reference any database object
GMF.CM_ADJS_DTL is referenced by following:
| Description: | Shadow table of CM_ACST_LED for EFC migration. Stores the original values of columns of CM_ACST_LED that are to be converted tothe Euro currency as a part of EFC migration. The table consists of the primary key columns of CM_ACST_LED and |
|---|
GMF.CM_ADJS_DTL_EFC does not reference any database object
GMF.CM_ADJS_DTL_EFC is referenced by following:
| Description: | Cost Allocation Process Control Table - Contains the process information such as Fiscal Year and Period, Costing Calendar and Period. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
CM_ALPR_CTL.CALENDAR_CODE
CM_ALPR_CTL.PERIOD_CODE |
CM_CLDR_DTL |
GMF.CM_ALPR_CTL does not reference any database object
GMF.CM_ALPR_CTL is referenced by following:
| Description: | Cost Analysis Code Master Table. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_ALYS_MST.TEXT_CODE | CM_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| CM_ACST_LED.COST_ANALYSIS_CODE | CM_ALYS_MST |
| CM_ADJS_DTL.COST_ANALYSIS_CODE | CM_ALYS_MST |
| CM_BRDN_DTL.COST_ANALYSIS_CODE | CM_ALYS_MST |
| CM_CMPT_DTL.COST_ANALYSIS_CODE | CM_ALYS_MST |
| CM_CMPT_MTL.MTL_ANALYSIS_CODE | CM_ALYS_MST |
| FM_ACTV_MST.COST_ANALYSIS_CODE | CM_ALYS_MST |
| FM_OPRN_DTL.COST_ANALYSIS_CODE | CM_ALYS_MST |
| GL_ACCT_MAP.COST_ANALYSIS_CODE | CM_ALYS_MST |
| GL_ALOC_BAS.ANALYSIS_CODE | CM_ALYS_MST |
| GL_ITEM_DTL.COST_ANALYSIS_CODE | CM_ALYS_MST |
| GL_PLCY_MST.MTL_ANALYSIS_CODE | CM_ALYS_MST |
| GMD_ACTIVITIES_B.COST_ANALYSIS_CODE | CM_ALYS_MST |
| GMF_BURDEN_ASSOCIATION.SOURCE_ANALYSIS_CODE | CM_ALYS_MST |
| GMF_BURDEN_ASSOCIATION.TARGET_ANALYSIS_CODE | CM_ALYS_MST |
| PM_OPRN_DTL.COST_ANALYSIS_CODE | CM_ALYS_MST |
| PO_COST_MST.ANALYSIS_CODE | CM_ALYS_MST |
GMF.CM_ALYS_MST does not reference any database object
GMF.CM_ALYS_MST is referenced by following:
| Description: | Interface Table that contains the invoice price information brought over from Oracle Financials. The information captured within this table is then downloaded to cm_apcm_mst table which is used by the actual costing engine to determine the |
|---|
GMF.CM_APCM_INT does not reference any database object
GMF.CM_APCM_INT is referenced by following:
| Description: | Invoice Interface master table for Costing - contains the invoice price information brought over from Oracle Financials. Data is first brought over to cm_apcm_int and then after validation written to this table. This information is used |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_APCM_MST.TEXT_CODE | CM_TEXT_HDR |
GMF.CM_APCM_MST does not reference any database object
GMF.CM_APCM_MST is referenced by following:
| Description: | Shadow table of CM_APCM_MST for EFC migration. Stores the original values of columns of CM_APCM_DTL that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of CM_APCM_DTL and |
|---|
GMF.CM_APCM_MST_EFC does not reference any database object
GMF.CM_APCM_MST_EFC is referenced by following:
| Description: | Cost Burden Details - contains the Burden (Overhead) costs applied to an item |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_BRDN_DTL.COST_ANALYSIS_CODE | CM_ALYS_MST |
|
CM_BRDN_DTL.CALENDAR_CODE
CM_BRDN_DTL.PERIOD_CODE |
CM_CLDR_DTL |
| CM_BRDN_DTL.CMPNTCOST_ID | CM_CMPT_DTL |
| CM_BRDN_DTL.COST_CMPNTCLS_ID | CM_CMPT_MST_B |
| CM_BRDN_DTL.COST_CMPNTCLS_ID | CM_CMPT_MST |
| CM_BRDN_DTL.COST_MTHD_CODE | CM_MTHD_MST |
| CM_BRDN_DTL.TEXT_CODE | CM_TEXT_HDR |
| CM_BRDN_DTL.RESOURCES | CR_RSRC_MST_B |
| CM_BRDN_DTL.RESOURCES | CR_RSRC_MST |
| CM_BRDN_DTL.ITEM_ID | IC_ITEM_MST_B |
| CM_BRDN_DTL.ITEM_ID | IC_ITEM_MST |
| CM_BRDN_DTL.WHSE_CODE | IC_WHSE_MST |
| CM_BRDN_DTL.ORGN_CODE | SY_ORGN_MST_B |
| CM_BRDN_DTL.ORGN_CODE | SY_ORGN_MST |
| CM_BRDN_DTL.BURDEN_UM | SY_UOMS_MST |
| CM_BRDN_DTL.ITEM_UM | SY_UOMS_MST |
GMF.CM_BRDN_DTL does not reference any database object
GMF.CM_BRDN_DTL is referenced by following:
| Description: | Obsolete |
|---|
GMF.CM_BTCH_SUM does not reference any database object
GMF.CM_BTCH_SUM is referenced by following:
| Description: | Costing Calendar Details |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_CLDR_DTL.CALENDAR_CODE | CM_CLDR_HDR_B |
| CM_CLDR_DTL.CALENDAR_CODE | CM_CLDR_HDR |
| CM_CLDR_DTL.TEXT_CODE | CM_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
|
CM_ACST_LED.CALENDAR_CODE
CM_ACST_LED.PERIOD_CODE |
CM_CLDR_DTL |
|
CM_ADJS_DTL.CALENDAR_CODE
CM_ADJS_DTL.PERIOD_CODE |
CM_CLDR_DTL |
|
CM_ALPR_CTL.CALENDAR_CODE
CM_ALPR_CTL.PERIOD_CODE |
CM_CLDR_DTL |
|
CM_BRDN_DTL.CALENDAR_CODE
CM_BRDN_DTL.PERIOD_CODE |
CM_CLDR_DTL |
|
CM_CMPT_DTL.CALENDAR_CODE
CM_CMPT_DTL.PERIOD_CODE |
CM_CLDR_DTL |
|
CM_CUPD_CTL.CALENDAR_CODE
CM_CUPD_CTL.PERIOD_CODE |
CM_CLDR_DTL |
|
CM_RLUP_CTL.CALENDAR_CODE
CM_RLUP_CTL.PERIOD_CODE |
CM_CLDR_DTL |
|
CM_RSRC_DTL.CALENDAR_CODE
CM_RSRC_DTL.PERIOD_CODE |
CM_CLDR_DTL |
|
CM_WHSE_EFF.CALENDAR_CODE
CM_WHSE_EFF.PERIOD_CODE |
CM_CLDR_DTL |
|
CM_WHSE_SRC.CALENDAR_CODE
CM_WHSE_SRC.PERIOD_CODE |
CM_CLDR_DTL |
|
GL_ALOC_INP.CALENDAR_CODE
GL_ALOC_INP.PERIOD_CODE |
CM_CLDR_DTL |
|
GL_ITEM_CST.CALENDAR_CODE
GL_ITEM_CST.PERIOD_CODE |
CM_CLDR_DTL |
|
GL_PLCY_MST.CREV_CURR_CALENDAR
GL_PLCY_MST.CREV_CURR_PERIOD |
CM_CLDR_DTL |
|
GL_PLCY_MST.CREV_PRIOR_CALENDAR
GL_PLCY_MST.CREV_PRIOR_PERIOD |
CM_CLDR_DTL |
|
GMF_BURDEN_PERCENTAGES.CALENDAR_CODE
GMF_BURDEN_PERCENTAGES.PERIOD_CODE |
CM_CLDR_DTL |
GMF.CM_CLDR_DTL does not reference any database object
GMF.CM_CLDR_DTL is referenced by following:
| Description: | Costing Calendar Header Table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_CLDR_HDR_B.COST_MTHD_CODE | CM_MTHD_MST |
| CM_CLDR_HDR_B.TEXT_CODE | CM_TEXT_HDR |
| CM_CLDR_HDR_B.CO_CODE | SY_ORGN_MST_B |
| Foreign Key Column | Foreign Table |
|---|---|
| CM_CLDR_DTL.CALENDAR_CODE | CM_CLDR_HDR_B |
GMF.CM_CLDR_HDR_B does not reference any database object
GMF.CM_CLDR_HDR_B is referenced by following:
| Description: | Table to store translated columns of Cost Calendar Header Table |
|---|
GMF.CM_CLDR_HDR_TL does not reference any database object
GMF.CM_CLDR_HDR_TL is referenced by following:
| Description: | Cost Component Details |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_CMPT_DTL.ACPROC_ID | CM_ACPR_CTL |
| CM_CMPT_DTL.COST_ANALYSIS_CODE | CM_ALYS_MST |
|
CM_CMPT_DTL.CALENDAR_CODE
CM_CMPT_DTL.PERIOD_CODE |
CM_CLDR_DTL |
| CM_CMPT_DTL.COST_CMPNTCLS_ID | CM_CMPT_MST_B |
| CM_CMPT_DTL.COST_CMPNTCLS_ID | CM_CMPT_MST |
| CM_CMPT_DTL.COST_MTHD_CODE | CM_MTHD_MST |
| CM_CMPT_DTL.ROLLUP_REF_NO | CM_RLUP_CTL |
| CM_CMPT_DTL.TEXT_CODE | CM_TEXT_HDR |
| CM_CMPT_DTL.FMEFF_ID | FM_FORM_EFF |
| CM_CMPT_DTL.ITEM_ID | IC_ITEM_MST_B |
| CM_CMPT_DTL.ITEM_ID | IC_ITEM_MST |
| CM_CMPT_DTL.WHSE_CODE | IC_WHSE_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| CM_ACST_LED.CMPNTCOST_ID | CM_CMPT_DTL |
| CM_BRDN_DTL.CMPNTCOST_ID | CM_CMPT_DTL |
| CM_SCST_LED.CMPNTCOST_ID | CM_CMPT_DTL |
GMF.CM_CMPT_DTL does not reference any database object
GMF.CM_CMPT_DTL is referenced by following:
| Description: | Shadow table of CM_CMPT_DTL for EFC migration. Stores the original values of columns of CM_CMPT_DTL that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of CM_CMPT_DTL and |
|---|
GMF.CM_CMPT_DTL_EFC does not reference any database object
GMF.CM_CMPT_DTL_EFC is referenced by following:
| Description: | Cost component Groups |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_CMPT_GRP.TEXT_CODE | CM_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| CM_CMPT_MST_B.CMPNT_GROUP | CM_CMPT_GRP |
| CM_CMPT_MST.CMPNT_GROUP | CM_CMPT_GRP |
GMF.CM_CMPT_GRP does not reference any database object
GMF.CM_CMPT_GRP is referenced by following:
| Description: | Cost Component Master |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_CMPT_MST_B.CMPNT_GROUP | CM_CMPT_GRP |
| CM_CMPT_MST_B.TEXT_CODE | CM_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| CM_ACST_LED.COST_CMPNTCLS_ID | CM_CMPT_MST_B |
| CM_ADJS_DTL.COST_CMPNTCLS_ID | CM_CMPT_MST_B |
| CM_BRDN_DTL.COST_CMPNTCLS_ID | CM_CMPT_MST_B |
| CM_CMPT_DTL.COST_CMPNTCLS_ID | CM_CMPT_MST_B |
| CM_CMPT_MTL.MTL_CMPNTCLS_ID | CM_CMPT_MST_B |
| CR_RSRC_MST_B.COST_CMPNTCLS_ID | CM_CMPT_MST_B |
| GL_ACCT_MAP.COST_CMPNTCLS_ID | CM_CMPT_MST_B |
| GL_ALOC_BAS.CMPNTCLS_ID | CM_CMPT_MST_B |
| GL_ITEM_DTL.COST_CMPNTCLS_ID | CM_CMPT_MST_B |
| GL_PLCY_MST.MTL_CMPNTCLS_ID | CM_CMPT_MST_B |
| GMF_BURDEN_ASSOCIATION.SOURCE_CMPNTCLS_ID | CM_CMPT_MST_B |
| GMF_BURDEN_ASSOCIATION.TARGET_CMPNTCLS_ID | CM_CMPT_MST_B |
| PO_COST_MST.CMPNTCLS_ID | CM_CMPT_MST_B |
GMF.CM_CMPT_MST_B does not reference any database object
GMF.CM_CMPT_MST_B is referenced by following:
| Description: | Table to store translated columns for Cost Component Master Table |
|---|
GMF.CM_CMPT_MST_TL does not reference any database object
GMF.CM_CMPT_MST_TL is referenced by following:
| Description: | This table contains the item or item cost class specific material cost component and material analysis code. Used by the Actual Cost Process. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_CMPT_MTL.MTL_ANALYSIS_CODE | CM_ALYS_MST |
| CM_CMPT_MTL.MTL_CMPNTCLS_ID | CM_CMPT_MST_B |
| CM_CMPT_MTL.MTL_CMPNTCLS_ID | CM_CMPT_MST |
| CM_CMPT_MTL.TEXT_CODE | CM_TEXT_HDR |
| CM_CMPT_MTL.ITEMCOST_CLASS | IC_COST_CLS |
| CM_CMPT_MTL.ITEM_ID | IC_ITEM_MST_B |
| CM_CMPT_MTL.ITEM_ID | IC_ITEM_MST |
| CM_CMPT_MTL.CO_CODE | SY_ORGN_MST_B |
| CM_CMPT_MTL.CO_CODE | SY_ORGN_MST |
GMF.CM_CMPT_MTL does not reference any database object
GMF.CM_CMPT_MTL is referenced by following:
| Description: | Cost Update Process Control Table - allows the OPM user to communicate with the Cost Update Process as it is running in the background . Using this table, the user may also review past runs and also if necessary force the process to abort. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
CM_CUPD_CTL.CALENDAR_CODE
CM_CUPD_CTL.PERIOD_CODE |
CM_CLDR_DTL |
| CM_CUPD_CTL.COST_MTHD_CODE | CM_MTHD_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| CM_CUPD_MSG.CUPROC_ID | CM_CUPD_CTL |
GMF.CM_CUPD_CTL does not reference any database object
GMF.CM_CUPD_CTL is referenced by following:
| Description: | Cost Update process error messages table - error messages found during the process. No duplicate error messages are written. These error messages will be used by the OPM user to evaluate performance and accuracy of the process and, if nec |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_CUPD_MSG.CUPROC_ID | CM_CUPD_CTL |
GMF.CM_CUPD_MSG does not reference any database object
GMF.CM_CUPD_MSG is referenced by following:
| Description: | Item Cost Methods - Cost methods are defined by the user. Cost calculation types for raw material and product costs are also specified for Actual Costing Methods. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_MTHD_MST.TEXT_CODE | CM_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| CM_ACST_LED.COST_MTHD_CODE | CM_MTHD_MST |
| CM_ADJS_DTL.COST_MTHD_CODE | CM_MTHD_MST |
| CM_BRDN_DTL.COST_MTHD_CODE | CM_MTHD_MST |
| CM_CLDR_HDR_B.COST_MTHD_CODE | CM_MTHD_MST |
| CM_CLDR_HDR.COST_MTHD_CODE | CM_MTHD_MST |
| CM_CMPT_DTL.COST_MTHD_CODE | CM_MTHD_MST |
| CM_CUPD_CTL.COST_MTHD_CODE | CM_MTHD_MST |
| CM_RLUP_CTL.COST_MTHD_CODE | CM_MTHD_MST |
| CM_RSRC_DTL.COST_MTHD_CODE | CM_MTHD_MST |
| GL_ITEM_CST.COST_MTHD_CODE | CM_MTHD_MST |
| GL_PLCY_MST.CREV_CURR_MTHD | CM_MTHD_MST |
| GL_PLCY_MST.CREV_PRIOR_MTHD | CM_MTHD_MST |
| GMF_BURDEN_PERCENTAGES.COST_MTHD_CODE | CM_MTHD_MST |
GMF.CM_MTHD_MST does not reference any database object
GMF.CM_MTHD_MST is referenced by following:
| Description: | Obsolete |
|---|
GMF.CM_OPRN_SUM does not reference any database object
GMF.CM_OPRN_SUM is referenced by following:
| Description: | Cost Adjustments Reason Codes - Reason Codes will allow the user to define specific codes to record the reason for making the adjustment. These codes will be user defined. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_REAS_CDS.TEXT_CODE | CM_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| CM_ADJS_DTL.REASON_CODE | CM_REAS_CDS |
GMF.CM_REAS_CDS does not reference any database object
GMF.CM_REAS_CDS is referenced by following:
| Description: | Cost Rollup Process Control Table - allows the OPM user to communicate with the Cost Rollup Process as it is running in the background . Using this table, the user may also review past runs and also if necessary force the process to abort. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
CM_RLUP_CTL.CALENDAR_CODE
CM_RLUP_CTL.PERIOD_CODE |
CM_CLDR_DTL |
| CM_RLUP_CTL.COST_MTHD_CODE | CM_MTHD_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| CM_CMPT_DTL.ROLLUP_REF_NO | CM_RLUP_CTL |
| CM_RLUP_ITM.ROLLUP_ID | CM_RLUP_CTL |
| CM_RLUP_MSG.ROLLUP_ID | CM_RLUP_CTL |
GMF.CM_RLUP_CTL does not reference any database object
GMF.CM_RLUP_CTL is referenced by following:
| Description: | Contains the list of items for which Cost Rollup is to be run. Will have rows only for those rollup runs that are submitted as List of Items Rollup.Regarding removal of delete_mark column between 4.1 and 11.0 releases. - OPM only selects o |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_RLUP_ITM.ROLLUP_ID | CM_RLUP_CTL |
GMF.CM_RLUP_ITM does not reference any database object
GMF.CM_RLUP_ITM is referenced by following:
| Description: | The Cost Rollup Process Error Message Table will provide the user a list of inconsistencies found during the process. These error messages will be used by the OPM user to evaluate performance and accuracy of the process and, if necessary, t |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_RLUP_MSG.ROLLUP_ID | CM_RLUP_CTL |
GMF.CM_RLUP_MSG does not reference any database object
GMF.CM_RLUP_MSG is referenced by following:
| Description: | Resource Costs |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
CM_RSRC_DTL.CALENDAR_CODE
CM_RSRC_DTL.PERIOD_CODE |
CM_CLDR_DTL |
| CM_RSRC_DTL.COST_MTHD_CODE | CM_MTHD_MST |
| CM_RSRC_DTL.TEXT_CODE | CM_TEXT_HDR |
| CM_RSRC_DTL.RESOURCES | CR_RSRC_MST_B |
| CM_RSRC_DTL.RESOURCES | CR_RSRC_MST |
| CM_RSRC_DTL.ORGN_CODE | SY_ORGN_MST_B |
| CM_RSRC_DTL.ORGN_CODE | SY_ORGN_MST |
| CM_RSRC_DTL.USAGE_UM | SY_UOMS_MST |
GMF.CM_RSRC_DTL does not reference any database object
GMF.CM_RSRC_DTL is referenced by following:
| Description: | Shadow table of CM_RSRC_DTL for EFC migration. Stores the original values of columns of CM_RSRC_DTL that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of CM_RSRC_DTL and |
|---|
GMF.CM_RSRC_DTL_EFC does not reference any database object
GMF.CM_RSRC_DTL_EFC is referenced by following:
| Description: | Standard Costs Ledger. Rows are created during the cost rollup process. It serves the purpose of a ledger on the performed cost calculations of each product. Formula and routing information is maintained within this table. Has a detailed |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_SCST_LED.CMPNTCOST_ID | CM_CMPT_DTL |
| CM_SCST_LED.RESOURCES | CR_RSRC_MST_B |
| CM_SCST_LED.RESOURCES | CR_RSRC_MST |
| CM_SCST_LED.ITEM_ID | IC_ITEM_MST_B |
| CM_SCST_LED.ITEM_ID | IC_ITEM_MST |
| CM_SCST_LED.WHSE_CODE | IC_WHSE_MST |
| CM_SCST_LED.FORM_PROD_UM | SY_UOMS_MST |
| CM_SCST_LED.ITEM_FMQTY_UM | SY_UOMS_MST |
| CM_SCST_LED.USAGE_UM | SY_UOMS_MST |
GMF.CM_SCST_LED does not reference any database object
GMF.CM_SCST_LED is referenced by following:
| Description: | Shadow table of CM_SCST_DTL for EFC migration. Stores the original values of columns of CM_SCST_DTL that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of CM_SCST_DTL and |
|---|
GMF.CM_SCST_LED_EFC does not reference any database object
GMF.CM_SCST_LED_EFC is referenced by following:
| Description: | Header information for Text entered through Edit Text option |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_ADJS_DTL.TEXT_CODE | CM_TEXT_HDR |
| CM_ALYS_MST.TEXT_CODE | CM_TEXT_HDR |
| CM_APCM_MST.TEXT_CODE | CM_TEXT_HDR |
| CM_BRDN_DTL.TEXT_CODE | CM_TEXT_HDR |
| CM_CLDR_DTL.TEXT_CODE | CM_TEXT_HDR |
| CM_CLDR_HDR_B.TEXT_CODE | CM_TEXT_HDR |
| CM_CLDR_HDR.TEXT_CODE | CM_TEXT_HDR |
| CM_CMPT_DTL.TEXT_CODE | CM_TEXT_HDR |
| CM_CMPT_GRP.TEXT_CODE | CM_TEXT_HDR |
| CM_CMPT_MST_B.TEXT_CODE | CM_TEXT_HDR |
| CM_CMPT_MST.TEXT_CODE | CM_TEXT_HDR |
| CM_CMPT_MTL.TEXT_CODE | CM_TEXT_HDR |
| CM_MTHD_MST.TEXT_CODE | CM_TEXT_HDR |
| CM_REAS_CDS.TEXT_CODE | CM_TEXT_HDR |
| CM_RSRC_DTL.TEXT_CODE | CM_TEXT_HDR |
| CM_WHSE_ASC.TEXT_CODE | CM_TEXT_HDR |
| CM_WHSE_EFF.TEXT_CODE | CM_TEXT_HDR |
| CM_WHSE_SRC.TEXT_CODE | CM_TEXT_HDR |
| GL_ALOC_BAS.TEXT_CODE | CM_TEXT_HDR |
GMF.CM_TEXT_HDR does not reference any database object
GMF.CM_TEXT_HDR is referenced by following:
| Description: | Costing Translation Text Table. |
|---|
GMF.CM_TEXT_TBL_TL does not reference any database object
GMF.CM_TEXT_TBL_TL is referenced by following:
| Description: | The Costing Warehouse Association Table - allows the OPM user to build an association between costing and inventory warehouses. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| CM_WHSE_ASC.TEXT_CODE | CM_TEXT_HDR |
| CM_WHSE_ASC.COST_WHSE_CODE | IC_WHSE_MST |
| CM_WHSE_ASC.WHSE_CODE | IC_WHSE_MST |
GMF.CM_WHSE_ASC does not reference any database object
GMF.CM_WHSE_ASC is referenced by following:
| Description: | Costing Warehouse Effectivities. Used by Cost Rollup Process |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
CM_WHSE_EFF.CALENDAR_CODE
CM_WHSE_EFF.PERIOD_CODE |
CM_CLDR_DTL |
| CM_WHSE_EFF.TEXT_CODE | CM_TEXT_HDR |
| CM_WHSE_EFF.ITEMCOST_CLASS | IC_COST_CLS |
| CM_WHSE_EFF.ITEM_ID | IC_ITEM_MST_B |
| CM_WHSE_EFF.ITEM_ID | IC_ITEM_MST |
| CM_WHSE_EFF.COSTING_WHSE | IC_WHSE_MST |
| CM_WHSE_EFF.ORGN_CODE | SY_ORGN_MST_B |
| CM_WHSE_EFF.ORGN_CODE | SY_ORGN_MST |
GMF.CM_WHSE_EFF does not reference any database object
GMF.CM_WHSE_EFF is referenced by following:
| Description: | Costing Source Warehouses - Used by Rollup process |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
CM_WHSE_SRC.CALENDAR_CODE
CM_WHSE_SRC.PERIOD_CODE |
CM_CLDR_DTL |
| CM_WHSE_SRC.TEXT_CODE | CM_TEXT_HDR |
| CM_WHSE_SRC.ITEMCOST_CLASS | IC_COST_CLS |
| CM_WHSE_SRC.ITEM_ID | IC_ITEM_MST_B |
| CM_WHSE_SRC.ITEM_ID | IC_ITEM_MST |
| CM_WHSE_SRC.WHSE_CODE | IC_WHSE_MST |
| CM_WHSE_SRC.ORGN_CODE | SY_ORGN_MST_B |
| CM_WHSE_SRC.ORGN_CODE | SY_ORGN_MST |
GMF.CM_WHSE_SRC does not reference any database object
GMF.CM_WHSE_SRC is referenced by following:
| Description: | User-defined Account classes. These classes are used to classify accounts and are used for reporting purposes only. Note that this table is not used under Oracle Financials Integrated setup. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_MST.ACCT_CLASS_CODE | GL_ACCT_CLS |
GMF.GL_ACCT_CLS does not reference any database object
GMF.GL_ACCT_CLS is referenced by following:
| Description: | This table contains the account selection priority for the companies and the account titles. These priorities are used by the GL Mapping program to retrieve the accounts for sub-ledger posting, in the order of account selection priority. In |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_HRC.ACCT_TTL_TYPE | GL_ACCT_TTL |
| GL_ACCT_HRC.CO_CODE | GL_PLCY_MST |
GMF.GL_ACCT_HRC does not reference any database object
GMF.GL_ACCT_HRC is referenced by following:
| Description: | *NOT USED* |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
GL_ACCT_KEY.CO_CODE
GL_ACCT_KEY.ACCT_NO |
GL_ACCT_MST |
|
GL_ACCT_KEY.CO_CODE
GL_ACCT_KEY.ACCTG_UNIT_NO |
GL_ACCU_MST |
| GL_ACCT_KEY.CO_CODE | GL_PLCY_MST |
| GL_ACCT_KEY.TEXT_CODE | GL_TEXT_HDR |
GMF.GL_ACCT_KEY does not reference any database object
GMF.GL_ACCT_KEY is referenced by following:
| Description: | GL Account Mapping information - contains the GL Account Mapping info. The Account mappings are defined for a Company, Account Title and attributes whose priority is >0 in gl_acct_hrc table. Note that these attributes are optional and a NU |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_MAP.COST_ANALYSIS_CODE | CM_ALYS_MST |
| GL_ACCT_MAP.COST_CMPNTCLS_ID | CM_CMPT_MST_B |
| GL_ACCT_MAP.COST_CMPNTCLS_ID | CM_CMPT_MST |
| GL_ACCT_MAP.RESOURCES | CR_RSRC_MST_B |
| GL_ACCT_MAP.RESOURCES | CR_RSRC_MST |
| GL_ACCT_MAP.ROUTING_ID | FM_ROUT_HDR |
| GL_ACCT_MAP.ACCT_ID | GL_ACCT_MST |
| GL_ACCT_MAP.ACCT_TTL_TYPE | GL_ACCT_TTL |
| GL_ACCT_MAP.CURRENCY_CODE | GL_CURR_MST |
| GL_ACCT_MAP.CO_CODE | GL_PLCY_MST |
| GL_ACCT_MAP.ROUTING_ID | GMD_ROUTINGS_B |
| GL_ACCT_MAP.ICGL_CLASS | IC_GLED_CLS |
| GL_ACCT_MAP.ITEM_ID | IC_ITEM_MST_B |
| GL_ACCT_MAP.ITEM_ID | IC_ITEM_MST |
| GL_ACCT_MAP.WHSE_CODE | IC_WHSE_MST |
| GL_ACCT_MAP.CUSTGL_CLASS | OP_CGLD_CLS |
| GL_ACCT_MAP.CHARGE_ID | OP_CHRG_MST |
| GL_ACCT_MAP.CUST_ID | OP_CUST_MST |
| GL_ACCT_MAP.AQUI_COST_ID | PO_COST_MST |
| GL_ACCT_MAP.VENDOR_ID | PO_VEND_MST |
| GL_ACCT_MAP.VENDGL_CLASS | PO_VGLD_CLS |
| GL_ACCT_MAP.ORGN_CODE | SY_ORGN_MST_B |
| GL_ACCT_MAP.ORGN_CODE | SY_ORGN_MST |
| GL_ACCT_MAP.REASON_CODE | SY_REAS_CDS_B |
| GL_ACCT_MAP.REASON_CODE | SY_REAS_CDS |
| GL_ACCT_MAP.TAXAUTH_ID | TX_TAXA_MST |
GMF.GL_ACCT_MAP does not reference any database object
GMF.GL_ACCT_MAP is referenced by following:
| Description: | Contains the Company specific Chart of Accounts. Note that in the Oracle Financials integrated setup this table is populated with Oracle Financials Accounts while entering the Account Mapping information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_MST.ACCT_CLASS_CODE | GL_ACCT_CLS |
| GL_ACCT_MST.ACCT_TYPE_CODE | GL_ACCT_TYP |
| GL_ACCT_MST.ACCT_USAGE_CODE | GL_ACCT_USG |
| GL_ACCT_MST.CO_CODE | GL_PLCY_MST |
| GL_ACCT_MST.TEXT_CODE | GL_TEXT_HDR |
| GL_ACCT_MST.QUANTITY_UM | SY_UOMS_MST |
| Foreign Key Column | Foreign Table |
|---|---|
|
GL_ACCT_KEY.CO_CODE
GL_ACCT_KEY.ACCT_NO |
GL_ACCT_MST |
| GL_ACCT_MAP.ACCT_ID | GL_ACCT_MST |
|
GL_ACCT_VAL.CO_CODE
GL_ACCT_VAL.ACCT_NO |
GL_ACCT_MST |
| GL_SUBR_LED.ACCT_ID | GL_ACCT_MST |
| GL_SUBR_TST.ACCT_ID | GL_ACCT_MST |
| PO_DIST_DTL.ACCT_ID | GL_ACCT_MST |
GMF.GL_ACCT_MST does not reference any database object
GMF.GL_ACCT_MST is referenced by following:
| Description: | This table contains the system defined Account Titles. User is not allowed to change them in OPM. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_HRC.ACCT_TTL_TYPE | GL_ACCT_TTL |
| GL_ACCT_MAP.ACCT_TTL_TYPE | GL_ACCT_TTL |
| GL_SETU_ERR.ACCT_TTL_TYPE | GL_ACCT_TTL |
| GL_SEVT_TTL.ACCT_TTL_TYPE | GL_ACCT_TTL |
| GL_SUBR_LED.ACCT_TTL_TYPE | GL_ACCT_TTL |
| PO_DIST_DTL.ACCT_TTL_TYPE | GL_ACCT_TTL |
GMF.GL_ACCT_TTL does not reference any database object
GMF.GL_ACCT_TTL is referenced by following:
| Description: | This table consists of four pre-defined General Ledger account types which are used to classify accounts into four broad categories. This table is not used with Oracle Financials integrated setup. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_TYP.TEXT_CODE | GL_TEXT_HDR |
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_MST.ACCT_TYPE_CODE | GL_ACCT_TYP |
GMF.GL_ACCT_TYP does not reference any database object
GMF.GL_ACCT_TYP is referenced by following:
| Description: | This table contains the user-defined Acount Usages. These codes are used for reporting purposes only. This table is not used with Oracle Financials integrated setup. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_MST.ACCT_USAGE_CODE | GL_ACCT_USG |
GMF.GL_ACCT_USG does not reference any database object
GMF.GL_ACCT_USG is referenced by following:
| Description: | This table contains validation codes assignment to Accounts. The Accounts may only be auto-generated with the Accounting unit with same Validation codes. This table is not used with Oracle Financials integrated setup. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
GL_ACCT_VAL.CO_CODE
GL_ACCT_VAL.ACCT_NO |
GL_ACCT_MST |
| GL_ACCT_VAL.TEXT_CODE | GL_TEXT_HDR |
| GL_ACCT_VAL.VALIDATION_CODE | GL_VALN_CDS |
GMF.GL_ACCT_VAL does not reference any database object
GMF.GL_ACCT_VAL is referenced by following:
| Description: | This table contains the GL Account Unit Mapping information. The Account Unit mapping are defined for a Company, Organization and Warehouse. Organization and Warehouse are optional and a blank value means all value. The GL Mapping program |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCU_MAP.ACCTG_UNIT_ID | GL_ACCU_MST |
| GL_ACCU_MAP.CO_CODE | GL_PLCY_MST |
| GL_ACCU_MAP.WHSE_CODE | IC_WHSE_MST |
| GL_ACCU_MAP.ORGN_CODE | SY_ORGN_MST_B |
| GL_ACCU_MAP.ORGN_CODE | SY_ORGN_MST |
GMF.GL_ACCU_MAP does not reference any database object
GMF.GL_ACCU_MAP is referenced by following:
| Description: | This table contains the User-defined Accounting Units. Accounting units are Organizational units of a company such as cost centers, departments, and divisions, to be included in an Account key. Note that with Oracle Financial integration, |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCU_MST.CO_CODE | GL_PLCY_MST |
| Foreign Key Column | Foreign Table |
|---|---|
|
GL_ACCT_KEY.CO_CODE
GL_ACCT_KEY.ACCTG_UNIT_NO |
GL_ACCU_MST |
| GL_ACCU_MAP.ACCTG_UNIT_ID | GL_ACCU_MST |
|
GL_ACCU_VAL.CO_CODE
GL_ACCU_VAL.ACCTG_UNIT_NO |
GL_ACCU_MST |
| GL_SUBR_LED.ACCTG_UNIT_ID | GL_ACCU_MST |
| GL_SUBR_TST.ACCTG_UNIT_ID | GL_ACCU_MST |
| PO_DIST_DTL.ACCTG_UNIT_ID | GL_ACCU_MST |
GMF.GL_ACCU_MST does not reference any database object
GMF.GL_ACCU_MST is referenced by following:
| Description: | This table contains validation codes assignment to Account Units. The Accounting unit may only be auto-generated with the Accounts with same Validation codes. This table is not used with Oracle Financials integrated setup. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
GL_ACCU_VAL.CO_CODE
GL_ACCU_VAL.ACCTG_UNIT_NO |
GL_ACCU_MST |
| GL_ACCU_VAL.VALIDATION_CODE | GL_VALN_CDS |
GMF.GL_ACCU_VAL does not reference any database object
GMF.GL_ACCU_VAL is referenced by following:
| Description: | This table contains the basis information for an allocation code about the items to which expenses will be allocated, the allocation criteria based upon the basis account or fixed percent, and the cost component class bucket to which the al |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ALOC_BAS.ANALYSIS_CODE | CM_ALYS_MST |
| GL_ALOC_BAS.CMPNTCLS_ID | CM_CMPT_MST_B |
| GL_ALOC_BAS.CMPNTCLS_ID | CM_CMPT_MST |
| GL_ALOC_BAS.TEXT_CODE | CM_TEXT_HDR |
| GL_ALOC_BAS.ALLOC_ID | GL_ALOC_MST |
| GL_ALOC_BAS.ITEM_ID | IC_ITEM_MST_B |
| GL_ALOC_BAS.ITEM_ID | IC_ITEM_MST |
| GL_ALOC_BAS.WHSE_CODE | IC_WHSE_MST |
GMF.GL_ALOC_BAS does not reference any database object
GMF.GL_ALOC_BAS is referenced by following:
| Description: | This table contains the result of the allocation processing. The Actual Costing Process will use this table to determine the expense allocation for the items. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ALOC_DTL.ALLOC_ID | GL_ALOC_MST |
GMF.GL_ALOC_DTL does not reference any database object
GMF.GL_ALOC_DTL is referenced by following:
| Description: | Shadow table of GL_ALOC_DTL for EFC migration. Stores the original values of columns of GL_ALOC_DTL that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of GL_ALOC_DTL and |
|---|
GMF.GL_ALOC_DTL_EFC does not reference any database object
GMF.GL_ALOC_DTL_EFC is referenced by following:
| Description: | This table contains the expense to allocate information for an allocation code. The data from this table is used for GL expense allocation processing in determining total expense to allocate. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ALOC_EXP.ALLOC_ID | GL_ALOC_MST |
GMF.GL_ALOC_EXP does not reference any database object
GMF.GL_ALOC_EXP is referenced by following:
| Description: | This table contains the expense and basis amount computed during the allocation processing. Currently these values are being brought over from Oracle Financials and the user has the option to maintain them via a maintenance screen. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
GL_ALOC_INP.CALENDAR_CODE
GL_ALOC_INP.PERIOD_CODE |
CM_CLDR_DTL |
GMF.GL_ALOC_INP does not reference any database object
GMF.GL_ALOC_INP is referenced by following:
| Description: | Shadow table of GL_ALOC_INP for EFC migration. Stores the original values of columns of GL_ALOC_INP that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of GL_ALOC_INP an |
|---|
GMF.GL_ALOC_INP_EFC does not reference any database object
GMF.GL_ALOC_INP_EFC is referenced by following:
| Description: | Master table to store the definition of the allocation codes. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ALOC_BAS.ALLOC_ID | GL_ALOC_MST |
| GL_ALOC_DTL.ALLOC_ID | GL_ALOC_MST |
| GL_ALOC_EXP.ALLOC_ID | GL_ALOC_MST |
GMF.GL_ALOC_MST does not reference any database object
GMF.GL_ALOC_MST is referenced by following:
| Description: | This table contains the period defination for Fiscal year. This table is not used with Oracle Financials integrated setup. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
GL_CLDR_DTL.CO_CODE
GL_CLDR_DTL.FISCAL_YEAR |
GL_CLDR_HDR |
GMF.GL_CLDR_DTL does not reference any database object
GMF.GL_CLDR_DTL is referenced by following:
| Description: | This table contains the Fiscal Year defination for a Company. This table is not used with Oracle Financials integrated setup. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
GL_CLDR_DTL.CO_CODE
GL_CLDR_DTL.FISCAL_YEAR |
GL_CLDR_HDR |
GMF.GL_CLDR_HDR does not reference any database object
GMF.GL_CLDR_HDR is referenced by following:
| Description: | This table contains the Currency definitions. Note that with Oracle Financials integration this table is populated with the Currency data from Oracle Financials. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_MAP.CURRENCY_CODE | GL_CURR_MST |
| GL_PLCY_MST.BASE_CURRENCY_CODE | GL_CURR_MST |
| GL_SUBR_LED.CURRENCY_BASE | GL_CURR_MST |
| GL_SUBR_LED.CURRENCY_TRANS | GL_CURR_MST |
| GL_SUBR_TST.CURRENCY_BASE | GL_CURR_MST |
| GL_SUBR_TST.CURRENCY_TRANS | GL_CURR_MST |
| OP_BILL_LAD.DEMURRAGE_CURRENCY | GL_CURR_MST |
| OP_CHRG_MST.CURRENCY_CODE | GL_CURR_MST |
| OP_CNTR_HDR.CONTRACT_CURRENCY | GL_CURR_MST |
| OP_CNTR_HDR.BASE_CURRENCY | GL_CURR_MST |
| OP_CUST_MST.CUST_CURRENCY | GL_CURR_MST |
| OP_CUST_MST_OPM.CUST_CURRENCY | GL_CURR_MST |
| OP_ORDR_DTL.BILLING_CURRENCY | GL_CURR_MST |
| OP_ORDR_DTL.BASE_CURRENCY | GL_CURR_MST |
| OP_ORDR_HDR.BILLING_CURRENCY | GL_CURR_MST |
| OP_PRCE_MST.CURRENCY_CODE | GL_CURR_MST |
| OP_PRSL_DTL.BILLING_CURRENCY | GL_CURR_MST |
| OP_PRSL_HDR.BILLING_CURRENCY | GL_CURR_MST |
| PO_BPOS_HDR.CONTRACT_CURRENCY | GL_CURR_MST |
| PO_DIST_DTL.CURRENCY_TRANS | GL_CURR_MST |
| PO_DIST_DTL.CURRENCY_BASE | GL_CURR_MST |
| PO_ORDR_HDR.BILLING_CURRENCY | GL_CURR_MST |
| PO_RECV_HDR.DEMURRAGE_CURRENCY | GL_CURR_MST |
| PO_RECV_HDR.BILLING_CURRENCY | GL_CURR_MST |
| PO_VEND_MST.DEFAULT_CURRENCY | GL_CURR_MST |
GMF.GL_CURR_MST does not reference any database object
GMF.GL_CURR_MST is referenced by following:
| Description: | This is an interface table for synchronizing Currencies from Oracle Financials to OPM. |
|---|
GMF.GL_CURR_MST_INT does not reference any database object
GMF.GL_CURR_MST_INT is referenced by following:
| Description: | This table contains the pre-defined Event codes. An event is any activity within OPM that has a financial impact. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_EVNT_MST.TRANS_SOURCE_TYPE | GL_SRCE_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| GL_EVNT_PLC.EVENT_TYPE | GL_EVNT_MST |
| GL_SEVT_MST.EVENT_TYPE | GL_EVNT_MST |
GMF.GL_EVNT_MST does not reference any database object
GMF.GL_EVNT_MST is referenced by following:
| Description: | An internal table used by GL Update process to improve performance |
|---|
GMF.GL_EVNT_MST_TEMP does not reference any database object
GMF.GL_EVNT_MST_TEMP is referenced by following:
| Description: | Event specific Company Fiscal Policy information |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_EVNT_PLC.EVENT_TYPE | GL_EVNT_MST |
| GL_EVNT_PLC.CO_CODE | GL_PLCY_MST |
| GL_EVNT_PLC.TRANS_SOURCE_TYPE | GL_SRCE_MST |
GMF.GL_EVNT_PLC does not reference any database object
GMF.GL_EVNT_PLC is referenced by following:
| Description: | Temporary table used for performance improvment in cost allocation process. This table is populated with values from GL_CODE_COMBINATIONS table. |
|---|
GMF.GL_EXPN_CDS_TMP does not reference any database object
GMF.GL_EXPN_CDS_TMP is referenced by following:
| Description: | Item costs for transactions. Maintains accounting and current costs. Component cost details are available in GL_ITEM_DTL table. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
GL_ITEM_CST.CALENDAR_CODE
GL_ITEM_CST.PERIOD_CODE |
CM_CLDR_DTL |
| GL_ITEM_CST.COST_MTHD_CODE | CM_MTHD_MST |
| GL_ITEM_CST.FMEFF_ID | FM_FORM_EFF |
| GL_ITEM_CST.ITEM_ID | IC_ITEM_MST_B |
| GL_ITEM_CST.ITEM_ID | IC_ITEM_MST |
| GL_ITEM_CST.WHSE_CODE | IC_WHSE_MST |
| GL_ITEM_CST.ORGN_CODE | SY_ORGN_MST_B |
| GL_ITEM_CST.ORGN_CODE | SY_ORGN_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ITEM_DTL.ITEMCOST_ID | GL_ITEM_CST |
GMF.GL_ITEM_CST does not reference any database object
GMF.GL_ITEM_CST is referenced by following:
| Description: | Shadow table of GL_ITEM_CST for EFC migration. Stores the original values of columns of GL_ITEM_CST that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of GL_ITEM_CST and |
|---|
GMF.GL_ITEM_CST_EFC does not reference any database object
GMF.GL_ITEM_CST_EFC is referenced by following:
| Description: | Cost component detail information for the item. Component details for the Accounting cost available in GL_ITEM_CST table. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ITEM_DTL.COST_ANALYSIS_CODE | CM_ALYS_MST |
| GL_ITEM_DTL.COST_CMPNTCLS_ID | CM_CMPT_MST_B |
| GL_ITEM_DTL.COST_CMPNTCLS_ID | CM_CMPT_MST |
| GL_ITEM_DTL.ITEMCOST_ID | GL_ITEM_CST |
GMF.GL_ITEM_DTL does not reference any database object
GMF.GL_ITEM_DTL is referenced by following:
| Description: | Shadow table of GL_ITEM_DTL for EFC migration. Stores the original values of columns of GL_ITEM_DTL that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of GL_ITEM_DTL and |
|---|
GMF.GL_ITEM_DTL_EFC does not reference any database object
GMF.GL_ITEM_DTL_EFC is referenced by following:
| Description: | GL ledgers |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_LEDG_MAP.LEDGER_CODE | GL_LDGR_MST |
| GL_PLCY_LGR.LEDGER_CODE | GL_LDGR_MST |
| GL_PLCY_MST.PRIMARY_LEDGER_CODE | GL_LDGR_MST |
| GL_SUBR_LED.LEDGER_CODE | GL_LDGR_MST |
| GL_SUBR_TST.LEDGER_CODE | GL_LDGR_MST |
| PO_DIST_DTL.LEDGER_CODE | GL_LDGR_MST |
GMF.GL_LDGR_MST does not reference any database object
GMF.GL_LDGR_MST is referenced by following:
| Description: | GL ledger mapping. Used for GL mapping. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_LEDG_MAP.LEDGER_CODE | GL_LDGR_MST |
| GL_LEDG_MAP.CO_CODE | GL_PLCY_MST |
| GL_LEDG_MAP.ORGN_CODE | SY_ORGN_MST_B |
| GL_LEDG_MAP.ORGN_CODE | SY_ORGN_MST |
GMF.GL_LEDG_MAP does not reference any database object
GMF.GL_LEDG_MAP is referenced by following:
| Description: | Internal Table used by AR Update process |
|---|
GMF.GL_MEMO_STA does not reference any database object
GMF.GL_MEMO_STA is referenced by following:
| Description: | General ledger messages table. Messages generated during transaction posting by Subsidiary Ledger Update process. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_MESG_TBL.REFERENCE_NO | GL_SUBR_STA |
GMF.GL_MESG_TBL does not reference any database object
GMF.GL_MESG_TBL is referenced by following:
| Description: | Company ledgers |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_PLCY_LGR.LEDGER_CODE | GL_LDGR_MST |
| GL_PLCY_LGR.CO_CODE | GL_PLCY_MST |
GMF.GL_PLCY_LGR does not reference any database object
GMF.GL_PLCY_LGR is referenced by following:
| Description: | Fiscal policy of a company. Fiscal policy defines the GL attributes of the company. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_PLCY_MST.MTL_ANALYSIS_CODE | CM_ALYS_MST |
|
GL_PLCY_MST.CREV_CURR_CALENDAR
GL_PLCY_MST.CREV_CURR_PERIOD |
CM_CLDR_DTL |
|
GL_PLCY_MST.CREV_PRIOR_CALENDAR
GL_PLCY_MST.CREV_PRIOR_PERIOD |
CM_CLDR_DTL |
| GL_PLCY_MST.MTL_CMPNTCLS_ID | CM_CMPT_MST_B |
| GL_PLCY_MST.MTL_CMPNTCLS_ID | CM_CMPT_MST |
| GL_PLCY_MST.CREV_CURR_MTHD | CM_MTHD_MST |
| GL_PLCY_MST.CREV_PRIOR_MTHD | CM_MTHD_MST |
| GL_PLCY_MST.BASE_CURRENCY_CODE | GL_CURR_MST |
| GL_PLCY_MST.PRIMARY_LEDGER_CODE | GL_LDGR_MST |
| GL_PLCY_MST.TEXT_CODE | GL_TEXT_HDR |
| GL_PLCY_MST.CO_CODE | SY_ORGN_MST_B |
| GL_PLCY_MST.CO_CODE | SY_ORGN_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_HRC.CO_CODE | GL_PLCY_MST |
| GL_ACCT_KEY.CO_CODE | GL_PLCY_MST |
| GL_ACCT_MAP.CO_CODE | GL_PLCY_MST |
| GL_ACCT_MST.CO_CODE | GL_PLCY_MST |
| GL_ACCU_MAP.CO_CODE | GL_PLCY_MST |
| GL_ACCU_MST.CO_CODE | GL_PLCY_MST |
| GL_EVNT_PLC.CO_CODE | GL_PLCY_MST |
| GL_LEDG_MAP.CO_CODE | GL_PLCY_MST |
| GL_PLCY_LGR.CO_CODE | GL_PLCY_MST |
| GL_PLCY_SEG.CO_CODE | GL_PLCY_MST |
| GL_PLCY_SYS.CO_CODE | GL_PLCY_MST |
| GL_SUBR_LED.CO_CODE | GL_PLCY_MST |
| GL_SUBR_TST.CO_CODE | GL_PLCY_MST |
GMF.GL_PLCY_MST does not reference any database object
GMF.GL_PLCY_MST is referenced by following:
| Description: | Shadow table of GL_PLCY_MST for EFC migration. Stores the original values of columns of GL_PLCY_MST that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of GL_PLCY_MST and |
|---|
GMF.GL_PLCY_MST_EFC does not reference any database object
GMF.GL_PLCY_MST_EFC is referenced by following:
| Description: | Segments for account key segregation. Stores the Chart of Accounts. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_PLCY_SEG.CO_CODE | GL_PLCY_MST |
GMF.GL_PLCY_SEG does not reference any database object
GMF.GL_PLCY_SEG is referenced by following:
| Description: | Fiscal policy sub-systems |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_PLCY_SYS.CO_CODE | GL_PLCY_MST |
GMF.GL_PLCY_SYS does not reference any database object
GMF.GL_PLCY_SYS is referenced by following:
| Description: | Exchange rate Classification such as daily, average, bal sheet. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| ZX_REGIMES_B.EXCHANGE_RATE_TYPE | GL_RATE_TYP |
| ZX_TAXES_B.EXCHANGE_RATE_TYPE | GL_RATE_TYP |
GMF.GL_RATE_TYP does not reference any database object
GMF.GL_RATE_TYP is referenced by following:
| Description: | Exchange Rate Type Interface. Used for synchronzing rate types from Oracle Financials. |
|---|
GMF.GL_RATE_TYP_INT does not reference any database object
GMF.GL_RATE_TYP_INT is referenced by following:
| Description: | GL mapping setup errors found during Subsidiary Ledger Update process. Not currently used. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_SETU_ERR.ACCT_TTL_TYPE | GL_ACCT_TTL |
| GL_SETU_ERR.CO_CODE | SY_ORGN_MST_B |
| GL_SETU_ERR.CO_CODE | SY_ORGN_MST |
GMF.GL_SETU_ERR does not reference any database object
GMF.GL_SETU_ERR is referenced by following:
| Description: | GL mapping subevents. OPM user is not allowed to modify this information. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_SEVT_MST.EVENT_TYPE | GL_EVNT_MST |
| Foreign Key Column | Foreign Table |
|---|---|
| GL_SEVT_TTL.SUB_EVENT_TYPE | GL_SEVT_MST |
| GL_SUBR_LED.SUB_EVENT_TYPE | GL_SEVT_MST |
| PO_RECV_HST.SUB_EVENT_TYPE | GL_SEVT_MST |
GMF.GL_SEVT_MST does not reference any database object
GMF.GL_SEVT_MST is referenced by following:
| Description: | GL mapping subevent account titles. Account titles that are impacted by a subsystem subevent. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_SEVT_TTL.ACCT_TTL_TYPE | GL_ACCT_TTL |
| GL_SEVT_TTL.SUB_EVENT_TYPE | GL_SEVT_MST |
GMF.GL_SEVT_TTL does not reference any database object
GMF.GL_SEVT_TTL is referenced by following:
| Description: | Subsystem master table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_EVNT_MST.TRANS_SOURCE_TYPE | GL_SRCE_MST |
| GL_EVNT_PLC.TRANS_SOURCE_TYPE | GL_SRCE_MST |
| GL_SUBR_LED.TRANS_SOURCE_TYPE | GL_SRCE_MST |
| GL_SUBR_TST.TRANS_SOURCE_TYPE | GL_SRCE_MST |
GMF.GL_SRCE_MST does not reference any database object
GMF.GL_SRCE_MST is referenced by following:
| Description: | GL subsidiary ledger. Liaison between subsystems and GL. Stores all the bookings of OPM subsystem transactions (documents). Updated by the OPM Subsidiary Ledger Update process. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_SUBR_LED.ACCT_ID | GL_ACCT_MST |
| GL_SUBR_LED.ACCT_TTL_TYPE | GL_ACCT_TTL |
| GL_SUBR_LED.ACCTG_UNIT_ID | GL_ACCU_MST |
| GL_SUBR_LED.CURRENCY_BASE | GL_CURR_MST |
| GL_SUBR_LED.CURRENCY_TRANS | GL_CURR_MST |
| GL_SUBR_LED.LEDGER_CODE | GL_LDGR_MST |
| GL_SUBR_LED.CO_CODE | GL_PLCY_MST |
| GL_SUBR_LED.SUB_EVENT_TYPE | GL_SEVT_MST |
| GL_SUBR_LED.TRANS_SOURCE_TYPE | GL_SRCE_MST |
| GL_SUBR_LED.REFERENCE_NO | GL_SUBR_STA |
| GL_SUBR_LED.QUANTITY_UM | SY_UOMS_MST |
GMF.GL_SUBR_LED does not reference any database object
GMF.GL_SUBR_LED is referenced by following:
| Description: | Shadow table of GL_SUBR_LED for EFC migration. Stores the original values of columns of GL_SUBR_LED that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of GL_SUBR_LED and |
|---|
GMF.GL_SUBR_LED_EFC does not reference any database object
GMF.GL_SUBR_LED_EFC is referenced by following:
| Description: | Table for storing all types of batch close variances calculated during actual subledger run. |
|---|
GMF.GL_SUBR_LED_VAR does not reference any database object
GMF.GL_SUBR_LED_VAR is referenced by following:
| Description: | OPM Subsidiary Ledger Update process Control table |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_MESG_TBL.REFERENCE_NO | GL_SUBR_STA |
| GL_SUBR_LED.REFERENCE_NO | GL_SUBR_STA |
| GL_SUBR_TST.GL_SUBR_TST_REFERENCE_NO | GL_SUBR_STA |
GMF.GL_SUBR_STA does not reference any database object
GMF.GL_SUBR_STA is referenced by following:
| Description: | Subsidiary ledger test run work table. Used to run Subledger Update process in test mode to verify the bookings before running a live Update. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_SUBR_TST.ACCT_ID | GL_ACCT_MST |
| GL_SUBR_TST.ACCTG_UNIT_ID | GL_ACCU_MST |
| GL_SUBR_TST.CURRENCY_BASE | GL_CURR_MST |
| GL_SUBR_TST.CURRENCY_TRANS | GL_CURR_MST |
| GL_SUBR_TST.LEDGER_CODE | GL_LDGR_MST |
| GL_SUBR_TST.CO_CODE | GL_PLCY_MST |
| GL_SUBR_TST.TRANS_SOURCE_TYPE | GL_SRCE_MST |
| GL_SUBR_TST.GL_SUBR_TST_REFERENCE_NO | GL_SUBR_STA |
| GL_SUBR_TST.QUANTITY_UM | SY_UOMS_MST |
GMF.GL_SUBR_TST does not reference any database object
GMF.GL_SUBR_TST is referenced by following:
| Description: | Shadow table of GL_SUBR_TST for EFC migration. Stores the original values of columns of GL_SUBR_TST that are to be converted to the Euro currency as a part of EFC migration. The table consists of the primary key columns of GL_SUBR_TST and |
|---|
GMF.GL_SUBR_TST_EFC does not reference any database object
GMF.GL_SUBR_TST_EFC is referenced by following:
| Description: | Table for storing all types of batch close variances calculated during test subledger run. |
|---|
GMF.GL_SUBR_TST_VAR does not reference any database object
GMF.GL_SUBR_TST_VAR is referenced by following:
| Description: | Table used to store text types for GL |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_KEY.TEXT_CODE | GL_TEXT_HDR |
| GL_ACCT_MST.TEXT_CODE | GL_TEXT_HDR |
| GL_ACCT_TYP.TEXT_CODE | GL_TEXT_HDR |
| GL_ACCT_VAL.TEXT_CODE | GL_TEXT_HDR |
| GL_PLCY_MST.TEXT_CODE | GL_TEXT_HDR |
GMF.GL_TEXT_HDR does not reference any database object
GMF.GL_TEXT_HDR is referenced by following:
| Description: | GL Module Text Lines. Descriptive text for all tables in this module. |
|---|
GMF.GL_TEXT_TBL_TL does not reference any database object
GMF.GL_TEXT_TBL_TL is referenced by following:
| Description: | The control table for OPM GL Update Process. Only used with OPM integrated with Oracle Financials. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_UPDT_MSG.GUPROC_ID | GL_UPDT_CTL |
GMF.GL_UPDT_CTL does not reference any database object
GMF.GL_UPDT_CTL is referenced by following:
| Description: | OPM GL Update process error messages table. Only used with OPM integrated with Oracle Financials. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_UPDT_MSG.GUPROC_ID | GL_UPDT_CTL |
GMF.GL_UPDT_MSG does not reference any database object
GMF.GL_UPDT_MSG is referenced by following:
| Description: | Validation codes for account key auto-generation. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GL_ACCT_VAL.VALIDATION_CODE | GL_VALN_CDS |
| GL_ACCU_VAL.VALIDATION_CODE | GL_VALN_CDS |
GMF.GL_VALN_CDS does not reference any database object
GMF.GL_VALN_CDS is referenced by following:
| Description: | Exchange rates |
|---|
GMF.GL_XCHG_RTE does not reference any database object
GMF.GL_XCHG_RTE is referenced by following:
| Description: | Batch Requirements |
|---|
GMF.GMF_BATCH_REQUIREMENTS does not reference any database object
GMF.GMF_BATCH_REQUIREMENTS is referenced by following:
| Description: |
|---|
GMF.GMF_BATCH_REQUIREMENTS_GTMP does not reference any database object
GMF.GMF_BATCH_REQUIREMENTS_GTMP is referenced by following:
| Description: | Batch VIB Details |
|---|
GMF.GMF_BATCH_VIB_DETAILS does not reference any database object
GMF.GMF_BATCH_VIB_DETAILS is referenced by following:
| Description: | In OPM Costing, this table is where the Percentage Burden Associations are stored. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GMF_BURDEN_ASSOCIATION.SOURCE_CMPNTCLS_ID | CM_CMPT_MST_B |
| GMF_BURDEN_ASSOCIATION.SOURCE_ANALYSIS_CODE | CM_ALYS_MST |
| GMF_BURDEN_ASSOCIATION.BURDEN_ID | GMF_BURDEN_CODES |
| GMF_BURDEN_ASSOCIATION.TARGET_CMPNTCLS_ID | CM_CMPT_MST_B |
| GMF_BURDEN_ASSOCIATION.TARGET_ANALYSIS_CODE | CM_ALYS_MST |
GMF.GMF_BURDEN_ASSOCIATION does not reference any database object
GMF.GMF_BURDEN_ASSOCIATION is referenced by following:
| Description: | In OPM Costing, this is where the Percentage Burden Codes are stored. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GMF_BURDEN_ASSOCIATION.BURDEN_ID | GMF_BURDEN_CODES |
| GMF_BURDEN_PERCENTAGES.BURDEN_ID | GMF_BURDEN_CODES |
| GMF_BURDEN_PRIORITIES.BURDEN_ID | GMF_BURDEN_CODES |
GMF.GMF_BURDEN_CODES does not reference any database object
GMF.GMF_BURDEN_CODES is referenced by following:
| Description: | In OPM Costing, this is where the Burden Percentages are established. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
|
GMF_BURDEN_PERCENTAGES.CALENDAR_CODE
GMF_BURDEN_PERCENTAGES.PERIOD_CODE |
CM_CLDR_DTL |
| GMF_BURDEN_PERCENTAGES.COST_MTHD_CODE | CM_MTHD_MST |
| GMF_BURDEN_PERCENTAGES.BURDEN_ID | GMF_BURDEN_CODES |
| GMF_BURDEN_PERCENTAGES.ORGN_CODE | SY_ORGN_MST_B |
| GMF_BURDEN_PERCENTAGES.WHSE_CODE | IC_WHSE_MST |
| GMF_BURDEN_PERCENTAGES.ITEM_ID | IC_ITEM_MST_B |
| GMF_BURDEN_PERCENTAGES.ICGL_CLASS | IC_GLED_CLS |
| GMF_BURDEN_PERCENTAGES.ITEMCOST_CLASS | IC_COST_CLS |
GMF.GMF_BURDEN_PERCENTAGES does not reference any database object
GMF.GMF_BURDEN_PERCENTAGES is referenced by following:
| Description: | In OPM Costing, this is where the Percentage Burden Priorities are established. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GMF_BURDEN_PRIORITIES.CO_CODE | SY_ORGN_MST |
| GMF_BURDEN_PRIORITIES.CO_CODE | SY_ORGN_MST_B |
| GMF_BURDEN_PRIORITIES.BURDEN_ID | GMF_BURDEN_CODES |
GMF.GMF_BURDEN_PRIORITIES does not reference any database object
GMF.GMF_BURDEN_PRIORITIES is referenced by following:
| Description: | Cost Calendar Assignments |
|---|
GMF.GMF_CALENDAR_ASSIGNMENTS does not reference any database object
GMF.GMF_CALENDAR_ASSIGNMENTS is referenced by following:
| Description: | Table of all cost methods that cost items at the summary level |
|---|
GMF.GMF_COST_METHOD_LEVEL does not reference any database object
GMF.GMF_COST_METHOD_LEVEL is referenced by following:
| Description: | Fiscal Policies Table |
|---|
GMF.GMF_FISCAL_POLICIES does not reference any database object
GMF.GMF_FISCAL_POLICIES is referenced by following:
| Description: | Incoming Material Layers |
|---|
GMF.GMF_INCOMING_MATERIAL_LAYERS does not reference any database object
GMF.GMF_INCOMING_MATERIAL_LAYERS is referenced by following:
| Description: | Supplementary table to store invoice variance amounts for Actual Costing |
|---|
GMF.GMF_INVOICE_DISTRIBUTIONS does not reference any database object
GMF.GMF_INVOICE_DISTRIBUTIONS is referenced by following:
| Description: |
|---|
GMF.GMF_INV_TXN_FLAGS_GT does not reference any database object
GMF.GMF_INV_TXN_FLAGS_GT is referenced by following:
| Description: | Stores the grouping of items (representative vs represented) for Summary Level costing |
|---|
GMF.GMF_ITEM_GROUPS does not reference any database object
GMF.GMF_ITEM_GROUPS is referenced by following:
| Description: | Layer Cost Details |
|---|
GMF.GMF_LAYER_COST_DETAILS does not reference any database object
GMF.GMF_LAYER_COST_DETAILS is referenced by following:
| Description: | This table used to store Actual Landed cost adjustments which are processed by actual cost process for actual cost types |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GMF_LC_ACTUAL_COST_ADJS.ADJ_TRANSACTION_ID | % |
GMF.GMF_LC_ACTUAL_COST_ADJS does not reference any database object
GMF.GMF_LC_ACTUAL_COST_ADJS is referenced by following:
| Description: | This table used to store Estimated and Actual Landed Cost adjustments. This table will be populated in Landed cost adjustment import process for each LC adjustment |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GMF_LC_LOT_COST_ADJS.ADJ_TRANSACTION_ID | GMF_LC_ADJ_TRANSACTIONS |
GMF.GMF_LC_ADJ_TRANSACTIONS does not reference any database object
GMF.GMF_LC_ADJ_TRANSACTIONS is referenced by following:
| Description: | This table used to store Actual Landed cost adjustments which are processed by Lot cost process |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| GMF_LC_LOT_COST_ADJS.ADJ_TRANSACTION_ID | GMF_LC_ADJ_TRANSACTIONS |
GMF.GMF_LC_LOT_COST_ADJS does not reference any database object
GMF.GMF_LC_LOT_COST_ADJS is referenced by following:
| Description: | This table contains valuation cost type of the secondary ledgers associated to the primary ledger of the Legal Entity. With SLA it is possible to create the subledger journals in draft mode for multiple cost types for comparison and simulat |
|---|
GMF.GMF_LEDGER_VALUATION_METHODS does not reference any database object
GMF.GMF_LEDGER_VALUATION_METHODS is referenced by following:
| Description: | Lot cost enabled items |
|---|
GMF.GMF_LOT_COSTED_ITEMS does not reference any database object
GMF.GMF_LOT_COSTED_ITEMS is referenced by following:
| Description: | This table stores all items flaged as lot costed |
|---|
GMF.GMF_LOT_COSTED_ITEMS_GT does not reference any database object
GMF.GMF_LOT_COSTED_ITEMS_GT is referenced by following:
| Description: | OPM Lot Costs Header Table |
|---|
GMF.GMF_LOT_COSTS does not reference any database object
GMF.GMF_LOT_COSTS is referenced by following:
| Description: | OPM Lot Cost Adjustments header table |
|---|
GMF.GMF_LOT_COST_ADJUSTMENTS does not reference any database object
GMF.GMF_LOT_COST_ADJUSTMENTS is referenced by following:
| Description: | OPM Lot Cost Adjustments details table |
|---|
GMF.GMF_LOT_COST_ADJUSTMENT_DTLS does not reference any database object
GMF.GMF_LOT_COST_ADJUSTMENT_DTLS is referenced by following:
| Description: | Burden details for lot costed items |
|---|
GMF.GMF_LOT_COST_BURDENS does not reference any database object
GMF.GMF_LOT_COST_BURDENS is referenced by following:
| Description: | Lot Cost details table |
|---|
GMF.GMF_LOT_COST_DETAILS does not reference any database object
GMF.GMF_LOT_COST_DETAILS is referenced by following:
| Description: | Transaction history table for lot costs |
|---|
GMF.GMF_MATERIAL_LOT_COST_TXNS does not reference any database object
GMF.GMF_MATERIAL_LOT_COST_TXNS is referenced by following:
| Description: | Consumption Material Layers |
|---|
GMF.GMF_OUTGOING_MATERIAL_LAYERS does not reference any database object
GMF.GMF_OUTGOING_MATERIAL_LAYERS is referenced by following:
| Description: | Period Inventory Balances for Process Orgs |
|---|
GMF.GMF_PERIOD_BALANCES does not reference any database object
GMF.GMF_PERIOD_BALANCES is referenced by following:
| Description: | Temporary table for Period Inventory Balances for Process Orgs |
|---|
GMF.GMF_PERIOD_BALANCES_GT does not reference any database object
GMF.GMF_PERIOD_BALANCES_GT is referenced by following:
| Description: | Cost Period statuses for a Legal Entity & Cost Type |
|---|
GMF.GMF_PERIOD_STATUSES does not reference any database object
GMF.GMF_PERIOD_STATUSES is referenced by following:
| Description: | Global temporary table gmf_period_statuses_gt with on commit delete rows |
|---|
GMF.GMF_PERIOD_STATUSES_GT does not reference any database object
GMF.GMF_PERIOD_STATUSES_GT is referenced by following:
| Description: | This table stores process organizations for temporary session |
|---|
GMF.GMF_PROCESS_ORGANIZATIONS_GT does not reference any database object
GMF.GMF_PROCESS_ORGANIZATIONS_GT is referenced by following:
| Description: | This table stores information for receiving accounting for process organizations |
|---|
GMF.GMF_RCV_ACCOUNTING_TXNS does not reference any database object
GMF.GMF_RCV_ACCOUNTING_TXNS is referenced by following:
| Description: | Consumption Resource Layers |
|---|
GMF.GMF_RESOURCE_LAYERS does not reference any database object
GMF.GMF_RESOURCE_LAYERS is referenced by following:
| Description: | Transaction Valuation table for process organizations |
|---|
GMF.GMF_TRANSACTION_VALUATION does not reference any database object
GMF.GMF_TRANSACTION_VALUATION is referenced by following:
| Description: | This is a helper table for Accounting Pre-Processor. This table stores the Subledger Accounting event model names that is used by the pre-processor. |
|---|
GMF.GMF_XLA_EVENT_MODEL does not reference any database object
GMF.GMF_XLA_EVENT_MODEL is referenced by following:
| Description: | This table is the SLA Extract Headers table. The transactions for process inventory organizations are processed and all the necessary data for accounting are stored in this table. When the SLA accounting program is run data from this tabl |
|---|
GMF.GMF_XLA_EXTRACT_HEADERS does not reference any database object
GMF.GMF_XLA_EXTRACT_HEADERS is referenced by following:
| Description: | Stores extract headers temporarily in a Session to create events in SLA. Once events get created, rows from this table are inserted into GMF_XLA_EXTRACT_HEADERS table. |
|---|
GMF.GMF_XLA_EXTRACT_HEADERS_GT does not reference any database object
GMF.GMF_XLA_EXTRACT_HEADERS_GT is referenced by following:
| Description: | This table is the SLA Extract Lines table. The transactions for process inventory organizations are processed and all the necessary data for accounting are stored in this table. When the SLA accounting program is run data from this table |
|---|
GMF.GMF_XLA_EXTRACT_LINES does not reference any database object
GMF.GMF_XLA_EXTRACT_LINES is referenced by following:
| Description: | Stores extract lines temporarily in a Session to create events in SLA. Once events get created, rows from this table are inserted into GMF_XLA_EXTRACT_LINES table. |
|---|
GMF.GMF_XLA_EXTRACT_LINES_GT does not reference any database object
GMF.GMF_XLA_EXTRACT_LINES_GT is referenced by following:
| Description: | This table is only used in GMF Accounting Pre-Processor to store item location in the struct. Done to improve performance. |
|---|
GMF.GMF_XLA_ITEMS_GT does not reference any database object
GMF.GMF_XLA_ITEMS_GT is referenced by following:
| Description: | Contains the errors generated by OPM GL Synchronization process for invalid data. The exception report runs off this table. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| SY_EXCP_TBL.CO_CODE | SY_ORGN_MST_B |
| SY_EXCP_TBL.CO_CODE | SY_ORGN_MST |
GMF.SY_EXCP_TBL does not reference any database object
GMF.SY_EXCP_TBL is referenced by following:
| Description: | Defines tables(sources) and their attributes for use in supporting a given Third-Party integration. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| SY_SOFT_DTL.CO_CODE | SY_ORGN_MST_B |
| SY_SOFT_DTL.CO_CODE | SY_ORGN_MST |
| SY_SOFT_DTL.SOFTWARE_CODE | SY_SOFT_MST |
GMF.SY_SOFT_DTL does not reference any database object
GMF.SY_SOFT_DTL is referenced by following:
| Description: | Defines Third-Party software which has a supported interface to OPM. |
|---|
| Foreign Key Column | Foreign Table |
|---|---|
| SY_SOFT_DTL.SOFTWARE_CODE | SY_SOFT_MST |
GMF.SY_SOFT_MST does not reference any database object
GMF.SY_SOFT_MST is referenced by following:
APPS.AR_TO_SOP_DRILLDOWN_VIEW is not referenced by any database object
APPS.CM_ACST_LED_V is not referenced by any database object
APPS.CM_ADJS_DTL_V is not referenced by any database object
APPS.CM_APCM_MST_V is not referenced by any database object
APPS.CM_BRDN_DTL_V is not referenced by any database object
APPS.CM_CLDR_MST_V is not referenced by any database object
APPS.CM_CMPT_DTL_V is not referenced by any database object
APPS.CM_CMPT_DTL_VW is not referenced by any database object
APPS.CM_CMPT_DTL_VW1 is not referenced by any database object
APPS.CM_CMPT_MTL_V is not referenced by any database object
APPS.CM_RSRC_DTL_V is not referenced by any database object
APPS.CM_TEXT_TBL_VL is not referenced by any database object
APPS.CM_WHSE_ASC_V is not referenced by any database object
APPS.CM_WHSE_EFF_V is not referenced by any database object
APPS.CM_WHSE_SRC_V is not referenced by any database object
APPS.GLEX_VIEW is not referenced by any database object
APPS.GL_ALOC_BAS_V is not referenced by any database object
APPS.GL_ALOC_EXP_V is not referenced by any database object
APPS.GL_ALOC_INP_V is not referenced by any database object
APPS.GL_ALOC_MST_V is not referenced by any database object
APPS.GL_TEXT_TBL_VL is not referenced by any database object
APPS.GMF_COST_CMPNT_CLASS_SLA_V is not referenced by any database object
APPS.GMF_FORM_EFF_VW is not referenced by any database object
APPS.GMF_LC_ADJ_DETAILS_V is not referenced by any database object
APPS.GMF_LC_ADJ_HEADERS_V is not referenced by any database object
APPS.GMF_LEDGER_VALUATION_METHODS_V is not referenced by any database object
APPS.GMF_LOT_COSTED_ITEMS_V is not referenced by any database object
APPS.GMF_LOT_COSTS_V is not referenced by any database object
APPS.GMF_LOT_COST_ADJUSTMENTS_V is not referenced by any database object
APPS.GMF_LOT_COST_BURDENS_V is not referenced by any database object
APPS.GMF_MATERIAL_EFFECTIVITIES_VW1 is not referenced by any database object
APPS.GMF_ORDER_TYPES_V is not referenced by any database object
APPS.GMF_ORGANIZATION_DEFINITIONS is not referenced by any database object
APPS.GMF_RESOURCE_COSTS_V is not referenced by any database object
APPS.GMF_XLA_ACTCOST_ADJS_V is not referenced by any database object
APPS.GMF_XLA_BATCH_DETAILS_V is not referenced by any database object
APPS.GMF_XLA_BATCH_HDR_V is not referenced by any database object
APPS.GMF_XLA_BATCH_RSRC_V is not referenced by any database object
APPS.GMF_XLA_COST_RVAL_V is not referenced by any database object
APPS.GMF_XLA_CUSTOMER_V is not referenced by any database object
APPS.GMF_XLA_INVENTORY_TXNS_V is not referenced by any database object
APPS.GMF_XLA_INV_REQ_TXNS_V is not referenced by any database object
APPS.GMF_XLA_ITEMS_V is not referenced by any database object
APPS.GMF_XLA_ITEM_LOCATIONS_V is not referenced by any database object
APPS.GMF_XLA_ITEM_REVISIONS_V is not referenced by any database object
APPS.GMF_XLA_LC_ADJS_V is not referenced by any database object
APPS.GMF_XLA_LOTCOST_ADJS_V is not referenced by any database object
APPS.GMF_XLA_ORG_PARAMETERS_V is not referenced by any database object
APPS.GMF_XLA_PAYABLES_INVOICES_V is not referenced by any database object
APPS.GMF_XLA_PM_RSRC_TXNS_V is not referenced by any database object
APPS.GMF_XLA_PM_TXNS_V is not referenced by any database object
APPS.GMF_XLA_PO_TXNS_V is not referenced by any database object
APPS.GMF_XLA_RCV_TXNS_V is not referenced by any database object
APPS.GMF_XLA_RCV_VENDOR_V is not referenced by any database object
APPS.GMF_XLA_SO_TXNS_V is not referenced by any database object
APPS.GMF_XLA_SUBINV_V is not referenced by any database object
APPS.GMF_XLA_TXN_REASONS_V is not referenced by any database object
APPS.GMF_XLA_VENDOR_V is not referenced by any database object
APPS.GML_OM_SHIP_DTL_VW is not referenced by any database object
APPS.IC_ITEM_LOCT_VW is not referenced by any database object
APPS.OPM_CUSTOMERS is not referenced by any database object
APPS.OPM_SITE_USES_ALL is not referenced by any database object
APPS.RA_CUST_TRX_LINE_V is not referenced by any database object
APPS.TERTORY_VIEW is not referenced by any database object
|
|
|
| Copyright (c) 2001 - 2005, Oracle | - Use Restricted by Contract |