View: CSTBV_MFG_ACTIVITY_COSTS

Product:	BOM - Bills of Material
Description:	- Retrofitted
Implementation/DBA Data:	APPS.CSTBV_MFG_ACTIVITY_COSTS

View Text

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 /* 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

Columns