DBA Data[Home] [Help]

APPS.POR_APPRV_WF_UTIL_GRP dependencies on PO_REQUISITION_LINES_ALL

Line 47: from po_requisition_lines_all prl,

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,
48: po_requisition_headers_all prh,
49: oe_order_headers_all ooh,
50: oe_order_lines_all ool,
51: po_system_parameters_all psp

Line 104: po_requisition_lines_all prl

100: FROM FND_ID_FLEX_SEGMENTS fs,
101: fnd_segment_attribute_values fsav,
102: financials_system_params_all fsp,
103: gl_sets_of_books gls,
104: po_requisition_lines_all prl
105: WHERE prl.requisition_line_id = p_req_line_id AND
106: --added NVL check for single org, bug#6705513
107: NVL(prl.org_id,-99) = NVL(fsp.org_id,-99) AND
108: fsp.set_of_books_id = gls.set_of_books_id AND