eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.BOM_OP_RESOURCES_VIEW

Source

View Text - Preformatted


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(+)

View Text - HTML Formatted

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(+)