Item Overhead Cost

SELECT :P_ORG_CODE,
  crd.resources,
  gms.calendar_code,
  gms.period_code,
  mthd.cost_mthd_code ,
  crd.nominal_cost
FROM CM_RSRC_DTL crd,
  mtl_parameters mp,
  gmf_period_statuses gms,
  gmf_calendar_assignments gca,
  cm_mthd_mst mthd
WHERE crd.organization_id= mp.organization_id
  AND gca.cost_type_id            = mthd.cost_type_id
AND mp.organization_code = :P_ORG_CODE
    AND crd.legal_entity_id         = gca.legal_entity_id
        AND gca.calendar_code           = gms.calendar_code
AND gms.period_id        =crd.period_id
AND gms.legal_entity_id  =crd.legal_entity_id
AND gms.period_code      = TO_CHAR(to_date(:P_PERIOD,'MON-YY'), 'MMYY') ;

OPM Item Standard Cost Query

SELECT msib.segment1 item_code,
  msib.description item_desc,
  msib.primary_unit_of_measure uom,
  cal.calendar_code,
  xop.period_code cost_period,
  cmm.cost_mthd_code cost_type,
  ccmv.cost_cmpntcls_code cost_component_class,
  ccd.cost_analysis_code analysis_code,
  SUM(CMPNT_COST) unit_cost
FROM apps.CM_CMPT_DTL ccd ,
  apps.mtl_system_items_b msib ,
  apps.mtl_parameters mp ,
  apps.CM_MTHD_MST cmm,
  gmf_period_statuses xop,
  CM_CLDR_DTL cal,
  CM_CMPT_MST_VL ccmv,
  mtl_item_categories_v mic,
  mtl_category_sets_v mcs
WHERE msib.inventory_item_id=ccd.inventory_item_id
AND msib.inventory_item_id  =mic.inventory_item_id
AND msib.organization_id    =mic.organization_id
AND mcs.category_set_id     = mic.category_set_id
AND mic.segment1           IN ('RM','PKG')
AND ccmv.cost_cmpntcls_id   = ccd.cost_cmpntcls_id
AND cal.period_code         =xop.period_code
AND msib.organization_id    =ccd.organization_id
AND cmm.cost_type_id        =ccd.cost_type_id
AND mp.organization_id      = ccd.organization_id
AND cmm.cost_mthd_code      ='STANDARD'
AND mp.organization_code    =:P_ORG_CODE
AND ccd.period_id           =xop.period_id
AND ccd.delete_mark         =0
AND xop.period_code         = TO_CHAR( to_date(:P_PERIOD,'MON-YY'),'MMYY')
GROUP BY msib.segment1 ,
  msib.description ,
  msib.primary_unit_of_measure,
  ccd.cost_analysis_code,
  cmm.cost_mthd_code,
  xop.period_code,
  cal.calendar_code,
  ccmv.cost_cmpntcls_code
ORDER BY msib.segment1 ;

Oracle Process Manufacturing Financials Tables:

TABLE NAME	DESCRIPTION
CM_ACER_MSG	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
CM_ACPR_CTL	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
CM_ACST_LED	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
CM_ACST_LED_EFC	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
CM_ADJS_DTL	The Actual Cost Adjustments Details table -  contains the adjustments details required and entered for cost adjustments.
CM_ADJS_DTL_EFC	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
CM_ALPR_CTL	Cost Allocation Process Control Table - Contains the process information such as Fiscal Year and Period, Costing Calendar and Period.
CM_ALYS_MST	Cost Analysis Code Master Table.
CM_APCM_INT	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
CM_APCM_MST	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
CM_APCM_MST_EFC	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
CM_BRDN_DTL	Cost Burden Details - contains the Burden (Overhead) costs applied to an item
CM_BTCH_SUM	Obsolete
CM_CLDR_DTL	Costing Calendar Details
CM_CLDR_HDR	Costing Calendar Header Table
CM_CLDR_HDR_B	Costing Calendar Header Table
CM_CLDR_HDR_TL	Table to store translated columns of Cost Calendar Header Table
CM_CMPT_DTL	Cost Component Details
CM_CMPT_DTL_EFC	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
CM_CMPT_GRP	Cost component Groups
CM_CMPT_MST	Cost Component Master
CM_CMPT_MST_B	Cost Component Master
CM_CMPT_MST_TL	Table to store translated columns for Cost Component Master Table
CM_CMPT_MTL	This table contains the item or item cost class specific material cost component and material analysis code.  Used by the Actual Cost Process.
CM_CUPD_CTL	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.
CM_CUPD_MSG	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
CM_MTHD_MST	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.
CM_OPRN_SUM	Obsolete
CM_REAS_CDS	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.
CM_RLUP_CTL	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.
CM_RLUP_ITM	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
CM_RLUP_MSG	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
CM_RSRC_DTL	Resource Costs
CM_RSRC_DTL_EFC	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
CM_SCST_LED	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
CM_SCST_LED_EFC	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
CM_TEXT_HDR	Header information for Text entered through Edit Text option
CM_TEXT_TBL_TL	Costing Translation Text Table.
CM_WHSE_ASC	The Costing Warehouse Association Table - allows the OPM user to build an association between costing and inventory warehouses.
CM_WHSE_EFF	Costing Warehouse Effectivities.  Used by Cost Rollup Process
CM_WHSE_SRC	Costing Source Warehouses - Used by Rollup process
GL_ACCT_CLS	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.
GL_ACCT_HRC	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
GL_ACCT_KEY	*NOT USED*
GL_ACCT_MAP	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
GL_ACCT_MST	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.
GL_ACCT_TTL	This table contains the system defined Account Titles.  User is not allowed to change them in OPM.
GL_ACCT_TYP	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.
GL_ACCT_USG	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.
GL_ACCT_VAL	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.
GL_ACCU_MAP	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
GL_ACCU_MST	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,
GL_ACCU_VAL	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.
GL_ALOC_BAS	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
GL_ALOC_DTL	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.
GL_ALOC_DTL_EFC	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
GL_ALOC_EXP	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.
GL_ALOC_INP	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.
GL_ALOC_INP_EFC	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
GL_ALOC_MST	Master table to store the definition of the allocation codes.
GL_CLDR_DTL	This table contains the period defination for Fiscal year. This table is not used with Oracle Financials integrated setup.
GL_CLDR_HDR	This table contains the Fiscal Year defination for a Company. This table is not used with Oracle Financials integrated setup.
GL_CURR_MST	This table contains the Currency definitions. Note that with Oracle Financials integration this table is populated with the Currency data from Oracle Financials.
GL_CURR_MST_INT	This is an interface table for synchronizing Currencies from Oracle Financials to OPM.
GL_EVNT_MST	This table contains the pre-defined Event codes. An event is any activity within OPM that has a financial impact.
GL_EVNT_MST_TEMP	An internal table used by GL Update process to improve performance
GL_EVNT_PLC	Event specific Company Fiscal Policy information
GL_EXPN_CDS_TMP	Temporary table used for performance improvment in cost allocation process.  This table is populated with values from GL_CODE_COMBINATIONS table.
GL_ITEM_CST	Item costs for transactions.  Maintains accounting and current costs.  Component cost details are available in GL_ITEM_DTL table.
GL_ITEM_CST_EFC	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
GL_ITEM_DTL	Cost component detail information for the item.  Component details for the Accounting cost available in GL_ITEM_CST table.
GL_ITEM_DTL_EFC	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
GL_LDGR_MST	GL ledgers
GL_LEDG_MAP	GL ledger mapping.  Used for GL mapping.
GL_MEMO_STA	Internal Table used by AR Update process
GL_MESG_TBL	General ledger messages table.  Messages generated during transaction posting by Subsidiary Ledger Update process.
GL_PLCY_LGR	Company ledgers
GL_PLCY_MST	Fiscal policy of a company.  Fiscal policy defines the GL attributes of the company.
GL_PLCY_MST_EFC	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
GL_PLCY_SEG	Segments for account key segregation.  Stores the Chart of Accounts.
GL_PLCY_SYS	Fiscal policy sub-systems
GL_RATE_TYP	Exchange rate Classification such as daily, average, bal sheet.
GL_RATE_TYP_INT	Exchange Rate Type Interface.  Used for synchronzing rate types from Oracle Financials.
GL_SETU_ERR	GL mapping setup errors found during Subsidiary Ledger Update process.  Not currently used.
GL_SEVT_MST	GL mapping subevents.  OPM user is not allowed to modify this information.
GL_SEVT_TTL	GL mapping subevent account titles.  Account titles that are impacted by a subsystem subevent.
GL_SRCE_MST	Subsystem master table
GL_SUBR_LED	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.
GL_SUBR_LED_EFC	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
GL_SUBR_LED_VAR	Table for storing all types of batch close variances calculated during actual subledger run.
GL_SUBR_STA	OPM Subsidiary Ledger Update process Control table
GL_SUBR_TST	Subsidiary ledger test run work table.  Used to run Subledger Update process in test mode to verify the bookings before running a live Update.
GL_SUBR_TST_EFC	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
GL_SUBR_TST_VAR	Table for storing all types of batch close variances calculated during test subledger run.
GL_TEXT_HDR	Table used to store text types for GL
GL_TEXT_TBL_TL	GL Module Text Lines. Descriptive text for all tables in this module.
GL_UPDT_CTL	The control table for OPM GL Update Process.  Only used with OPM integrated with Oracle Financials.
GL_UPDT_MSG	OPM GL Update process error messages table.  Only used with OPM integrated with Oracle Financials.
GL_VALN_CDS	Validation codes for account key auto-generation.
GL_XCHG_RTE	Exchange rates
GMF_BATCH_REQUIREMENTS	Batch  requirement details
GMF_BATCH_REQUIREMENTS_GTMP
GMF_BATCH_REQUIREMENTS_GTMP1
GMF_BATCH_VIB_DETAILS	Virtual incremental batch details
GMF_BURDEN_ASSOCIATION	In OPM Costing, this table is where the Percentage Burden Associations are stored.
GMF_BURDEN_CODES	In OPM Costing, this is where the Percentage Burden Codes are stored.
GMF_BURDEN_PERCENTAGES	In OPM Costing, this is where the Burden Percentages are established.
GMF_BURDEN_PRIORITIES	In OPM Costing, this is where the Percentage Burden Priorities are established.
GMF_CALENDAR_ASSIGNMENTS	Cost Calendar Assignments
GMF_COST_METHOD_LEVEL	Table of all cost methods that cost items at the summary level
GMF_FISCAL_POLICIES	Fiscal policy of legal entity. Fiscal policy defines the GL attributes of legal entity
GMF_INCOMING_MATERIAL_LAYERS	Layer data for consumption transactions
GMF_INV_TXN_FLAGS_GT
GMF_INVOICE_DISTRIBUTIONS	Supplementary table to store invoice variance amounts for Actual Costing
GMF_ITEM_GROUPS	Stores the grouping of items (representative vs represented) for Summary Level costing
GMF_LAYER_COST_DETAILS	Layer Cost Details
GMF_LC_ACTUAL_COST_ADJS	This table used to store Actual Landed cost adjustments which are processed by actual cost proces for actual cost types
GMF_LC_ADJ_TRANSACTIONS	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
GMF_LC_LOT_COST_ADJS	This table used to store Actual Landed cost adjustments which are processed by Lot cost process
GMF_LEDGER_VALUATION_METHODS	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_LOT_COST_ADJUSTMENT_DTLS	OPM Lot Cost Adjustments details table
GMF_LOT_COST_ADJUSTMENTS	OPM Lot Cost Adjustments header table
GMF_LOT_COST_BURDENS	Burden details for lot costed items
GMF_LOT_COST_DETAILS	Lot Cost details table
GMF_LOT_COSTED_ITEMS	Lot cost enabled items
GMF_LOT_COSTED_ITEMS_GT	This table stores all items flaged as lot costed
GMF_LOT_COSTS	OPM Lot Costs Header Table
GMF_MATERIAL_LOT_COST_TXNS	Transaction history table for lot costs
GMF_OUTGOING_MATERIAL_LAYERS	Layer data for the batch yield transactions.
GMF_PERIOD_BALANCES	Period Inventory Balances for Process Orgs
GMF_PERIOD_BALANCES_GT	Temporary table for Period Inventory Balances for Process Orgs
GMF_PERIOD_STATUSES	Cost Period statuses for a Legal Entity & Cost Type
GMF_PERIOD_STATUSES_GT	Global temporary table gmf_period_statuses_gt with on commit delete rows
GMF_PROCESS_ORGANIZATIONS_GT	This table stores process organizations for temporary session
GMF_RCV_ACCOUNTING_TXNS	This table stores information for receiving accounting for process organizations
GMF_RESOURCE_LAYERS	Consumption Resource Layers
GMF_TRANSACTION_VALUATION	Transaction Valuation table for process organizations
GMF_XLA_EVENT_MODEL	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_XLA_EXTRACT_HEADERS	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_XLA_EXTRACT_HEADERS_GT	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_XLA_EXTRACT_LINES	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_XLA_EXTRACT_LINES_GT	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_XLA_ITEMS_GT	This table is only used in GMF Accounting Pre-Processor to store item location in the struct. Done to improve performance.
SY_EXCP_TBL	Contains the errors generated by OPM GL Synchronization process for invalid data.  The exception report runs off this table.
SY_SOFT_DTL	Defines tables(sources) and their attributes for use in supporting a given Third-Party integration.
SY_SOFT_MST	Defines Third-Party software which has a supported interface to OPM.

 

Oracle Process Manufacturing Financials Views:

VIEW NAME	DESCRIPTION
AR_TO_SOP_DRILLDOWN_VIEW	AR to SOP drilldown view
CM_ACST_LED_V	Acquisition cost LED view
CM_ADJS_DTL_V	View to enable master-detail relationship on Actual Cost Adjustments form
CM_APCM_MST_V	View to enable master-detail relationship on Invoice Price Maintenance form
CM_BRDN_DTL_V	View to enable master-detail relationship on Burden Details form
CM_CLDR_HDR_VL	Language resolved view of Cost Calendar Header and Translated description table
CM_CLDR_MST_V	View on period statuses & calendars
CM_CMPT_DTL_V	View to enable master-detail relationship on Cost Details form
CM_CMPT_DTL_VW	View of TOTAL_COST
CM_CMPT_DTL_VW1	View on cm_cmpt_dtl
CM_CMPT_MST_VL	Language resolved view of Cost Component Class Master and Translated description table
CM_CMPT_MTL_V	View to enable master-detail relationship on Material Cost Components form
CM_RSRC_DTL_V	View to enable master-detail relationship on Resource Costs form
CM_TEXT_TBL_VL	CM Text table view
CM_WHSE_ASC_V	View to enable master-detail relationship on Cost Warehouse Associations form
CM_WHSE_EFF_V	View to enable master-detail relationship on Rollup Target Warehouses form
CM_WHSE_SRC_V	View to enable master-detail relationship on Rollup Source Warehouses form
GLEX_VIEW	Glex view
GL_ALOC_BAS_V	View to enable master-detail relationship on Allocation Basis form
GL_ALOC_EXP_V	View to enable master-detail relationship on Expenses to Allocate form
GL_ALOC_INP_V	View to enable master-detail relationship on Allocation Maintenance form
GL_ALOC_MST_V	View to enable master-detail relationship on Allocation Codes form
GL_SUBR_LED_VW	OBSOLETE:GL Subsidiary Ledger View
GL_SUBR_TST_VW	OBSOLETE:GL Subsidiary Ledger Test View
GL_TEXT_TBL_VL	GL Text table view
GMF_COST_CMPNT_CLASS_SLA_V	View for the value set , GMF_COST_CMPNT_CLASS_SLA
GMF_FORM_EFF_VW	Internal helper view for Standard Cost Rollup
GMF_LC_ADJ_DETAILS_V	LC Adjustment details view will contain detailed information for each actual LC adjustment
GMF_LC_ADJ_HEADERS_V	View used to store LC adjustments will be populated by LCM tables
GMF_LEDGER_VALUATION_METHODS_V	Helper view for Ledger Valuation methods form
GMF_LEGAL_ENTITIES	Internal view to retrieve Legal Entity information
GMF_LEGAL_ENTITIES_VW2	Helper view for display of Legal Entities in Costing
GMF_LOT_COSTED_ITEMS_V	Helper view for Lot Costed Items Form
GMF_LOT_COSTS_V	Internal View for the lot item cost details form
GMF_LOT_COST_ADJUSTMENTS_V	Internal View for Lot Cost Adjustments
GMF_LOT_COST_BURDENS_V	View for lot cost burdens form
GMF_MATERIAL_EFFECTIVITIES_VW1	This is a helper view for Item substitution for costing.
GMF_ORDER_TYPES_V	View for the value set , GMF_ORDER_TYPES
GMF_ORGANIZATION_DEFINITIONS	View of Process Organization Definition Details
GMF_RESOURCE_COSTS_V	Resource Costs View
GMF_XLA_ACTCOST_ADJS_V	View for SLA ADR sources from Actual Cost Adjustments
GMF_XLA_BATCH_DETAILS_V	View for SLA ADR sources from Batch Details
GMF_XLA_BATCH_HDR_V	SLA batch header view
GMF_XLA_BATCH_RSRC_V	SLA batch resources view
GMF_XLA_COST_RVAL_V	View for SLA ADR sources from Cost Revaluation
GMF_XLA_CUSTOMER_V	View for SLA ADR sources from customers
GMF_XLA_INVENTORY_TXNS_V	View for SLA ADR sources from inventory transactions
GMF_XLA_INV_REQ_TXNS_V	View for SLA ADR sources from Requisition Transactions View
GMF_XLA_ITEMS_V	View for SLA ADR sources from Item Definition
GMF_XLA_ITEM_LOCATIONS_V	View for SLA ADR sources from Inventory Item Locations
GMF_XLA_ITEM_REVISIONS_V	View for SLA ADR sources from item revisions
GMF_XLA_LC_ADJS_V	SLA LC Adjustments view, used to display LC adjustments information in accounting events screen
GMF_XLA_LOTCOST_ADJS_V	View for SLA ADR sources from Lot Cost Adjustments View
GMF_XLA_ORG_PARAMETERS_V	View for SLA ADR sources from Inventory Organization parameters.
GMF_XLA_PAYABLES_INVOICES_V	View for SLA ADR sources from Payable Invoices
GMF_XLA_PM_RSRC_TXNS_V	View for SLA ADR sources from Resource Transactions
GMF_XLA_PM_TXNS_V	View for SLA ADR sources from Batch Transactions
GMF_XLA_PO_TXNS_V	View for SLA ADR sources from purchase order Transactions
GMF_XLA_RCV_TXNS_V	View for SLA ADR sources from Receipt Transactions
GMF_XLA_RCV_VENDOR_V	View for SLA ADR sources from Receipt Vendor Transactions
GMF_XLA_SO_TXNS_V	View for SLA ADR sources from Sales Order Transactions
GMF_XLA_SUBINV_V	View for SLA ADR sources from Subinventory definition
GMF_XLA_TXN_REASONS_V	View for SLA ADR sources from Inventory Transactions Reasons
GMF_XLA_VENDOR_V	View for SLA ADR sources from Vendor
GML_OM_SHIP_DTL_VW	OBSOLETE:Selects the OM Shipments and their related information in OPM Inventory Transactions.
IC_ITEM_LOCT_VW	OBSOLETE:Used in Financials for Lots
IC_TRAN_PND_OM_VW1	OBSOLETE: Pending inventory transactions for OM view
OPM_CUSTOMERS	Used for OPM customer synchronization
OPM_SITE_USES_ALL	OPM site uses view
RA_CUST_TRX_LINE_V	Customer transaction line view
TERTORY_VIEW	Territory view