APPS.INV_WORKFLOW dependencies on OE_ORDER_LINES_ALL

Line 166: FROM oe_order_lines_all

162: IF (ic_order_line_id <> 0) THEN
163: BEGIN
164: SELECT source_document_type_id
165: INTO v_doc_type_id
166: FROM oe_order_lines_all
167: WHERE line_id = TO_NUMBER(ic_order_line_id);
168: EXCEPTION
169: WHEN NO_DATA_FOUND THEN
170: fnd_message.set_name('FND', 'FLEX-BUILD INVALID VALUE');

Line 192: FROM mtl_parameters mp, po_requisition_lines_all prl, oe_order_lines_all ool

188: IF (v_doc_type_id = 10) THEN
189: BEGIN
190: SELECT mp.ap_accrual_account, mp.process_enabled_flag, prl.requisition_line_id
191: INTO v_order_type_cogs, v_process_enabled_flag, v_requisition_line_id
192: FROM mtl_parameters mp, po_requisition_lines_all prl, oe_order_lines_all ool
193: WHERE ool.line_id = TO_NUMBER(ic_order_line_id)
194: AND prl.requisition_line_id = ool.source_document_line_id
195: AND mp.organization_id = prl.destination_organization_id;
196: