Search Results non_invoiced_so

Overview

The CSTFV_PRODUCT_LINE_ACCOUNT view is an APPS-owned database object in Oracle EBS Release 12.1.1 and 12.2.2, catalogued under the BOM (Bills of Material) product family but functionally tied to the Cost Management (CST) module. The "F" and "V" in the naming convention follow Oracle's legacy custom/retrofitted view conventions, and the object's description is explicitly annotated "Retrofitted," indicating that it was ported from an earlier release and retained for backward compatibility. The view denormalizes cost accounting flexfield assignments held at the inventory category level, joining them to organization, cost group, and category set definitions so that reporting and integration layers can resolve account combinations without repeatedly performing multi-table joins.

Its principal role is to expose the full set of general ledger account assignments defined on MTL_CATEGORY_ACCOUNTS, including the bridging, analytical, and revenue-related accounts. Because the Flexfield Key (_KF) tokens are embedded in the SELECT list, the view is compatible with Oracle's Key Flexfield reporting framework, allowing discovery of the correct GL account structure based on the user's chart of accounts.

Underlying Base Objects

The view is defined over seven documented base objects, all accessed through APPS synonyms:

• MTL_CATEGORY_ACCOUNTS (MCA) — the driving table, supplying all account columns and category identifiers.
• MTL_CATEGORIES (MC) — resolves the category identifier to a category name.
• MTL_CATEGORY_SETS (MCS) — supplies the category set name.
• CST_COST_GROUPS (CCG) — provides cost group names by organization.
• MTL_PARAMETERS (MP) and HR_ALL_ORGANIZATION_UNITS (HAOU) — supply the organization code and organization name.
• GL_CODE_COMBINATIONS (GCC1 through GCC8) — outer-joined reference tables used to describe each of the eight account columns.

With the exception of the GL_CODE_COMBINATIONS joins, which are outer joins keyed by CODE_COMBINATION_ID, the relationships are inner joins on ORGANIZATION_ID and CATEGORY_ID. Consequently, a category account record appears only when a matching organization, cost group, and category set exist.

Key Columns

• ORGANIZATION_ID / ORGANIZATION_CODE — the inventory organization context for the account assignment.
• CATEGORY_ID / CATEGORY_SET_ID / CATEGORY_SET_NAME — identify the item category and the category set to which it belongs.
• COST_GROUP_ID / COST_GROUP — the cost group whose accounting treatment is described.
• MATERIAL_ACCOUNT, MATERIAL_OVERHEAD_ACCOUNT, RESOURCE_ACCOUNT, OUTSIDE_PROCESSING_ACCOUNT, OVERHEAD_ACCOUNT, EXPENSE_ACCOUNT, ENCUMBRANCE_ACCOUNT, BRIDGING_ACCOUNT — the core cost accounting flexfield combinations, each paired with a corresponding _KF:SQLGL:GL#:GCCn token.
• ANALYTICAL_IPV, ANALYTICAL_PO_MIRROR, ANALYTICAL_REVENUE_MIRROR, ANALYTICAL_MOGS — analytical accounting accounts used for inter-entity and mirror-entry reporting.
• NON_INVOICED_SO and NON_INVOICED_REVENUE — accounts used specifically for non-invoiced sales order bal