Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CSTFV_PERIOD_CLOSE_SUMM_BAL |
SELECT /* UNIQUE ATTRIBUTES */ PS.ACCT_PERIOD_ID
, PS.ORGANIZATION_ID
, PS.SECONDARY_INVENTORY /* REGULAR ATTRIBUTES */
, ML.MEANING
, PS.INVENTORY_VALUE /* FOREIGN KEYS RESOLVED */
, MP.ORGANIZATION_CODE
, HR.NAME
, AP.PERIOD_NAME
, SI.DESCRIPTION /* IDS */ /* WHO */
, PS.CREATION_DATE
, PS.CREATED_BY
, PS.LAST_UPDATE_DATE
, PS.LAST_UPDATED_BY
FROM MTL_PERIOD_SUMMARY PS
, HR_ALL_ORGANIZATION_UNITS HR
, MTL_PARAMETERS MP
, MFG_LOOKUPS ML
, ORG_ACCT_PERIODS AP
, MTL_SECONDARY_INVENTORIES SI
WHERE ML.LOOKUP_TYPE = 'MTL_INVENTORY'
AND ML.LOOKUP_CODE = PS.INVENTORY_TYPE
AND AP.ACCT_PERIOD_ID = PS.ACCT_PERIOD_ID
AND AP.ORGANIZATION_ID = PS.ORGANIZATION_ID
AND SI.SECONDARY_INVENTORY_NAME(+) = PS.SECONDARY_INVENTORY
AND SI.ORGANIZATION_ID(+) = PS.ORGANIZATION_ID
AND PS.ORGANIZATION_ID = HR.ORGANIZATION_ID
AND PS.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND '_SEC:PS.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY