DBA Data[Home] [Help]

APPS.INV_WORKFLOW dependencies on MTL_PARAMETERS

Line 88: v_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE := NULL;

84: l_function_name VARCHAR2(20) := 'GENERATE_COGS';
85: --
86: -- Bug 6065114 added following variables for OPM purposes.
87: --
88: v_process_enabled_flag mtl_parameters.process_enabled_flag%TYPE := NULL;
89: v_requisition_line_id NUMBER := NULL;
90:
91: /* Begin Bug 11823085 */
92: l_gmf_patch_level fnd_product_installations.patch_level%TYPE;

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:

Line 336: FROM mtl_parameters

332: -- in the WHERE clause of the following SQL Statment.
333: -- Removed NVL function from the SELECT statement.
334: SELECT cost_of_sales_account
335: INTO v_organization_cogs
336: FROM mtl_parameters
337: WHERE organization_id = ic_to_inv_organization_id;
338: EXCEPTION
339: WHEN NO_DATA_FOUND THEN
340: NULL;