DBA Data[Home] [Help]

APPS.JAI_MTL_TRXS_PKG dependencies on MTL_INTERORG_PARAMETERS

Line 1292: p_params(i).debit_account, -- Derived Value from JAI_CMN_INVENTORY_ORGS / mtl_interorg_parameters

1288: 'A',
1289: null,
1290: p_params(i).amount,
1291: sysdate,
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

Line 1352: p_params(i).debit_account, -- Derived Value from JAI_CMN_INVENTORY_ORGS / mtl_interorg_parameters

1348: fnd_global.user_id,
1349: null,
1350: p_params(i).amount,
1351: sysdate,
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

Line 1557: ccids from mtl interorg parameters

1553: r_from_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;
1554: r_to_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;
1555:
1556: /*
1557: ccids from mtl interorg parameters
1558: */
1559: r_mtl_interorg mtl_interorg_parameters%rowtype;
1560:
1561: /*

Line 1559: r_mtl_interorg mtl_interorg_parameters%rowtype;

1555:
1556: /*
1557: ccids from mtl interorg parameters
1558: */
1559: r_mtl_interorg mtl_interorg_parameters%rowtype;
1560:
1561: /*
1562: cc id of inventory recvng accnt
1563: */

Line 1583: FROM mtl_interorg_parameters

1579: AND location_id = p_location_id;
1580:
1581: CURSOR c_get_interorg_params( p_from_organization_id IN NUMBER, p_to_organization_id IN NUMBER ) IS
1582: SELECT *
1583: FROM mtl_interorg_parameters
1584: WHERE from_organization_id = p_from_organization_id
1585: AND to_organization_id = p_to_organization_id ;
1586:
1587: CURSOR c_get_trx_info IS

Line 1668: 3. get the accounts FROM mtl_interorg_parameters based ON FROM org AND TO org

1664:
1665: /*
1666: 1. get the FROM location
1667: 2. get the accounts FROM ja_in_hr_organization units FOR FROM org AND TO org
1668: 3. get the accounts FROM mtl_interorg_parameters based ON FROM org AND TO org
1669: 4. get the inventory recvng accnt FROM rcv_parameters
1670: */
1671:
1672: stmt_name := 'Opening c_get_location';

Line 2882: FROM mtl_interorg_parameters

2878:
2879: CURSOR c_ppv_acct(cp_from_organization_id NUMBER,cp_to_organization_id NUMBER)
2880: IS
2881: SELECT INTERORG_PRICE_VAR_ACCOUNT
2882: FROM mtl_interorg_parameters
2883: WHERE from_organization_id = cp_from_organization_id
2884: AND to_organization_id = cp_to_organization_id ;
2885:
2886: CURSOR cur_get_bonded(cp_organization_id NUMBER,