Search Results po_dist_dtl

Overview

The GL_CURR_MST table is a master data repository for currency definitions within the Oracle E-Business Suite, specifically for the Process Manufacturing Financials (GMF) module. Its primary role is to serve as the central reference for all currency codes utilized across integrated financial and operational processes. A critical implementation detail is that, when Oracle Financials is integrated, this table is populated and synchronized with currency data from the core Oracle Financials applications, ensuring a single source of truth for currency information across the manufacturing and financial ecosystem.

Key Information Stored

While the provided metadata does not list specific columns beyond the primary key, the table's structure is defined by its purpose. The primary column is CURRENCY_CODE, which serves as the unique identifier and primary key (GL_CURR_MST_PK). This code corresponds to standard ISO currency codes like USD, EUR, or GBP. Based on its description and foreign key relationships, the table likely stores associated descriptive attributes for each currency, such as the currency name, symbol, and potentially precision details. It acts as the validating entity for any currency code used in transactional and master data tables throughout the GMF and related modules.

Common Use Cases and Queries

This table is fundamental for any reporting or data validation involving monetary amounts. Common use cases include validating currency codes in data imports, generating reports that list all active currencies, and supporting multi-currency transactions in Process Manufacturing. A typical query would join GL_CURR_MST to transactional tables to retrieve currency descriptions alongside amounts.

Basic Currency Listing: SELECT currency_code FROM gl_curr_mst ORDER BY currency_code;
Validation in Data Loads: Ensuring a provided currency code exists: SELECT COUNT(*) FROM gl_curr_mst WHERE currency_code = :p_curr_code;
Reporting Join Example: Retrieving purchase order details with currency description: SELECT poh.order_number, poh.billing_currency, cm.currency_name FROM po_ordr_hdr poh, gl_curr_mst cm WHERE poh.billing_currency = cm.currency_code;

Related Objects

GL_CURR_MST is a foundational table referenced extensively by foreign keys across GMF and adjacent modules, primarily in Procurement (PO), Order Management (OP), and General Ledger setup tables. Key documented relationships include:

GL_ACCT_MAP: Joined on GL_ACCT_MAP.CURRENCY_CODE.
GL_PLCY_MST: Joined on GL_PLCY_MST.BASE_CURRENCY_CODE.
GL_SUBR_LED / GL_SUBR_TST: Joined on CURRENCY_BASE and CURRENCY_TRANS columns.
OP_ORDR_HDR / OP_ORDR_DTL: Joined on BILLING_CURRENCY and BASE_CURRENCY.
PO_ORDR_HDR: Joined on PO_ORDR_HDR.BILLING_CURRENCY.
OP_CHRG_MST, OP_PRCE_MST, PO_VEND_MST: Joined on their respective CURRENCY_CODE, DEFAULT_CURRENCY columns.

Table: GL_CURR_MST 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.GL_CURR_MST, object_name:GL_CURR_MST, status:VALID, product: GMF - Process Manufacturing Financials , description: This table contains the Currency definitions. Note that with Oracle Financials integration this table is populated with the Currency data from Oracle Financials. , implementation_dba_data: GMF.GL_CURR_MST ,
Table: GL_CURR_MST 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.GL_CURR_MST, object_name:GL_CURR_MST, status:VALID, product: GMF - Process Manufacturing Financials , description: This table contains the Currency definitions. Note that with Oracle Financials integration this table is populated with the Currency data from Oracle Financials. , implementation_dba_data: GMF.GL_CURR_MST ,
Table: GL_LDGR_MST 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.GL_LDGR_MST, object_name:GL_LDGR_MST, status:VALID, product: GMF - Process Manufacturing Financials , description: GL ledgers , implementation_dba_data: GMF.GL_LDGR_MST ,
Table: GL_ACCT_TTL 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.GL_ACCT_TTL, object_name:GL_ACCT_TTL, status:VALID, product: GMF - Process Manufacturing Financials , description: This table contains the system defined Account Titles. User is not allowed to change them in OPM. , implementation_dba_data: GMF.GL_ACCT_TTL ,
Table: GL_LDGR_MST 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.GL_LDGR_MST, object_name:GL_LDGR_MST, status:VALID, product: GMF - Process Manufacturing Financials , description: GL ledgers , implementation_dba_data: GMF.GL_LDGR_MST ,
Table: GL_ACCT_TTL 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.GL_ACCT_TTL, object_name:GL_ACCT_TTL, status:VALID, product: GMF - Process Manufacturing Financials , description: This table contains the system defined Account Titles. User is not allowed to change them in OPM. , implementation_dba_data: GMF.GL_ACCT_TTL ,
Table: GL_ACCU_MST 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.GL_ACCU_MST, object_name:GL_ACCU_MST, status:VALID, product: GMF - Process Manufacturing Financials , 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, , implementation_dba_data: GMF.GL_ACCU_MST ,
Table: GL_ACCU_MST 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.GL_ACCU_MST, object_name:GL_ACCU_MST, status:VALID, product: GMF - Process Manufacturing Financials , 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, , implementation_dba_data: GMF.GL_ACCU_MST ,
Table: GL_ACCT_MST 12.2.2
owner:GMF, object_type:TABLE, fnd_design_data:GMF.GL_ACCT_MST, object_name:GL_ACCT_MST, status:VALID, product: GMF - Process Manufacturing Financials , 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. , implementation_dba_data: GMF.GL_ACCT_MST ,
Table: GL_ACCT_MST 12.1.1
owner:GMF, object_type:TABLE, fnd_design_data:GMF.GL_ACCT_MST, object_name:GL_ACCT_MST, status:VALID, product: GMF - Process Manufacturing Financials , 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. , implementation_dba_data: GMF.GL_ACCT_MST ,