DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on OE_ORDER_LINES_ALL

Line 306: FROM oe_order_headers_all ooh, oe_order_lines_all ool , po_requisition_lines_all prl ,

302:
303:
304: SELECT ool.org_id
305: INTO l_org_id
306: FROM oe_order_headers_all ooh, oe_order_lines_all ool , po_requisition_lines_all prl ,
307: po_system_parameters_all psp
308: WHERE prl.requisition_header_id = nvl(p_req_hdr_id,prl.requisition_header_id)
309: AND p_req_line_id IS NOT null
310: AND prl.requisition_line_id = p_req_line_id