APPS.PO_VAL_SHIPMENTS2 dependencies on PO_LOCATIONS_VAL_V

Line 1049: -- po_locations_val_v by ship_to_location_id and ship_to_organization_id.

1045: x_result_type := po_validations.c_result_type_failure;
1046: END IF;
1047:
1048: -- If ship_to_location_id is not null, check if record exists in
1049: -- po_locations_val_v by ship_to_location_id and ship_to_organization_id.
1050: -- If no record exists, or multiple records exist, then error.
1051: FORALL i IN 1 .. p_id_tbl.COUNT
1052: INSERT INTO po_validation_results_gt
1053: (result_set_id,

Line 1077: FROM po_locations_val_v PLV

1073: FROM DUAL
1074: WHERE p_ship_to_location_id_tbl(i) IS NOT NULL
1075: AND NOT EXISTS(
1076: SELECT 1
1077: FROM po_locations_val_v PLV
1078: WHERE PLV.location_id = p_ship_to_location_id_tbl(i)
1079: AND ship_to_site_flag = 'Y'
1080: AND ( PLV.inventory_organization_id IS NULL
1081: OR PLV.inventory_organization_id = p_ship_to_organization_id_tbl(i)