DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on OE_ORDER_LINES_ALL

Line 2217: OE_ORDER_LINES_ALL OOL,

2213: INTO l_so_number, l_status_code, l_line_id
2214: from PO_REQUISITION_LINES PRL,
2215: PO_REQUISITION_HEADERS_ALL PRH, --
2216: OE_ORDER_HEADERS_ALL OOH,
2217: OE_ORDER_LINES_ALL OOL,
2218: PO_SYSTEM_PARAMETERS PSP
2219: WHERE PRL.REQUISITION_HEADER_ID = PRH.REQUISITION_HEADER_ID
2220: AND PRL.REQUISITION_LINE_ID = req_line_id
2221: AND PRH.SEGMENT1 = OOH.ORIG_SYS_DOCUMENT_REF