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.AHL_PP_REQUIREMENT_V

Source

View Text - Preformatted


SELECT AOR.OPERATION_RESOURCE_ID REQUIREMENT_ID, WOR.RESOURCE_ID, AOR.OBJECT_VERSION_NUMBER, BOM.RESOURCE_CODE, BOM.DESCRIPTION RESOURCE_NAME, WOR.RESOURCE_SEQ_NUM RESOURCE_SEQUENCE, AWJ.WORKORDER_ID JOB_ID, AWO.WORKORDER_OPERATION_ID OPERATION_ID, WOR.OPERATION_SEQ_NUM OPERATION_SEQUENCE, AWO.STATUS_CODE OPERATION_STATUS_CODE, WIO.FIRST_UNIT_START_DATE OPERATION_START_DATE, WIO.LAST_UNIT_COMPLETION_DATE OPERATION_END_DATE, WOR.START_DATE REQUIRED_START_DATE, WOR.COMPLETION_DATE REQUIRED_END_DATE, BOM.RESOURCE_TYPE RESOURCE_TYPE_CODE, MFG.MEANING RESOURCE_TYPE_NAME, DECODE(nvl(WOR.ASSIGNED_UNITS,0), 0, 0, WOR.USAGE_RATE_OR_AMOUNT/WOR.ASSIGNED_UNITS) DURATION, BOM.UNIT_OF_MEASURE UOM_CODE, (SELECT A.UNIT_OF_MEASURE FROM MTL_UNITS_OF_MEASURE A, BOM_RESOURCES B WHERE A.UOM_CODE=B.UNIT_OF_MEASURE AND B.RESOURCE_ID = WOR.RESOURCE_ID) UOM_NAME, WOR.ASSIGNED_UNITS QUANTITY, WOR.USAGE_RATE_OR_AMOUNT TOTAL_REQUIRED, (SELECT CONCATENATED_SEGMENTS FROM AHL_OPERATIONS_VL A, AHL_WORKORDER_OPERATIONS B WHERE A.OPERATION_ID(+) = B.OPERATION_ID AND B.WORKORDER_OPERATION_ID = AWO.WORKORDER_OPERATION_ID) OPERATION_CODE, FNO.MEANING STATUS, AWJ.VISIT_TASK_ID, AWJ.STATUS_CODE JOB_STATUS_CODE, FNJ.MEANING JOB_STATUS_MEANING, WIO.DEPARTMENT_ID, WOR.SCHEDULE_SEQ_NUM FROM WIP_OPERATION_RESOURCES WOR, AHL_OPERATION_RESOURCES AOR, AHL_WORKORDER_OPERATIONS AWO , AHL_WORKORDERS AWJ, BOM_RESOURCES BOM, MFG_LOOKUPS MFG, WIP_OPERATIONS WIO, FND_LOOKUP_VALUES_VL FNO, FND_LOOKUP_VALUES_VL FNJ WHERE WOR. RESOURCE_ID = AOR.RESOURCE_ID AND AOR.WORKORDER_OPERATION_ID = AWO.WORKORDER_OPERATION_ID AND AWO.OPERATION_SEQUENCE_NUM = WOR.OPERATION_SEQ_NUM AND AWJ.WORKORDER_ID = AWO.WORKORDER_ID AND AWJ.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID AND AWJ.WIP_ENTITY_ID = WIO.WIP_ENTITY_ID AND WOR.OPERATION_SEQ_NUM = WIO.OPERATION_SEQ_NUM AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM AND WOR.RESOURCE_ID = BOM.RESOURCE_ID AND MFG.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE' AND MFG.LOOKUP_CODE(+) = BOM.RESOURCE_TYPE AND FNO.LOOKUP_TYPE(+) = 'AHL_OPERATION_STATUS' AND FNO.LOOKUP_CODE(+) = AWO.STATUS_CODE AND FNJ.LOOKUP_TYPE(+) = 'AHL_JOB_STATUS' AND FNJ.LOOKUP_CODE(+) = AWJ.STATUS_CODE

View Text - HTML Formatted

SELECT AOR.OPERATION_RESOURCE_ID REQUIREMENT_ID
, WOR.RESOURCE_ID
, AOR.OBJECT_VERSION_NUMBER
, BOM.RESOURCE_CODE
, BOM.DESCRIPTION RESOURCE_NAME
, WOR.RESOURCE_SEQ_NUM RESOURCE_SEQUENCE
, AWJ.WORKORDER_ID JOB_ID
, AWO.WORKORDER_OPERATION_ID OPERATION_ID
, WOR.OPERATION_SEQ_NUM OPERATION_SEQUENCE
, AWO.STATUS_CODE OPERATION_STATUS_CODE
, WIO.FIRST_UNIT_START_DATE OPERATION_START_DATE
, WIO.LAST_UNIT_COMPLETION_DATE OPERATION_END_DATE
, WOR.START_DATE REQUIRED_START_DATE
, WOR.COMPLETION_DATE REQUIRED_END_DATE
, BOM.RESOURCE_TYPE RESOURCE_TYPE_CODE
, MFG.MEANING RESOURCE_TYPE_NAME
, DECODE(NVL(WOR.ASSIGNED_UNITS
, 0)
, 0
, 0
, WOR.USAGE_RATE_OR_AMOUNT/WOR.ASSIGNED_UNITS) DURATION
, BOM.UNIT_OF_MEASURE UOM_CODE
, (SELECT A.UNIT_OF_MEASURE
FROM MTL_UNITS_OF_MEASURE A
, BOM_RESOURCES B
WHERE A.UOM_CODE=B.UNIT_OF_MEASURE
AND B.RESOURCE_ID = WOR.RESOURCE_ID) UOM_NAME
, WOR.ASSIGNED_UNITS QUANTITY
, WOR.USAGE_RATE_OR_AMOUNT TOTAL_REQUIRED
, (SELECT CONCATENATED_SEGMENTS
FROM AHL_OPERATIONS_VL A
, AHL_WORKORDER_OPERATIONS B
WHERE A.OPERATION_ID(+) = B.OPERATION_ID
AND B.WORKORDER_OPERATION_ID = AWO.WORKORDER_OPERATION_ID) OPERATION_CODE
, FNO.MEANING STATUS
, AWJ.VISIT_TASK_ID
, AWJ.STATUS_CODE JOB_STATUS_CODE
, FNJ.MEANING JOB_STATUS_MEANING
, WIO.DEPARTMENT_ID
, WOR.SCHEDULE_SEQ_NUM
FROM WIP_OPERATION_RESOURCES WOR
, AHL_OPERATION_RESOURCES AOR
, AHL_WORKORDER_OPERATIONS AWO
, AHL_WORKORDERS AWJ
, BOM_RESOURCES BOM
, MFG_LOOKUPS MFG
, WIP_OPERATIONS WIO
, FND_LOOKUP_VALUES_VL FNO
, FND_LOOKUP_VALUES_VL FNJ
WHERE WOR. RESOURCE_ID = AOR.RESOURCE_ID
AND AOR.WORKORDER_OPERATION_ID = AWO.WORKORDER_OPERATION_ID
AND AWO.OPERATION_SEQUENCE_NUM = WOR.OPERATION_SEQ_NUM
AND AWJ.WORKORDER_ID = AWO.WORKORDER_ID
AND AWJ.WIP_ENTITY_ID = WOR.WIP_ENTITY_ID
AND AWJ.WIP_ENTITY_ID = WIO.WIP_ENTITY_ID
AND WOR.OPERATION_SEQ_NUM = WIO.OPERATION_SEQ_NUM
AND WOR.RESOURCE_SEQ_NUM = AOR.RESOURCE_SEQUENCE_NUM
AND WOR.RESOURCE_ID = BOM.RESOURCE_ID
AND MFG.LOOKUP_TYPE(+) = 'BOM_RESOURCE_TYPE'
AND MFG.LOOKUP_CODE(+) = BOM.RESOURCE_TYPE
AND FNO.LOOKUP_TYPE(+) = 'AHL_OPERATION_STATUS'
AND FNO.LOOKUP_CODE(+) = AWO.STATUS_CODE
AND FNJ.LOOKUP_TYPE(+) = 'AHL_JOB_STATUS'
AND FNJ.LOOKUP_CODE(+) = AWJ.STATUS_CODE