VIEW: APPS.BOMBV_RTG_OPERATION_RESOURCES

Source

View Text - Preformatted

SELECT RE.RESOURCE_SEQ_NUM RESOURCE_SEQUENCE_NUMBER , SE.OPERATION_SEQ_NUM OPERATION_SEQUENCE_NUMBER , SE.EFFECTIVITY_DATE EFFECTIVE_START_DATE , OP.ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_CODE , PA.ORGANIZATION_CODE ORGANIZATION_CODE , AL.NAME ORGANIZATION_NAME , '_KF:INV:MSTK:SY' "_KF:ROUTING_ITEM_NAME" , RE.USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT , RE.USAGE_RATE_OR_AMOUNT_INVERSE INVERSE_RATE_OR_AMOUNT , RE.ASSIGNED_UNITS ASSIGNED_UNITS , RE.RESOURCE_OFFSET_PERCENT OFFSET_PERCENT , '_LA:AUTOCHARGE_TYPE:MFG_LOOKUPS:BOM_AUTOCHARGE_TYPE:MEANING' , '_LA:BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING' , '_LA:SCHEDULE_FLAG:MFG_LOOKUPS:BOM_RESOURCE_SCHEDULE_TYPE:MEANING' , '_LA:STANDARD_RATE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING' , RE.OPERATION_SEQUENCE_ID , OP.ROUTING_SEQUENCE_ID , RE.RESOURCE_ID , RE.ACTIVITY_ID , RE.CREATION_DATE CREATED_ON , RE.CREATED_BY CREATED_BY , RE.LAST_UPDATE_DATE UPDATED_ON , RE.LAST_UPDATED_BY UPDATED_BY FROM BOM_OPERATIONAL_ROUTINGS OP, MTL_PARAMETERS PA, HR_ALL_ORGANIZATION_UNITS AL, MTL_SYSTEM_ITEMS SY, BOM_OPERATION_SEQUENCES SE, BOM_OPERATION_RESOURCES RE WHERE OP.ORGANIZATION_ID = PA.ORGANIZATION_ID AND OP.ORGANIZATION_ID = AL.ORGANIZATION_ID AND OP.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID AND OP.ORGANIZATION_ID = SY.ORGANIZATION_ID AND SE.ROUTING_SEQUENCE_ID = OP.ROUTING_SEQUENCE_ID AND RE.OPERATION_SEQUENCE_ID = SE.OPERATION_SEQUENCE_ID AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY

View Text - HTML Formatted

SELECT RE.RESOURCE_SEQ_NUM RESOURCE_SEQUENCE_NUMBER
, SE.OPERATION_SEQ_NUM OPERATION_SEQUENCE_NUMBER
, SE.EFFECTIVITY_DATE EFFECTIVE_START_DATE
, OP.ALTERNATE_ROUTING_DESIGNATOR ALTERNATE_ROUTING_CODE
, PA.ORGANIZATION_CODE ORGANIZATION_CODE
, AL.NAME ORGANIZATION_NAME
, '_KF:INV:MSTK:SY' "_KF:ROUTING_ITEM_NAME"
, RE.USAGE_RATE_OR_AMOUNT USAGE_RATE_OR_AMOUNT
, RE.USAGE_RATE_OR_AMOUNT_INVERSE INVERSE_RATE_OR_AMOUNT
, RE.ASSIGNED_UNITS ASSIGNED_UNITS
, RE.RESOURCE_OFFSET_PERCENT OFFSET_PERCENT
, '_LA:AUTOCHARGE_TYPE:MFG_LOOKUPS:BOM_AUTOCHARGE_TYPE:MEANING'
, '_LA:BASIS_TYPE:MFG_LOOKUPS:CST_BASIS:MEANING'
, '_LA:SCHEDULE_FLAG:MFG_LOOKUPS:BOM_RESOURCE_SCHEDULE_TYPE:MEANING'
, '_LA:STANDARD_RATE_FLAG:MFG_LOOKUPS:SYS_YES_NO:MEANING'
, RE.OPERATION_SEQUENCE_ID
, OP.ROUTING_SEQUENCE_ID
, RE.RESOURCE_ID
, RE.ACTIVITY_ID
, RE.CREATION_DATE CREATED_ON
, RE.CREATED_BY CREATED_BY
, RE.LAST_UPDATE_DATE UPDATED_ON
, RE.LAST_UPDATED_BY UPDATED_BY
FROM BOM_OPERATIONAL_ROUTINGS OP
, MTL_PARAMETERS PA
, HR_ALL_ORGANIZATION_UNITS AL
, MTL_SYSTEM_ITEMS SY
, BOM_OPERATION_SEQUENCES SE
, BOM_OPERATION_RESOURCES RE
WHERE OP.ORGANIZATION_ID = PA.ORGANIZATION_ID
AND OP.ORGANIZATION_ID = AL.ORGANIZATION_ID
AND OP.ASSEMBLY_ITEM_ID = SY.INVENTORY_ITEM_ID
AND OP.ORGANIZATION_ID = SY.ORGANIZATION_ID
AND SE.ROUTING_SEQUENCE_ID = OP.ROUTING_SEQUENCE_ID
AND RE.OPERATION_SEQUENCE_ID = SE.OPERATION_SEQUENCE_ID
AND '_SEC:OP.ORGANIZATION_ID' IS NOT NULL WITH READ ONLY