VIEW: APPS.BOMFV_MFG_RESOURCES

Source

View Text - Preformatted

SELECT RE.RESOURCE_CODE RESOURCE_CODE , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , RE.DESCRIPTION DESCRIPTION , RE.DISABLE_DATE INACTIVE_DATE , CS.COST_ELEMENT , AC.ACTIVITY , RE.UNIT_OF_MEASURE , RE.ABSORPTION_ACCOUNT , RE.RATE_VARIANCE_ACCOUNT , RE.EXPENDITURE_TYPE , '_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' , '_KF:INV:MSTK:SY' "_KF:OUTSIDE_PROCESS_ITEM" , '_DF:BOM:BOM_RESOURCES:RE' , RE.ORGANIZATION_ID , RE.PURCHASE_ITEM_ID , RE.RESOURCE_ID , RE.COST_ELEMENT_ID , RE.DEFAULT_ACTIVITY_ID , 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_SYSTEM_ITEMS SY, GL_CODE_COMBINATIONS CO1, GL_CODE_COMBINATIONS CO2, CST_ACTIVITIES AC, CST_COST_ELEMENTS CS, MTL_PARAMETERS PA, BOM_RESOURCES RE WHERE RE.PURCHASE_ITEM_ID = SY.INVENTORY_ITEM_ID(+) AND RE.ORGANIZATION_ID = SY.ORGANIZATION_ID(+) AND RE.ORGANIZATION_ID = PA.ORGANIZATION_ID AND RE.ORGANIZATION_ID = AL.ORGANIZATION_ID AND RE.COST_ELEMENT_ID = CS.COST_ELEMENT_ID AND RE.DEFAULT_ACTIVITY_ID = AC.ACTIVITY_ID(+) AND RE.ABSORPTION_ACCOUNT = CO1.CODE_COMBINATION_ID(+) AND RE.RATE_VARIANCE_ACCOUNT = CO2.CODE_COMBINATION_ID(+) AND '_SEC:re.organization_id' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT RE.RESOURCE_CODE RESOURCE_CODE
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, RE.DESCRIPTION DESCRIPTION
, RE.DISABLE_DATE INACTIVE_DATE
, CS.COST_ELEMENT
, AC.ACTIVITY
, RE.UNIT_OF_MEASURE
, RE.ABSORPTION_ACCOUNT
, RE.RATE_VARIANCE_ACCOUNT
, RE.EXPENDITURE_TYPE
, '_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'
, '_KF:INV:MSTK:SY' "_KF:OUTSIDE_PROCESS_ITEM"
, '_DF:BOM:BOM_RESOURCES:RE'
, RE.ORGANIZATION_ID
, RE.PURCHASE_ITEM_ID
, RE.RESOURCE_ID
, RE.COST_ELEMENT_ID
, RE.DEFAULT_ACTIVITY_ID
, 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_SYSTEM_ITEMS SY
, GL_CODE_COMBINATIONS CO1
, GL_CODE_COMBINATIONS CO2
, CST_ACTIVITIES AC
, CST_COST_ELEMENTS CS
, MTL_PARAMETERS PA
, BOM_RESOURCES RE
WHERE RE.PURCHASE_ITEM_ID = SY.INVENTORY_ITEM_ID(+)
AND RE.ORGANIZATION_ID = SY.ORGANIZATION_ID(+)
AND RE.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND RE.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND RE.COST_ELEMENT_ID = CS.COST_ELEMENT_ID
AND RE.DEFAULT_ACTIVITY_ID = AC.ACTIVITY_ID(+)
AND RE.ABSORPTION_ACCOUNT = CO1.CODE_COMBINATION_ID(+)
AND RE.RATE_VARIANCE_ACCOUNT = CO2.CODE_COMBINATION_ID(+)
AND '_SEC:RE.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY