Results for “organization_code”
27 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
GMF_ORGANIZATION_DEFINITIONS is an APPS-owned reporting view within the Oracle E-Business Suite Process Manufacturing Financials (GMF) product family. Its documented purpose is to present "Process Organization Definition Details," consolidating the organizational, accounting, and inventory attributes that identify which inventory organizations are enabled for process manufacturing. The view is classified as VALID and is available in both the 12.1.1 and 12.2.2 releases, sharing identical column semantics across the two, since it abstracts ledger identity behind GL_LEDGERS rather than exposing the older GL_SETS_OF_BOOKS construct directly.
Functionally, the view answers a recurring question in process manufacturing implementations: which organizations are enabled for process execution, and what ledger, legal entity, and operating unit are they associated with? Because these attributes are distributed across Human Resources organization tables, inventory parameters, and General Ledger, the view provides a single denormalized read surface suitable for reports, concurrent programs, integrations, and ad hoc SQL without requiring the developer to reconstruct the join logic.
Underlying Base Objects
The view is defined over five referenced base objects, all exposed in the APPS schema as synonyms:
- HR_ALL_ORGANIZATION_UNITS (HAOU) — the master organization unit record; supplies ORGANIZATION_ID and the internal organization name.
- HR_ALL_ORGANIZATION_UNITS_TL (HAOUT) — the translated organization name, joined on ORGANIZATION_ID and filtered to the session language via USERENV('LANG').
- HR_ORGANIZATION_INFORMATION (HOI) — holds the ACCOUNTING INFORMATION flexfield segments that store the ledger, legal entity, and operating unit identifiers.
- MTL_PARAMETERS (MP) — inventory organization parameters; the view restricts results with MP.PROCESS_ENABLED_FLAG = 'Y', which is the defining filter that limits output to process-enabled organizations.
- GL_LEDGERS (LEDG) — the ledger definition, joined on ORG_INFORMATION1 = LEDGER_ID, supplying CHART_OF_ACCOUNTS_ID and CURRENCY_CODE.
The join chain therefore runs from the organization unit through its translated name, its accounting flexfield information, its inventory parameters, and finally to the ledger. The ACCOUNTING INFORMATION context predicate is mandatory, as it isolates the specific descriptive flexfield context that stores accounting organization assignments.
Key Columns
- ORGANIZATION_ID — primary identifier of the inventory organization; the principal join key to MTL_PARAMETERS, MTL_SYSTEM_ITEMS, and other inventory objects.
- ORGANIZATION_CODE — the short inventory organization code from MTL_PARAMETERS.
- ORGANIZATION_NAME — the translated organization name from HR_ALL_ORGANIZATION_UNITS_TL.
- LEDGER_ID — numeric ledger identifier derived from ORG_INFORMATION1.
- LEGAL_ENTITY_ID — numeric legal entity identifier derived from ORG_INFORMATION2.
- OPERATING_UNIT_ID — numeric operating unit identifier derived from ORG_INFORMATION3.
- CHART_OF_ACCOUNTS_ID — chart of accounts associated with the ledger.
- CURRENCY_CODE — the ledger's functional currency.
Because the numeric columns are produced by TO_NUMBER conversions of descriptive flexfield segments, they are safe to join directly to LEDGER_ID, LEGAL_ENTITY_ID, and OPERATING_UNIT_ID columns elsewhere.
Common Use Cases and Queries
Typical scenarios include validating process-enabled organizations before data conversion, driving multi-org reports that must display the ledger and legal entity context, and feeding downstream integrations that require organization-to-ledger mappings.
A basic listing of process organizations and their accounting context:
- SELECT organization_id, organization_code, organization_name, ledger_id, legal_entity_id, operating_unit_id, currency_code FROM gmf_organization_definitions ORDER BY organization_code;
Restricting to a specific ledger or operating unit:
- SELECT organization_id, organization_code FROM gmf_organization_definitions WHERE ledger_id = :p_ledger_id;
- SELECT organization_id, organization_code, currency_code FROM gmf_organization_definitions WHERE operating_unit_id = :p_org_id;
Joining to inventory parameters to confirm process enablement and cost organization attributes, or joining ORGANIZATION_ID to MTL_SYSTEM_ITEMS to enumerate process items by organization, are equally common. As with all APPS views, queries should be executed against the APPS schema or through a synonym, and responsibility-level security (MOAC) should be applied where organization-restricted access is required.
-
View of Process Organization Definition Details
APPS.GMF_ORGANIZATION_DEFINITIONS·↳ GL_LEDGERS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore GMF module →
-
View: GMF_RESOURCE_COSTS_V 12.1.1
APPS.GMF_RESOURCE_COSTS_V·↳ CM_RSRC_DTL·↳ GMF_PROCESS_ORGANIZATIONS_GT·Explore GMF module →
-
This table stores process organizations for temporary session
-
View of Process Organization Definition Details
APPS.GMF_ORGANIZATION_DEFINITIONS·↳ GL_LEDGERS·↳ HR_ALL_ORGANIZATION_UNITS·↳ HR_ALL_ORGANIZATION_UNITS_TL·Explore GMF module →
-
View for SLA ADR sources from Inventory Organization parameters.
APPS.GMF_XLA_ORG_PARAMETERS_V·↳ MTL_PARAMETERS·Explore GMF module →
-
This table stores process organizations for temporary session
-
View for SLA ADR sources from Inventory Organization parameters.
APPS.GMF_XLA_ORG_PARAMETERS_V·↳ MTL_PARAMETERS·Explore GMF module →
-
View: GMF_RESOURCE_COSTS_V 12.2.2
Resource Costs View
APPS.GMF_RESOURCE_COSTS_V·↳ CM_RSRC_DTL·↳ GMF_PROCESS_ORGANIZATIONS_GT·Explore GMF module →
-
View: GMF_XLA_ACTCOST_ADJS_V 12.1.1
APPS.GMF_XLA_ACTCOST_ADJS_V·↳ CM_ADJS_DTL·↳ CM_REAS_CDS·↳ GMF_PERIOD_STATUSES·Explore GMF module →
-
View: GMF_XLA_RCV_TXNS_V 12.1.1
APPS.GMF_XLA_RCV_TXNS_V·↳ GMF_RCV_ACCOUNTING_TXNS·↳ GMF_XLA_EXTRACT_HEADERS·↳ MTL_MATERIAL_TRANSACTIONS·Explore GMF module →
-
View for SLA ADR sources from inventory transactions
APPS.GMF_XLA_INVENTORY_TXNS_V·↳ GL_LEDGERS·↳ GMF_XLA_EXTRACT_HEADERS·↳ MTL_MATERIAL_TRANSACTIONS·Explore GMF module →
-
View for SLA ADR sources from inventory transactions
APPS.GMF_XLA_INVENTORY_TXNS_V·↳ GL_LEDGERS·↳ GMF_XLA_EXTRACT_HEADERS·↳ MTL_MATERIAL_TRANSACTIONS·Explore GMF module →
-
APPS.GMF_XLA_PAYABLES_INVOICES_V·↳ GMF_INVOICE_DISTRIBUTIONS·↳ GMF_PERIOD_STATUSES·↳ GMF_XLA_EXTRACT_HEADERS·Explore GMF module →
-
View: GMF_XLA_LC_ADJS_V 12.2.2
SLA LC Adjustments view, used to display LC adjustments information in accounting events screen
APPS.GMF_XLA_LC_ADJS_V·↳ GMF_LC_ADJ_TRANSACTIONS·↳ GMF_XLA_EXTRACT_HEADERS·↳ MTL_PARAMETERS·Explore GMF module →
-
View: GMF_XLA_SO_TXNS_V 12.1.1
APPS.GMF_XLA_SO_TXNS_V·↳ GMF_XLA_EXTRACT_HEADERS·↳ HZ_PARTIES·↳ MTL_MATERIAL_TRANSACTIONS·Explore GMF module →
-
View: GMF_XLA_PM_TXNS_V 12.1.1
APPS.GMF_XLA_PM_TXNS_V·↳ FND_DATE·↳ FND_MESSAGE·↳ GME_BATCH_HEADER_VW·Explore GMF module →
-
View: GMF_XLA_LOTCOST_ADJS_V 12.1.1
APPS.GMF_XLA_LOTCOST_ADJS_V·↳ GMF_LOT_COST_ADJUSTMENTS·↳ GMF_XLA_EXTRACT_HEADERS·↳ MTL_PARAMETERS·Explore GMF module →
-
View for SLA ADR sources from Payable Invoices
APPS.GMF_XLA_PAYABLES_INVOICES_V·↳ GMF_INVOICE_DISTRIBUTIONS·↳ GMF_PERIOD_STATUSES·↳ GMF_XLA_EXTRACT_HEADERS·Explore GMF module →
-
View: GMF_XLA_PM_RSRC_TXNS_V 12.1.1
APPS.GMF_XLA_PM_RSRC_TXNS_V·↳ CM_CMPT_MST·↳ FND_DATE·↳ FND_MESSAGE·Explore GMF module →
-
View: GMF_XLA_ACTCOST_ADJS_V 12.2.2
View for SLA ADR sources from Actual Cost Adjustments
APPS.GMF_XLA_ACTCOST_ADJS_V·↳ CM_ADJS_DTL·↳ CM_REAS_CDS·↳ GMF_PERIOD_STATUSES·Explore GMF module →
-
View: GMF_XLA_SO_TXNS_V 12.2.2
View for SLA ADR sources from Sales Order Transactions
APPS.GMF_XLA_SO_TXNS_V·↳ GMF_XLA_EXTRACT_HEADERS·↳ HZ_PARTIES·↳ MTL_MATERIAL_TRANSACTIONS·Explore GMF module →
-
View: GMF_XLA_PM_TXNS_V 12.2.2
View for SLA ADR sources from Batch Transactions
APPS.GMF_XLA_PM_TXNS_V·↳ FND_DATE·↳ FND_MESSAGE·↳ GME_BATCH_HEADER_VW·Explore GMF module →
-
View: GMF_XLA_LOTCOST_ADJS_V 12.2.2
View for SLA ADR sources from Lot Cost Adjustments View
APPS.GMF_XLA_LOTCOST_ADJS_V·↳ GMF_LOT_COST_ADJUSTMENTS·↳ GMF_XLA_EXTRACT_HEADERS·↳ MTL_PARAMETERS·Explore GMF module →
-
View: GMF_XLA_RCV_TXNS_V 12.2.2
View for SLA ADR sources from Receipt Transactions
APPS.GMF_XLA_RCV_TXNS_V·↳ GMF_RCV_ACCOUNTING_TXNS·↳ GMF_XLA_EXTRACT_HEADERS·↳ MTL_MATERIAL_TRANSACTIONS·Explore GMF module →
-
View: GMF_XLA_COST_RVAL_V 12.2.2
View for SLA ADR sources from Cost Revaluation
APPS.GMF_XLA_COST_RVAL_V·↳ GL_LEDGERS·↳ GMF_PERIOD_BALANCES·↳ GMF_XLA_EXTRACT_HEADERS·Explore GMF module →
-
View: GMF_XLA_COST_RVAL_V 12.1.1
APPS.GMF_XLA_COST_RVAL_V·↳ GL_LEDGERS·↳ GMF_PERIOD_BALANCES·↳ GMF_XLA_EXTRACT_HEADERS·Explore GMF module →
-
View: GMF_XLA_PM_RSRC_TXNS_V 12.2.2
View for SLA ADR sources from Resource Transactions
APPS.GMF_XLA_PM_RSRC_TXNS_V·↳ CM_CMPT_MST·↳ FND_DATE·↳ FND_MESSAGE·Explore GMF module →