1781: INTO x_po_line_num,
1782: x_po_line_id
1783: FROM po_lines_merge_v pol2,
1784: po_headers_all poh,
1785: po_line_types_b plt --
1787: AND pol2.draft_id = PO_AUTOCREATE_PARAMS.g_draft_id
1788: AND poh.po_header_id = pol2.po_header_id
1789: AND NVL (poh.org_id, -99) = NVL (po_autocreate_params.g_purchasing_ou_id, -99)
1889: SELECT MIN (pli.line_num)
1890: INTO x_po_line_num
1891: FROM po_lines_interface pli,
1892: po_requisition_lines_all prl,
1893: po_line_types_b plt --
1895: AND pli.line_num IS NOT NULL
1896: AND prl.requisition_line_id <> x_requisition_line_id
1897: AND prl.requisition_line_id = pli.requisition_line_id