Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CSTFV_MATL_COST_SUB_ELEMENT |
SELECT /* REGULAR ATTRIBUTE */ BR.RESOURCE_ID
, BR.RESOURCE_CODE
, BR.DESCRIPTION
, BR.DISABLE_DATE
, BR.EXPENDITURE_TYPE
, '_LA:BR.DEFAULT_BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, '_LA:BR.COST_CODE_TYPE:MFG_LOOKUPS:CST_COST_CODE_TYPE:MEANING'
, /* ID */ MP.ORGANIZATION_CODE
, HAOU.NAME
, BR.ORGANIZATION_ID
, CA.ACTIVITY
, BR.DEFAULT_ACTIVITY_ID
, '_DF:BOM:BOM_RESOURCES:BR'
, /* WHO */ BR.CREATION_DATE
, BR.CREATED_BY
, BR.LAST_UPDATE_DATE
, BR.LAST_UPDATED_BY
FROM CST_ACTIVITIES CA
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, BOM_RESOURCES BR
WHERE BR.COST_ELEMENT_ID = 1
AND BR.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = BR.ORGANIZATION_ID
AND BR.DEFAULT_ACTIVITY_ID = CA.ACTIVITY_ID (+)
AND '_SEC:BR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY