DBA Data[Home] [Help]

APPS.INV_WORKFLOW dependencies on OE_ORDER_LINES_ALL

Line 146: FROM oe_order_lines_all

142: IF (ic_order_line_id <> 0) THEN
143: BEGIN
144: SELECT source_document_type_id
145: INTO v_doc_type_id
146: FROM oe_order_lines_all
147: WHERE line_id = TO_NUMBER(ic_order_line_id);
148: EXCEPTION
149: WHEN NO_DATA_FOUND THEN
150: fnd_message.set_name('FND', 'FLEX-BUILD INVALID VALUE');

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

168: IF (v_doc_type_id = 10) THEN
169: BEGIN
170: SELECT mp.ap_accrual_account
171: INTO v_order_type_cogs
172: FROM mtl_parameters mp, po_requisition_lines_all prl, oe_order_lines_all ool
173: WHERE ool.line_id = TO_NUMBER(ic_order_line_id)
174: AND prl.requisition_line_id = ool.source_document_line_id
175: AND mp.organization_id = prl.destination_organization_id;
176: