Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CSTFV_MFG_ACTIVITY_COSTS |
SELECT /* UNIQUE ATTRIBUTES */ AC.ACTIVITY_ID
, AC.COST_TYPE_ID
, AC.ORGANIZATION_ID /* REGULAR ATTRIBUTES */
, AC.TOTAL_COST
, AC.TOTAL_ACTIVITY_UNITS
, AC.UNIT_COST /* FOREIGN KEYS RESOLVED */
, CA.ACTIVITY
, CT.COST_TYPE
, MP.ORGANIZATION_CODE
, HR.NAME
, '_DF:BOM:CST_ACTIVITY_COSTS:AC' /* IDS */ /* WHO */
, AC.CREATION_DATE
, AC.CREATED_BY
, AC.LAST_UPDATE_DATE
, AC.LAST_UPDATED_BY
FROM HR_ALL_ORGANIZATION_UNITS HR
, CST_ACTIVITIES CA
, MTL_PARAMETERS MP
, CST_COST_TYPES CT
, CST_ACTIVITY_COSTS AC
WHERE AC.ORGANIZATION_ID = HR.ORGANIZATION_ID
AND AC.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND AC.COST_TYPE_ID = CT.COST_TYPE_ID
AND AC.ACTIVITY_ID = CA.ACTIVITY_ID
AND '_SEC:AC.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY