View: BOM_OP_RESOURCES_VIEW

Product:	BOM - Bills of Material
Description:	Operation resources view
Implementation/DBA Data:	APPS.BOM_OP_RESOURCES_VIEW

View Text

SELECT /* ORDERED */ R.ORGANIZATION_ID
, RTG.ROUTING_TYPE
, RTG.ALTERNATE_ROUTING_DESIGNATOR
, FLEX.ITEM_ID
, NVL(RTG.COMMON_ASSEMBLY_ITEM_ID
, RTG.ASSEMBLY_ITEM_ID)
, FLEX.ITEM_NUMBER
, FLEX.PADDED_ITEM_NUMBER
, FLEX.DESCRIPTION
, D.DEPARTMENT_CODE
, OS.OPERATION_SEQ_NUM
, OS.OPERATION_DESCRIPTION
, OS.EFFECTIVITY_DATE
, OS.DISABLE_DATE
, R.RESOURCE_CODE
, ORS.RESOURCE_SEQ_NUM
, ACT.ACTIVITY
, INV_MEANING_SEL.C_FND_LOOKUP_VL( ORS.AUTOCHARGE_TYPE
, 'BOM_AUTOCHARGE_TYPE')
, INV_MEANING_SEL.C_FND_LOOKUP_VL( ORS.STANDARD_RATE_FLAG
, 'SYS_YES_NO' )
, ORS.ASSIGNED_UNITS
, ORS.USAGE_RATE_OR_AMOUNT
, ORS.USAGE_RATE_OR_AMOUNT_INVERSE
, INV_MEANING_SEL.C_FND_LOOKUP_VL( ORS.BASIS_TYPE
, 'CST_BASIS' )
, INV_MEANING_SEL.C_FND_LOOKUP_VL( ORS.SCHEDULE_FLAG
, 'BOM_RESOURCE_SCHEDULE_TYPE' )
, ORS.RESOURCE_OFFSET_PERCENT
, ORS.ATTRIBUTE_CATEGORY
, ORS.ATTRIBUTE1
, ORS.ATTRIBUTE2
, ORS.ATTRIBUTE3
, ORS.ATTRIBUTE4
, ORS.ATTRIBUTE5
, ORS.ATTRIBUTE6
, ORS.ATTRIBUTE7
, ORS.ATTRIBUTE8
, ORS.ATTRIBUTE9
, ORS.ATTRIBUTE10
, ORS.ATTRIBUTE11
, ORS.ATTRIBUTE12
, ORS.ATTRIBUTE13
, ORS.ATTRIBUTE14
, ORS.ATTRIBUTE15
, ORS.ACD_TYPE
FROM CST_ACTIVITIES ACT
, MTL_ITEM_FLEXFIELDS FLEX
, BOM_OPERATIONAL_ROUTINGS RTG
, BOM_DEPARTMENTS D
, BOM_OPERATION_SEQUENCES OS
, BOM_RESOURCES R
, BOM_OPERATION_RESOURCES ORS
WHERE R.RESOURCE_ID = ORS.RESOURCE_ID
AND ORS.OPERATION_SEQUENCE_ID = OS.OPERATION_SEQUENCE_ID
AND OS.DEPARTMENT_ID = D.DEPARTMENT_ID
AND OS.ROUTING_SEQUENCE_ID = RTG.COMMON_ROUTING_SEQUENCE_ID
AND RTG.ASSEMBLY_ITEM_ID = FLEX.ITEM_ID
AND RTG.ORGANIZATION_ID = FLEX.ORGANIZATION_ID
AND ORS.ACTIVITY_ID = ACT.ACTIVITY_ID(+)

Columns