Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.CSTFV_MATL_OVHD_CST_SUB_ELMNT |
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
, '_KF:SQLGL:GL#:GCC1'
, BR.ABSORPTION_ACCOUNT
, '_KF:SQLGL:GL#:GCC2'
, BR.RATE_VARIANCE_ACCOUNT
, '_DF:BOM:BOM_RESOURCES:BR'
, /* WHO */ BR.CREATION_DATE
, BR.CREATED_BY
, BR.LAST_UPDATE_DATE
, BR.LAST_UPDATED_BY
FROM GL_CODE_COMBINATIONS GCC1
, GL_CODE_COMBINATIONS GCC2
, CST_ACTIVITIES CA
, HR_ALL_ORGANIZATION_UNITS HAOU
, MTL_PARAMETERS MP
, BOM_RESOURCES BR
WHERE BR.COST_ELEMENT_ID = 2
AND BR.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND HAOU.ORGANIZATION_ID = BR.ORGANIZATION_ID
AND BR.DEFAULT_ACTIVITY_ID = CA.ACTIVITY_ID (+)
AND BR.ABSORPTION_ACCOUNT = GCC1.CODE_COMBINATION_ID (+)
AND BR.RATE_VARIANCE_ACCOUNT = GCC2.CODE_COMBINATION_ID (+)
AND '_SEC:BR.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY