DBA Data[Home] [Help]

APPS.ICX_POR_WF_UTIL_PKG dependencies on OE_ORDER_HEADERS_ALL

Line 39: oe_order_headers_all ooh,

35: SELECT TO_CHAR(ooh.order_number), ool.flow_status_code, ool.line_id
36: INTO l_so_number, l_status_code, l_line_id
37: from po_requisition_lines_all prl,
38: po_requisition_headers_all prh,
39: oe_order_headers_all ooh,
40: oe_order_lines_all ool,
41: po_system_parameters_all psp
42: WHERE prl.requisition_header_id = prh.requisition_header_id
43: AND prl.requisition_line_id = p_req_line_id