View: AHL_SCHEDULE_MATERIALS_V

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

View Text

SELECT AWOS.WORKORDER_ID
, ASML.VISIT_TASK_ID
, AWOS.JOB_NUMBER WO_NAME
, ASML.SCHEDULED_MATERIAL_ID SCHEDULE_MATERIAL_ID
, ASML.INVENTORY_ITEM_ID
, MSIK.CONCATENATED_SEGMENTS
, MSIK.PRIMARY_UOM_CODE UOM_CODE
, MSIK.PRIMARY_UNIT_OF_MEASURE UOM
, ASML.OBJECT_VERSION_NUMBER
, ASML.ITEM_GROUP_ID
, ASML.RT_OPER_MATERIAL_ID
, ASML.VISIT_ID
, ASML.REQUESTED_DATE
, ASML.REQUESTED_QUANTITY
, ASML.SCHEDULED_DATE SCHEDULE_DATE
, ASML.SCHEDULED_QUANTITY SCHEDULE_QUANTITY
, ASML. WORKORDER_OPERATION_ID
, ASML.OPERATION_SEQUENCE
, AWOS.PRIORITY
, AWOS.ORGANIZATION_NAME
, AWOS.DEPARTMENT_NAME
, AWOS.INCIDENT_NUMBER
, AWOS.VISIT_NUMBER
, NVL(AHL_PP_MATERIALS_PVT.GET_ISSUED_QTY(MSIK.ORGANIZATION_ID
, ASML.INVENTORY_ITEM_ID
, ASML.WORKORDER_OPERATION_ID)
, 0) ISSUED_QUANTITY
, AWOS.JOB_STATUS_CODE
, AWOS.JOB_STATUS_MEANING
, ASML.SCHEDULED_MATERIAL_ID SALES_ORDER_LINE_ID
FROM AHL_WORKORDERS_V AWOS
, AHL_SCHEDULE_MATERIALS ASML
, MTL_SYSTEM_ITEMS_KFV MSIK
WHERE AWOS.VISIT_TASK_ID = ASML.VISIT_TASK_ID
AND ASML.INVENTORY_ITEM_ID = MSIK.INVENTORY_ITEM_ID
AND ASML.ORGANIZATION_ID = MSIK.ORGANIZATION_ID
AND ASML.STATUS = 'ACTIVE'

Columns