APPS.JAI_MTL_TRXS_PKG dependencies on MTL_PARAMETERS

Line 1296: p_params(i).organization_code, -- From mtl_parameters

1292: p_params(i).debit_account, -- Derived Value from JAI_CMN_INVENTORY_ORGS / mtl_interorg_parameters
1293: null,
1294: null,
1295: null,
1296: p_params(i).organization_code, -- From mtl_parameters
1297: 'India Localization Entry for Interorg-XFER ',
1298: 'jai_mtl_trx_pkg.do_cenvat_Acctg',
1299: 'jai_mtl_trxs',
1300: p_transaction_temp_id,

Line 1356: p_params(i).organization_code, -- From mtl_parameters

1352: p_params(i).debit_account, -- Derived Value from JAI_CMN_INVENTORY_ORGS / mtl_interorg_parameters
1353: null,
1354: null,
1355: null,
1356: p_params(i).organization_code, -- From mtl_parameters
1357: 'India Localization Entry for Interorg-XFER ',
1358: 'jai_mtl_trx_pkg.do_cenvat_Acctg',
1359: 'jai_mtl_trxs',
1360: p_transaction_temp_id,

Line 1598: FROM mtl_parameters

1594: WHERE organization_id = p_organization_id;
1595:
1596: CURSOR c_org_code(p_org_id IN NUMBER) IS
1597: SELECT organization_code
1598: FROM mtl_parameters
1599: WHERE organization_id = p_org_id;
1600:
1601: CURSOR c_item_class (cp_inv_item_id IN NUMBER , cp_orgn_id IN NUMBER) IS
1602: select item_class

Line 1613: l_from_org_cd mtl_parameters.organization_code%TYPE;

1609:
1610: r_mtl_trx_info c_get_trx_info%ROWTYPE;
1611: r_rcv_params c_rcv_params%ROWTYPE;
1612: r_get_interorg_params c_get_interorg_params%ROWTYPE;
1613: l_from_org_cd mtl_parameters.organization_code%TYPE;
1614: l_to_org_cd mtl_parameters.organization_code%TYPE;
1615: l_regime_id NUMBER;
1616:
1617: lv_process_flag VARCHAR2(20);

Line 1614: l_to_org_cd mtl_parameters.organization_code%TYPE;

1610: r_mtl_trx_info c_get_trx_info%ROWTYPE;
1611: r_rcv_params c_rcv_params%ROWTYPE;
1612: r_get_interorg_params c_get_interorg_params%ROWTYPE;
1613: l_from_org_cd mtl_parameters.organization_code%TYPE;
1614: l_to_org_cd mtl_parameters.organization_code%TYPE;
1615: l_regime_id NUMBER;
1616:
1617: lv_process_flag VARCHAR2(20);
1618: lv_process_message VARCHAR2(2000);

Line 2851: FROM mtl_parameters mp

2847: WHERE transaction_type_name = cp_transaction_type_name;
2848:
2849: CURSOR c_costing_group ( cp_organization_id IN NUMBER) IS
2850: SELECT mp.default_cost_group_id
2851: FROM mtl_parameters mp
2852: WHERE mp.organization_id = cp_organization_id
2853: AND mp.primary_cost_method = 2; --Average
2854:
2855: CURSOR c_rcv_params( cp_organization_id IN NUMBER) IS

Line 2861: FROM mtl_parameters

2857: WHERE organization_id = cp_organization_id;
2858:
2859: CURSOR c_mtl_params(cp_organization_id IN NUMBER) IS
2860: SELECT *
2861: FROM mtl_parameters
2862: WHERE organization_id = cp_organization_id;
2863:
2864: CURSOR c_jai_mtl_Trxs ( cp_Trx_temp_id IN NUMBER ) is
2865: SELECT * from jai_mtl_Trxs

Line 3745: SELECT * from mtl_parameters

3741: SELECT vendor_id , vendor_site_id , transaction_id , shipment_line_id from rcv_transactions
3742: WHERE transaction_id = cp_transaction_id;
3743:
3744: CURSOR c_mtl_params(cp_organization_id IN NUMBER) IS
3745: SELECT * from mtl_parameters
3746: WHERE organization_id = cp_organization_id;
3747:
3748: CURSOR c_cenvat_accts (cp_organization_id IN NUMBER , cp_location_id IN NUMBER) IS
3749: select *