DBA Data[Home] [Help]

APPS.PO_LINE_LOCATIONS_SV7 dependencies on PO_LOCATIONS_VAL_V

Line 862: or ship_to_org_id matches the org specified in po_locations_val_v

858: X_progress := '150';
859: IF (X_ship_to_location_id IS NOT NULL)
860: THEN
861: /* allow those which location_id does not have inv org
862: or ship_to_org_id matches the org specified in po_locations_val_v
863: */
864:
865: X_progress := '160';
866: SELECT count(*)

Line 868: FROM po_locations_val_v

864:
865: X_progress := '160';
866: SELECT count(*)
867: INTO X_temp_count
868: FROM po_locations_val_v
869: WHERE location_id = X_ship_to_location_id
870: AND ship_to_site_flag = 'Y'
871: AND (inventory_organization_id IS NULL
872: OR