DBA Data[Home] [Help]

APPS.PON_VALIDATE_SHIPMENTS_INT dependencies on PO_SHIP_TO_LOC_ORG_V

Line 387: FROM po_ship_to_loc_org_v po_v

383: /* bug#16839410 user will not be able to enter tab in the ship_to_location value so replacing the tab using fnd_global.local_chr */
384: UPDATE pon_auc_price_breaks_interface pb_int
385: SET ship_to_location_id =
386: (SELECT MAX(location_id)
387: FROM po_ship_to_loc_org_v po_v
388: WHERE replace(po_v.location_code,fnd_global.local_chr(9),'') = pb_int.ship_to_location
389: )
390: WHERE batch_id = p_batch_id
391: AND ship_to_location IS NOT null;