DBA Data[Home] [Help]

APPS.CSD_REFURBISH_IRO_GRP dependencies on PO_REQUISITION_LINES_ALL

Line 346: po_requisition_lines_all prl,

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

Line 414: po_requisition_lines_all prl,

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

Line 456: from po_requisition_lines_all

452: --
453: Cursor get_req_org_id (p_requisition_header_id in number,
454: p_requisition_line_id in number) is
455: Select destination_organization_id
456: from po_requisition_lines_all
457: where requisition_header_id = p_requisition_header_id
458: and requisition_line_id = p_requisition_line_id;
459:
460: --- Define Record Types of Type Cursor Definitions