[Home] [Help]
View: 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
Name |
ACTIVITY_ID |
COST_TYPE_ID |
ORGANIZATION_ID |
TOTAL_COST |
TOTAL_ACTIVITY_UNITS |
UNIT_COST |
ACTIVITY_NAME |
COST_TYPE |
ORGANIZATION_CODE |
ORGANIZATION_NAME |
CREATED_DATE |
CREATED_BY |
UPDATED_DATE |
UPDATED_BY |