[Home] [Help]
APPS.PO_CHG_REQUEST_GRP dependencies on PO_LINE_LOCATIONS_ARCHIVE_ALL
Line 36: from po_line_locations_archive_all
32: l_api_name CONSTANT VARCHAR2(30) := 'getNewShipmentNumber';
33: begin
34: select max(shipment_num) + 1
35: into l_shipment_number
36: from po_line_locations_archive_all
37: where po_line_id = p_line_id
38: and latest_external_flag = 'Y';
39:
40: