APPS.PO_VAL_SHIPMENTS2 dependencies on PO_LOCATIONS_VAL_V

Line 685: -- po_locations_val_v by ship_to_location_id and ship_to_organization_id.

681: x_result_type := po_validations.c_result_type_failure;
682: END IF;
683:
684: -- If ship_to_location_id is not null, check if record exists in
685: -- po_locations_val_v by ship_to_location_id and ship_to_organization_id.
686: -- If no record exists, or multiple records exist, then error.
687: FORALL i IN 1 .. p_id_tbl.COUNT
688: INSERT INTO po_validation_results_gt
689: (result_set_id,

Line 713: FROM po_locations_val_v PLV

709: FROM DUAL
710: WHERE p_ship_to_location_id_tbl(i) IS NOT NULL
711: AND NOT EXISTS(
712: SELECT 1
713: FROM po_locations_val_v PLV
714: WHERE PLV.location_id = p_ship_to_location_id_tbl(i)
715: AND ship_to_site_flag = 'Y'
716: AND ( PLV.inventory_organization_id IS NULL
717: OR PLV.inventory_organization_id = p_ship_to_organization_id_tbl(i)