APPS.JAI_RCV_DELIVER_RTR_PKG dependencies on MTL_PARAMETERS

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

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;
135:
136: /* Record Declarations */
137: r_trx c_trx%rowtype;

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

Line 1755: ln_ppv_account_id mtl_parameters.purchase_price_var_account%type;

1751: ===================|=================|====================|=======================|
1752:
1753: */
1754:
1755: ln_ppv_account_id mtl_parameters.purchase_price_var_account%type;
1756: ln_credit_amount NUMBER;
1757: ln_debit_amount NUMBER;
1758:
1759: lv_source VARCHAR2(30); --File.Sql.35 Cbabu := 'Inventory India';

Line 2186: FROM mtl_parameters

2182:
2183: lv_debug varchar2(1); --File.Sql.35 Cbabu := 'Y';
2184: cursor c_ppv_account(cp_organization_id IN NUMBER) is
2185: SELECT purchase_price_var_account
2186: FROM mtl_parameters
2187: WHERE organization_id = cp_organization_id;
2188:
2189: ln_ppv_account_id NUMBER;
2190: