APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PO_SHIP_TO_LOC_ORG_V

Line 2852: from po_ship_to_loc_org_v po_v

2848: -- fph
2849: -- again to avoid some full table scan
2850: update pon_item_prices_interface p
2851: set ship_to_location_id = (select (nvl(max(location_id), -1))
2852: from po_ship_to_loc_org_v po_v
2853: where po_v.location_code = p.ship_to_location)
2854: where batch_id = p_batch_id
2855: and ship_to_location <> 'SHIP_NONE_ENTERED';
2856: --

Line 2859: from po_ship_to_loc_org_v po_v

2855: and ship_to_location <> 'SHIP_NONE_ENTERED';
2856: --
2857: update pon_item_prices_interface p
2858: set ship_to_location_id = (select (nvl(max(location_id), -1))
2859: from po_ship_to_loc_org_v po_v
2860: where upper(po_v.location_code) = upper(p.ship_to_location))
2861: where batch_id = p_batch_id
2862: and ship_to_location <> 'SHIP_NONE_ENTERED'
2863: and ship_to_location_id = -1;

Line 2870: from po_ship_to_loc_org_v po_v

2866: -- we need to update all valid user entered shipping locations to the
2867: -- actual case sensitive value fph
2868: update pon_item_prices_interface p
2869: set ship_to_location = (select (nvl(max(location_code), -1))
2870: from po_ship_to_loc_org_v po_v
2871: where po_v.location_id = p.ship_to_location_id)
2872: where batch_id = p_batch_id
2873: and ship_to_location <> 'SHIP_NONE_ENTERED'
2874: AND ship_to_location_id <> -1;