DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on OE_ORDER_HEADERS_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

Line 323: oe_order_headers_all ooh,

319: SELECT ooh.ORG_ID
320: INTO l_org_id
321: from po_requisition_lines_all prl,
322: po_requisition_headers_all prh,
323: oe_order_headers_all ooh,
324: po_system_parameters_all psp
325: WHERE prl.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)
326: AND prl.requisition_line_id = nvl(p_req_line_id,prl.requisition_line_id)
327: AND prh.requisition_header_id = nvl(p_req_hdr_id,prh.requisition_header_id)