APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on MTL_PARAMETERS

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 164: FROM mtl_parameters

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;
166:
167: /* Record Declarations */
168: r_trx c_trx%rowtype;

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);

Line 1919: ln_ppv_account_id mtl_parameters.purchase_price_var_account%type;

1915: ===================|=================|====================|=======================|
1916:
1917: */
1918:
1919: ln_ppv_account_id mtl_parameters.purchase_price_var_account%type;
1920: ln_credit_amount NUMBER;
1921: ln_debit_amount NUMBER;
1922:
1923: lv_source VARCHAR2(30); --File.Sql.35 Cbabu := 'Inventory India';

Line 2350: FROM mtl_parameters

2346:
2347: lv_debug varchar2(1); --File.Sql.35 Cbabu := 'Y';
2348: cursor c_ppv_account(cp_organization_id IN NUMBER) is
2349: SELECT purchase_price_var_account
2350: FROM mtl_parameters
2351: WHERE organization_id = cp_organization_id;
2352:
2353: ln_ppv_account_id NUMBER;
2354: