APPS.AHL_PRD_MRSHL_PVT dependencies on AHL_PRD_VISITS_V

Line 230: SELECT inv_locator_id, subinventory, locator_segments FROM ahl_prd_visits_v

226: AND decode(p_fetch_mode,'UI',REQ.REQUIRED_QUANTITY - (REQ.issued_quantity +
227: REQ.AVAILABLE_QUANTITY + REQ.NOT_AVAILABLE_QUANTITY ),1) > 0;
228:
229: CURSOR visit_info_csr(p_visit_id NUMBER)IS
230: SELECT inv_locator_id, subinventory, locator_segments FROM ahl_prd_visits_v
231: WHERE visit_id = p_visit_id;
232: l_locator_id NUMBER;
233: l_subinventory VARCHAR2(10);
234: l_locator_segments VARCHAR2(240);

Line 660: SELECT inv_locator_id, subinventory, locator_segments FROM ahl_prd_visits_v

656: AND REQ.REQUIRED_QUANTITY > REQ.issued_quantity
657: AND AVAILABLE_QUANTITY > 0;
658:
659: CURSOR visit_info_csr(p_visit_id NUMBER)IS
660: SELECT inv_locator_id, subinventory, locator_segments FROM ahl_prd_visits_v
661: WHERE visit_id = p_visit_id;
662: l_locator_id NUMBER;
663: l_subinventory VARCHAR2(10);
664: l_locator_segments VARCHAR2(240);

Line 1266: SELECT inv_locator_id, subinventory, locator_segments FROM ahl_prd_visits_v

1262: AND WO.visit_task_id = VTS.visit_task_id)
1263: GROUP BY asml.inventory_item_id,ASML.organization_id,AWOS.WIP_ENTITY_ID,ASML.OPERATION_SEQUENCE;
1264:
1265: CURSOR visit_info_csr(p_visit_id NUMBER)IS
1266: SELECT inv_locator_id, subinventory, locator_segments FROM ahl_prd_visits_v
1267: WHERE visit_id = p_visit_id;
1268: l_locator_id NUMBER;
1269: l_subinventory VARCHAR2(10);
1270: l_locator_segments VARCHAR2(240);