View: CSTFV_PERIOD_CLOSE_DTL_BAL

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CSTFV_PERIOD_CLOSE_DTL_BAL

View Text

SELECT /* UNIQUE ATTRIBUTES */ PCD.ACCT_PERIOD_ID
, PCD.ORGANIZATION_ID
, PCD.SECONDARY_INVENTORY
, PCD.INVENTORY_ITEM_ID
, PCD.COST_GROUP_ID /* REGULAR ATTRIBUTES */
, PCD.PERIOD_END_QUANTITY
, PCD.PERIOD_END_UNIT_COST /* FOREIGN KEYS RESOLVED */
, CG.COST_GROUP
, MP.ORGANIZATION_CODE
, HR.NAME
, AP.PERIOD_NAME
, SI.DESCRIPTION
, '_KF:INV:MSTK:SY' /* IDS */ /* WHO */
, PCD.CREATION_DATE
, PCD.CREATED_BY
, PCD.LAST_UPDATE_DATE
, PCD.LAST_UPDATED_BY
FROM MTL_PER_CLOSE_DTLS PCD
, MTL_SYSTEM_ITEMS SY
, HR_ALL_ORGANIZATION_UNITS HR
, MTL_PARAMETERS MP
, ORG_ACCT_PERIODS AP
, MTL_SECONDARY_INVENTORIES SI
, CST_COST_GROUPS CG
WHERE SY.ORGANIZATION_ID = PCD.ORGANIZATION_ID
AND SY.INVENTORY_ITEM_ID = PCD.INVENTORY_ITEM_ID
AND AP.ACCT_PERIOD_ID = PCD.ACCT_PERIOD_ID
AND AP.ORGANIZATION_ID = PCD.ORGANIZATION_ID
AND SI.SECONDARY_INVENTORY_NAME(+) = PCD.SECONDARY_INVENTORY
AND SI.ORGANIZATION_ID(+) = PCD.ORGANIZATION_ID
AND PCD.ORGANIZATION_ID = HR.ORGANIZATION_ID
AND PCD.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND PCD.COST_GROUP_ID = CG.COST_GROUP_ID(+)
AND '_SEC:PCD.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

Columns