APPS.PON_VALIDATE_ITEM_PRICES_INT dependencies on PO_SHIP_TO_LOC_ORG_V

Line 3251: from po_ship_to_loc_org_v po_v

3247: -- fph
3248: -- again to avoid some full table scan
3249: update pon_item_prices_interface p
3250: set ship_to_location_id = (select (nvl(max(location_id), -1))
3251: from po_ship_to_loc_org_v po_v
3252: where po_v.location_code = p.ship_to_location)
3253: where batch_id = p_batch_id
3254: and ship_to_location <> 'SHIP_NONE_ENTERED';
3255: --

Line 3258: from po_ship_to_loc_org_v po_v

3254: and ship_to_location <> 'SHIP_NONE_ENTERED';
3255: --
3256: update pon_item_prices_interface p
3257: set ship_to_location_id = (select (nvl(max(location_id), -1))
3258: from po_ship_to_loc_org_v po_v
3259: where upper(po_v.location_code) = upper(p.ship_to_location))
3260: where batch_id = p_batch_id
3261: and ship_to_location <> 'SHIP_NONE_ENTERED'
3262: and ship_to_location_id = -1;

Line 3269: from po_ship_to_loc_org_v po_v

3265: -- we need to update all valid user entered shipping locations to the
3266: -- actual case sensitive value fph
3267: update pon_item_prices_interface p
3268: set ship_to_location = (select (nvl(max(location_code), -1))
3269: from po_ship_to_loc_org_v po_v
3270: where po_v.location_id = p.ship_to_location_id)
3271: where batch_id = p_batch_id
3272: and ship_to_location <> 'SHIP_NONE_ENTERED'
3273: AND ship_to_location_id <> -1;