APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_VISITS_B

Line 1515: SELECT vi.organization_id from ahl_workorders wo, ahl_visits_b vi

1511: WHERE disposition_id = p_disposition_id ;
1512:
1513:
1514: CURSOR get_organization_csr(p_workorder_id IN NUMBER) IS
1515: SELECT vi.organization_id from ahl_workorders wo, ahl_visits_b vi
1516: WHERE wo.workorder_id = p_workorder_id
1517: AND wo.visit_id = vi.visit_id;
1518:
1519: CURSOR val_lot_number_csr(p_lot_number IN VARCHAR2, p_inventory_item_id IN NUMBER) IS

Line 2956: SELECT vi.organization_id from ahl_workorders wo, ahl_visits_b vi

2952: PROCEDURE derive_columns(p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type)
2953: IS
2954:
2955: CURSOR get_organization_csr(p_workorder_id IN NUMBER) IS
2956: SELECT vi.organization_id from ahl_workorders wo, ahl_visits_b vi
2957: WHERE wo.workorder_id = p_workorder_id
2958: AND wo.visit_id = vi.visit_id;
2959:
2960: CURSOR get_instance_from_serial(p_item_id IN NUMBER, p_serial_num IN VARCHAR2) IS

Line 4202: SELECT vi.organization_id from ahl_workorders wo, ahl_visits_b vi

4198: --Validate_item---------------------------------------------
4199: PROCEDURE validate_item(p_inventory_item_id IN NUMBER, p_organization_id IN NUMBER, p_workorder_id IN NUMBER) IS
4200:
4201: CURSOR get_wo_organization_csr(p_workorder_id NUMBER) IS
4202: SELECT vi.organization_id from ahl_workorders wo, ahl_visits_b vi
4203: WHERE wo.workorder_id = p_workorder_id
4204: AND wo.visit_id = vi.visit_id;
4205:
4206: CURSOR val_item_csr(p_item_id NUMBER, p_organization_id NUMBER) IS

Line 5190: FROM AHL_VISITS_B VST

5186: WO.WORKORDER_ID = p_workorder_id;
5187:
5188: CURSOR visit_instance_csr (c_visit_id IN NUMBER) IS
5189: SELECT VST.ITEM_INSTANCE_ID
5190: FROM AHL_VISITS_B VST
5191: WHERE VST.VISIT_ID = c_visit_id;
5192:
5193: CURSOR uc_header_instance_csr(p_uc_header_id IN NUMBER) IS
5194: SELECT csi_item_instance_id FROM ahl_unit_config_headers