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'
350: And oeh.open_flag = 'Y'
351: And oeh.booked_flag = 'Y'
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'
418: And oeh.open_flag = 'Y'
419: And oeh.booked_flag = 'Y'