VIEW: APPS.CSTFV_PERIOD_CLOSE_SUMM_BAL

Source

View Text - Preformatted

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

View Text - HTML Formatted

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