VIEW: APPS.CSTFV_MFG_ACTIVITY_COSTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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