VIEW: APPS.CSTFV_PERIOD_CLOSE_DTL_BAL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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