DBA Data[Home] [Help]

APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on MTL_PARAMETERS_VIEW

Line 130: Changed the reference mtl_parameters from mtl_parameters_view

126:
127: CURSOR c_mtl_trx(cp_organization_id IN NUMBER) IS
128: /* Bug 4941701. Added by Lakshmi Gopalsami
129: For performance fix. SQL id - 14829562
130: Changed the reference mtl_parameters from mtl_parameters_view
131: and selected process_enabled_flag in the cursor. */
132: SELECT process_enabled_flag
133: FROM mtl_parameters
134: WHERE Organization_id = cp_organization_id;

Line 148: lv_opm_organization_flag mtl_parameters_view.process_enabled_flag%type;

144:
145: /* Variable Declarations */
146: lv_procedure_name VARCHAR2(60); --File.Sql.35 Cbabu := 'jai_rcv_deliver_rtr_pkg.process_transaction';
147: -- lv_register_type VARCHAR2(1); --Either A or C.
148: lv_opm_organization_flag mtl_parameters_view.process_enabled_flag%type;
149: lv_statement_id VARCHAR2(4);
150: lv_debug VARCHAR2(1); --File.Sql.35 Cbabu := 'Y';
151: lv_accounting_type VARCHAR2(30);
152: lv_include_cenvat_in_costing VARCHAR2(1);