View: AHL_JOB_OPER_MATERIALS_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:
Implementation/DBA Data:	APPS.AHL_JOB_OPER_MATERIALS_V

View Text

SELECT ASML.SCHEDULED_MATERIAL_ID
, ASML.VISIT_TASK_ID
, AWOS.WORKORDER_ID
, ASML.INVENTORY_ITEM_ID
, MSIV.CONCATENATED_SEGMENTS
, ASML.REQUESTED_QUANTITY
, ASML.ITEM_GROUP_ID
, ASML.RT_OPER_MATERIAL_ID
, MSIV.PRIMARY_UNIT_OF_MEASURE UOM
, ASML.OBJECT_VERSION_NUMBER
, AVST.VISIT_ID
, AVST.VISIT_NUMBER
, WIPR.DATE_REQUIRED REQUESTED_DATE
, ASML.SCHEDULED_DATE SCHEDULE_DATE
, ASML.SCHEDULED_QUANTITY SCHEDULE_QUANTITY
, WIPR.OPERATION_SEQ_NUM OPERATION_SEQUENCE
, MSIV.DESCRIPTION
, MSIV.MRP_PLANNING_CODE
, AWOP.OPERATION_CODE
, ASML.WORKORDER_OPERATION_ID
, NVL(AHL_PP_MATERIALS_PVT.GET_ISSUED_QTY(MSIV.ORGANIZATION_ID
, ASML.INVENTORY_ITEM_ID
, ASML.WORKORDER_OPERATION_ID)
, 0) ISSUED_QUANTITY
, ASML.SCHEDULED_MATERIAL_ID SALES_ORDER_LINE_ID
FROM AHL_WORKORDERS AWOS
, AHL_WORKORDER_OPERATIONS_V AWOP
, AHL_SCHEDULE_MATERIALS ASML
, WIP_REQUIREMENT_OPERATIONS WIPR
, MTL_SYSTEM_ITEMS_VL MSIV
, AHL_VISITS_VL AVST
WHERE AWOS.VISIT_TASK_ID = ASML.VISIT_TASK_ID
AND ASML.VISIT_ID = AVST.VISIT_ID
AND AWOS.WIP_ENTITY_ID = WIPR.WIP_ENTITY_ID
AND ASML.OPERATION_SEQUENCE = WIPR.OPERATION_SEQ_NUM
AND ASML.INVENTORY_ITEM_ID = WIPR.INVENTORY_ITEM_ID
AND ASML.ORGANIZATION_ID = WIPR.ORGANIZATION_ID
AND AWOP.WORKORDER_OPERATION_ID = ASML.WORKORDER_OPERATION_ID
AND ASML.INVENTORY_ITEM_ID = MSIV.INVENTORY_ITEM_ID
AND ASML.ORGANIZATION_ID = MSIV.ORGANIZATION_ID
AND ASML.STATUS = 'ACTIVE'

Columns