APPS.JAI_MTL_TRXS_PKG dependencies on MTL_PARAMETERS

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

1164: p_params(i).debit_account, -- Derived Value from JAI_CMN_INVENTORY_ORGS / mtl_interorg_parameters
1165: null,
1166: null,
1167: null,
1168: p_params(i).organization_code, -- From mtl_parameters
1169: 'India Localization Entry for Interorg-XFER ',
1170: 'jai_mtl_trx_pkg.do_cenvat_Acctg',
1171: 'jai_mtl_trxs',
1172: p_transaction_temp_id,

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

1224: p_params(i).debit_account, -- Derived Value from JAI_CMN_INVENTORY_ORGS / mtl_interorg_parameters
1225: null,
1226: null,
1227: null,
1228: p_params(i).organization_code, -- From mtl_parameters
1229: 'India Localization Entry for Interorg-XFER ',
1230: 'jai_mtl_trx_pkg.do_cenvat_Acctg',
1231: 'jai_mtl_trxs',
1232: p_transaction_temp_id,

Line 1470: FROM mtl_parameters

1466: WHERE organization_id = p_organization_id;
1467:
1468: CURSOR c_org_code(p_org_id IN NUMBER) IS
1469: SELECT organization_code
1470: FROM mtl_parameters
1471: WHERE organization_id = p_org_id;
1472:
1473: CURSOR c_item_class (cp_inv_item_id IN NUMBER , cp_orgn_id IN NUMBER) IS
1474: select item_class

Line 1485: l_from_org_cd mtl_parameters.organization_code%TYPE;

1481:
1482: r_mtl_trx_info c_get_trx_info%ROWTYPE;
1483: r_rcv_params c_rcv_params%ROWTYPE;
1484: r_get_interorg_params c_get_interorg_params%ROWTYPE;
1485: l_from_org_cd mtl_parameters.organization_code%TYPE;
1486: l_to_org_cd mtl_parameters.organization_code%TYPE;
1487: l_regime_id NUMBER;
1488:
1489: lv_process_flag VARCHAR2(20);

Line 1486: l_to_org_cd mtl_parameters.organization_code%TYPE;

1482: r_mtl_trx_info c_get_trx_info%ROWTYPE;
1483: r_rcv_params c_rcv_params%ROWTYPE;
1484: r_get_interorg_params c_get_interorg_params%ROWTYPE;
1485: l_from_org_cd mtl_parameters.organization_code%TYPE;
1486: l_to_org_cd mtl_parameters.organization_code%TYPE;
1487: l_regime_id NUMBER;
1488:
1489: lv_process_flag VARCHAR2(20);
1490: lv_process_message VARCHAR2(2000);

Line 2687: FROM mtl_parameters mp

2683: WHERE transaction_type_name = cp_transaction_type_name;
2684:
2685: CURSOR c_costing_group ( cp_organization_id IN NUMBER) IS
2686: SELECT mp.default_cost_group_id
2687: FROM mtl_parameters mp
2688: WHERE mp.organization_id = cp_organization_id
2689: AND mp.primary_cost_method = 2; --Average
2690:
2691: CURSOR c_rcv_params( cp_organization_id IN NUMBER) IS

Line 2697: FROM mtl_parameters

2693: WHERE organization_id = cp_organization_id;
2694:
2695: CURSOR c_mtl_params(cp_organization_id IN NUMBER) IS
2696: SELECT *
2697: FROM mtl_parameters
2698: WHERE organization_id = cp_organization_id;
2699:
2700: CURSOR c_jai_mtl_Trxs ( cp_Trx_temp_id IN NUMBER ) is
2701: SELECT * from jai_mtl_Trxs

Line 3581: SELECT * from mtl_parameters

3577: SELECT vendor_id , vendor_site_id , transaction_id , shipment_line_id from rcv_transactions
3578: WHERE transaction_id = cp_transaction_id;
3579:
3580: CURSOR c_mtl_params(cp_organization_id IN NUMBER) IS
3581: SELECT * from mtl_parameters
3582: WHERE organization_id = cp_organization_id;
3583:
3584: CURSOR c_cenvat_accts (cp_organization_id IN NUMBER , cp_location_id IN NUMBER) IS
3585: select *