DBA Data[Home] [Help]

APPS.JAI_MTL_TRXS_PKG dependencies on MTL_INTERORG_PARAMETERS

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

1160: 'A',
1161: null,
1162: p_params(i).amount,
1163: sysdate,
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

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

1220: fnd_global.user_id,
1221: null,
1222: p_params(i).amount,
1223: sysdate,
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

Line 1429: ccids from mtl interorg parameters

1425: r_from_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;
1426: r_to_ja_in_hr_org JAI_CMN_INVENTORY_ORGS%rowtype;
1427:
1428: /*
1429: ccids from mtl interorg parameters
1430: */
1431: r_mtl_interorg mtl_interorg_parameters%rowtype;
1432:
1433: /*

Line 1431: r_mtl_interorg mtl_interorg_parameters%rowtype;

1427:
1428: /*
1429: ccids from mtl interorg parameters
1430: */
1431: r_mtl_interorg mtl_interorg_parameters%rowtype;
1432:
1433: /*
1434: cc id of inventory recvng accnt
1435: */

Line 1455: FROM mtl_interorg_parameters

1451: AND location_id = p_location_id;
1452:
1453: CURSOR c_get_interorg_params( p_from_organization_id IN NUMBER, p_to_organization_id IN NUMBER ) IS
1454: SELECT *
1455: FROM mtl_interorg_parameters
1456: WHERE from_organization_id = p_from_organization_id
1457: AND to_organization_id = p_to_organization_id ;
1458:
1459: CURSOR c_get_trx_info IS

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

1536:
1537: /*
1538: 1. get the FROM location
1539: 2. get the accounts FROM ja_in_hr_organization units FOR FROM org AND TO org
1540: 3. get the accounts FROM mtl_interorg_parameters based ON FROM org AND TO org
1541: 4. get the inventory recvng accnt FROM rcv_parameters
1542: */
1543:
1544: stmt_name := 'Opening c_get_location';

Line 2718: FROM mtl_interorg_parameters

2714:
2715: CURSOR c_ppv_acct(cp_from_organization_id NUMBER,cp_to_organization_id NUMBER)
2716: IS
2717: SELECT INTERORG_PRICE_VAR_ACCOUNT
2718: FROM mtl_interorg_parameters
2719: WHERE from_organization_id = cp_from_organization_id
2720: AND to_organization_id = cp_to_organization_id ;
2721:
2722: CURSOR cur_get_bonded(cp_organization_id NUMBER,