DBA Data[Home] [Help]

APPS.ICX_POR_WF_UTIL_PKG dependencies on PO_REQUISITION_LINES_ALL

Line 37: from po_requisition_lines_all prl,

33: l_line_id NUMBER;
34: BEGIN
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

Line 85: po_requisition_lines_all prl

81: FROM FND_ID_FLEX_SEGMENTS fs,
82: fnd_segment_attribute_values fsav,
83: financials_system_params_all fsp,
84: gl_sets_of_books gls,
85: po_requisition_lines_all prl
86: WHERE prl.requisition_line_id = p_req_line_id AND
87: prl.org_id = fsp.org_id AND
88: fsp.set_of_books_id = gls.set_of_books_id AND
89: fsav.id_flex_num = gls.chart_of_accounts_id AND