APPS.POR_APPRV_WF_UTIL_GRP dependencies on OE_ORDER_HEADERS_ALL

Line 43: l_so_number oe_order_headers_all.order_number%type;

39: CHANGE HISTORY: 17-SEP-2003 sbgeorge Created
40: ===========================================================================*/
41: FUNCTION get_so_number(p_req_line_id IN NUMBER) RETURN NUMBER
42: IS
43: l_so_number oe_order_headers_all.order_number%type;
44: BEGIN
45: SELECT ooh.order_number
46: INTO l_so_number
47: from po_requisition_lines_all prl,

Line 49: oe_order_headers_all ooh,

45: SELECT ooh.order_number
46: INTO l_so_number
47: from po_requisition_lines_all prl,
48: po_requisition_headers_all prh,
49: oe_order_headers_all ooh,
50: oe_order_lines_all ool,
51: po_system_parameters_all psp
52: WHERE prl.requisition_header_id = prh.requisition_header_id
53: AND prl.requisition_line_id = p_req_line_id