DBA Data[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: