APPS.AHL_PRD_DISPOSITION_PVT dependencies on AHL_VISITS_B

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

1351: WHERE disposition_id = p_disposition_id ;
1352:
1353:
1354: CURSOR get_organization_csr(p_workorder_id IN NUMBER) IS
1355: SELECT vi.organization_id from ahl_workorders wo, ahl_visits_b vi
1356: WHERE wo.workorder_id = p_workorder_id
1357: AND wo.visit_id = vi.visit_id;
1358:
1359: CURSOR val_lot_number_csr(p_lot_number IN VARCHAR2, p_inventory_item_id IN NUMBER) IS

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

2529: PROCEDURE derive_columns(p_x_disposition_rec IN OUT NOCOPY AHL_PRD_DISPOSITION_PVT.disposition_rec_type)
2530: IS
2531:
2532: CURSOR get_organization_csr(p_workorder_id IN NUMBER) IS
2533: SELECT vi.organization_id from ahl_workorders wo, ahl_visits_b vi
2534: WHERE wo.workorder_id = p_workorder_id
2535: AND wo.visit_id = vi.visit_id;
2536:
2537: CURSOR get_instance_from_serial(p_item_id IN NUMBER, p_serial_num IN VARCHAR2) IS

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

3738: --Validate_item---------------------------------------------
3739: PROCEDURE validate_item(p_inventory_item_id IN NUMBER, p_organization_id IN NUMBER, p_workorder_id IN NUMBER) IS
3740:
3741: CURSOR get_wo_organization_csr(p_workorder_id NUMBER) IS
3742: SELECT vi.organization_id from ahl_workorders wo, ahl_visits_b vi
3743: WHERE wo.workorder_id = p_workorder_id
3744: AND wo.visit_id = vi.visit_id;
3745:
3746: CURSOR val_item_csr(p_item_id NUMBER, p_organization_id NUMBER) IS

Line 4730: FROM AHL_VISITS_B VST

4726: WO.WORKORDER_ID = p_workorder_id;
4727:
4728: CURSOR visit_instance_csr (c_visit_id IN NUMBER) IS
4729: SELECT VST.ITEM_INSTANCE_ID
4730: FROM AHL_VISITS_B VST
4731: WHERE VST.VISIT_ID = c_visit_id;
4732:
4733: CURSOR uc_header_instance_csr(p_uc_header_id IN NUMBER) IS
4734: SELECT csi_item_instance_id FROM ahl_unit_config_headers