Product: | BOM - Bills of Material |
---|---|
Description: | - Retrofitted |
Implementation/DBA Data: | APPS.BOMBV_INTERNAL_MFG_RESOURCES |
SELECT RE.RESOURCE_CODE RESOURCE_CODE
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, RE.DESCRIPTION DESCRIPTION
, RE.DISABLE_DATE INACTIVE_DATE
, RE.UNIT_OF_MEASURE
, '_LA:RE.AUTOCHARGE_TYPE:MFG_LOOKUPS:BOM_AUTOCHARGE_TYPE:MEANING'
, '_LA:RE.COST_CODE_TYPE:MFG_LOOKUPS:CST_COST_CODE_TYPE:MEANING'
, '_LA:RE.DEFAULT_BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, '_LA:RE.RESOURCE_TYPE:MFG_LOOKUPS:BOM_RESOURCE_TYPE:MEANING'
, '_LA:RE.ALLOW_COSTS_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:RE.STANDARD_RATE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, '_LA:RE.FUNCTIONAL_CURRENCY_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, RE.RESOURCE_ID
, RE.ORGANIZATION_ID
, RE.COST_ELEMENT_ID
, RE.DEFAULT_ACTIVITY_ID
, RE.ABSORPTION_ACCOUNT
, RE.RATE_VARIANCE_ACCOUNT
, RE.EXPENDITURE_TYPE
, RE.LAST_UPDATE_DATE UPDATED_ON
, RE.LAST_UPDATED_BY UPDATED_BY
, RE.CREATION_DATE CREATED_ON
, RE.CREATED_BY
FROM HR_ALL_ORGANIZATION_UNITS AL
, MTL_PARAMETERS PA
, BOM_RESOURCES RE
WHERE RE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND RE.COST_CODE_TYPE <> 4
AND '_SEC:RE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY