341: msi.serial_number_control_code,
342: msi.concatenated_segments
343: From Oe_Order_Headers_All oeh,
344: Oe_Order_Lines_all oel,
345: po_requisition_headers_all prh,
346: po_requisition_lines_all prl,
347: mtl_system_items_kfv msi
348: Where oeh.header_id = p_ISO_Header_Id_IN
349: And NVL(oeh.cancelled_flag,'N') = 'N'
409: From Oe_Order_Headers_All oeh,
410: Oe_Order_Lines_all oel,
411: hz_parties hp,
412: hz_cust_accounts hca,
413: po_requisition_headers_all prh,
414: po_requisition_lines_all prl,
415: mtl_system_items_kfv msi
416: Where oeh.header_id = p_ISO_Header_Id_Out
417: And NVL(oeh.cancelled_flag,'N') = 'N'