APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on AHL_WORKORDER_TASKS_V

Line 600: from ahl_workorder_tasks_v

596: -- and get organization id
597: CURSOR ahl_job_csr(p_wo_id in number) IS
598: select job_status_code, organization_id , wip_entity_id
599: --from ahl_workorders_v
600: from ahl_workorder_tasks_v
601: where workorder_id = p_wo_id;
602:
603: /*
604: --To check if user sends a target visit, then check should be made that the visit is open.

Line 2801: FROM ahl_workorder_tasks_v AHL, csi_item_instances CSI

2797: SELECT CSI.INVENTORY_ITEM_ID, AHL.organization_id
2798: , CSI.inventory_revision revision, CSI.quantity, CSI.unit_of_measure,
2799: CSI.serial_number, CSI.lot_number
2800: --FROM ahl_workorders_v AHL, csi_item_instances CSI
2801: FROM ahl_workorder_tasks_v AHL, csi_item_instances CSI
2802: Where CSI.instance_id = p_instance_id
2803: --and csi.inv_organization_id = ahl.organization_id
2804: And AHL.workorder_id = p_wo_id;
2805: BEGIN

Line 5035: AHL_WORKORDER_TASKS_V AWT

5031: SELECT MTL.RESERVATION_ID RESERVATION_ID
5032: FROM MTL_RESERVATIONS MTL,
5033: AHL_WORKORDERS AWO,
5034: AHL_VISIT_TASKS_B AVT,
5035: AHL_WORKORDER_TASKS_V AWT
5036: WHERE AWO.WORKORDER_ID = AWT.WORKORDER_ID
5037: AND AWO.WIP_ENTITY_ID = AWT.WIP_ENTITY_ID
5038: AND AWO.VISIT_TASK_ID = AVT.VISIT_TASK_ID
5039: AND AVT.RETURN_TO_SUPPLY_FLAG = 'Y'