VIEW: APPS.BOMFV_RTG_OPERATION_RESOURCES

Source

View Text - Preformatted

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

View Text - HTML Formatted

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