APPS.AHL_PRD_PARTS_CHANGE_PVT dependencies on AHL_WORKORDER_TASKS_V

Line 567: from ahl_workorder_tasks_v

563: -- and get organization id
564: CURSOR ahl_job_csr(p_wo_id in number) IS
565: select job_status_code, organization_id , wip_entity_id
566: --from ahl_workorders_v
567: from ahl_workorder_tasks_v
568: where workorder_id = p_wo_id;
569:
570: /*
571: --To check if user sends a target visit, then check should be made that the visit is open.

Line 2744: FROM ahl_workorder_tasks_v AHL, csi_item_instances CSI

2740: SELECT CSI.INVENTORY_ITEM_ID, AHL.organization_id
2741: , CSI.inventory_revision revision, CSI.quantity, CSI.unit_of_measure,
2742: CSI.serial_number, CSI.lot_number
2743: --FROM ahl_workorders_v AHL, csi_item_instances CSI
2744: FROM ahl_workorder_tasks_v AHL, csi_item_instances CSI
2745: Where CSI.instance_id = p_instance_id
2746: --and csi.inv_organization_id = ahl.organization_id
2747: And AHL.workorder_id = p_wo_id;
2748: BEGIN