Product: | AHL - Complex Maintenance Repair and Overhaul |
---|---|
Description: | This view stores the query to retrieve Work flow nformation |
Implementation/DBA Data: | APPS.AHL_VISIT_TASK_MATRL_V |
SELECT ASMT.VISIT_ID
, ASMT.VISIT_TASK_ID
, AVTL.VISIT_TASK_NAME
, ASMT.REQUESTED_QUANTITY
, ASMT.REQUESTED_DATE
, ASMT.SCHEDULED_DATE SCHEDULED_DATE
, ASMT.SCHEDULED_QUANTITY SCHEDULED_QUANTITY
, ASMT.INVENTORY_ITEM_ID
, MSTK.CONCATENATED_SEGMENTS ITEM_DESCRIPTION
, MSTK.PRIMARY_UNIT_OF_MEASURE UOM
, ASMT.RT_OPER_MATERIAL_ID
, ASMT.ITEM_GROUP_ID
, ASMT.OPERATION_CODE
, ASMT.OPERATION_SEQUENCE
, ASMT.SCHEDULED_MATERIAL_ID SCHEDULE_MATERIAL_ID
, ASMT.OBJECT_VERSION_NUMBER
, ASMT.POSITION_PATH_ID
, AHL_MC_PATH_POSITION_PVT.GET_POSREF_BY_ID(ASMT.POSITION_PATH_ID) POSITION_PATH
, RELATIONSHIP_ID
, (SELECT NAME
FROM AHL_MC_HEADERS_VL
WHERE MC_HEADER_ID = (SELECT MC_HEADER_ID
FROM AHL_MC_RELATIONSHIPS
WHERE RELATIONSHIP_ID = ASMT.RELATIONSHIP_ID)) NAME
, RTOM.REWORK_PERCENT
, RTOM.REPLACE_PERCENT
, RTOM.ITEM_COMP_DETAIL_ID
, (SELECT CONCATENATED_VISIT_TASK
FROM AHL_VISIT_TASKS_V AVTV
WHERE AVTV.VISIT_ID = ASMT.VISIT_ID
AND AVTV.VISIT_TASK_ID = ASMT.VISIT_TASK_ID
AND ASMT.SCHEDULED_DATE IS NOT NULL) SALES_ORDER_LINE_ID
FROM AHL_VISIT_TASKS_VL AVTL
, MTL_SYSTEM_ITEMS_KFV MSTK
, AHL_SCHEDULE_MATERIALS ASMT
, AHL_RT_OPER_MATERIALS RTOM
WHERE AVTL.VISIT_ID = ASMT.VISIT_ID
AND AVTL.VISIT_TASK_ID = ASMT.VISIT_TASK_ID
AND ASMT.INVENTORY_ITEM_ID = MSTK.INVENTORY_ITEM_ID(+)
AND ASMT.ORGANIZATION_ID = MSTK.ORGANIZATION_ID(+)
AND ASMT.RT_OPER_MATERIAL_ID = RTOM.RT_OPER_MATERIAL_ID
AND (ASMT.REQUESTED_QUANTITY <> 0 )