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:
215: -- in the WHERE clause of the following SQL Statment.
216: -- Removed NVL function from the SELECT statement.
217: SELECT cost_of_sales_account
218: INTO v_organization_cogs
219: FROM mtl_parameters
220: WHERE organization_id = ic_to_inv_organization_id;
221: EXCEPTION
222: WHEN NO_DATA_FOUND THEN
223: NULL;