DBA Data[Home] [Help]

APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on MTL_PARAMETERS_VIEW

Line 161: Changed the reference mtl_parameters from mtl_parameters_view

157:
158: CURSOR c_mtl_trx(cp_organization_id IN NUMBER) IS
159: /* Bug 4941701. Added by Lakshmi Gopalsami
160: For performance fix. SQL id - 14829562
161: Changed the reference mtl_parameters from mtl_parameters_view
162: and selected process_enabled_flag in the cursor. */
163: SELECT process_enabled_flag
164: FROM mtl_parameters
165: WHERE Organization_id = cp_organization_id;

Line 179: lv_opm_organization_flag mtl_parameters_view.process_enabled_flag%type;

175:
176: /* Variable Declarations */
177: lv_procedure_name VARCHAR2(60); --File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.process_transaction';
178: -- lv_register_type VARCHAR2(1); --Either A or C.
179: lv_opm_organization_flag mtl_parameters_view.process_enabled_flag%type;
180: lv_statement_id VARCHAR2(4);
181: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
182: lv_accounting_type VARCHAR2(30);
183: lv_include_cenvat_in_costing VARCHAR2(1);