DBA Data[Home] [Help]

APPS.JAI_MTL_TRXS_PKG dependencies on RCV_PARAMETERS

Line 1593: FROM rcv_parameters

1589: WHERE transaction_temp_id = p_transaction_temp_id;
1590:
1591: CURSOR c_rcv_params (p_organization_id IN NUMBER) IS
1592: select receiving_account_id
1593: FROM rcv_parameters
1594: WHERE organization_id = p_organization_id;
1595:
1596: CURSOR c_org_code(p_org_id IN NUMBER) IS
1597: SELECT organization_code

Line 1669: 4. get the inventory recvng accnt FROM rcv_parameters

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';
1673: OPEN c_get_location(r_mtl_trx_info.from_organization , r_mtl_trx_info.from_subinventory);

Line 2856: SELECT * from rcv_parameters

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
2856: SELECT * from rcv_parameters
2857: WHERE organization_id = cp_organization_id;
2858:
2859: CURSOR c_mtl_params(cp_organization_id IN NUMBER) IS
2860: SELECT *

Line 3447: from rcv_parameters

3443:
3444: cursor cur_rcv_accnt(cp_organization_id NUMBER) /*6487489..added the cursor*/
3445: IS
3446: select receiving_account_id
3447: from rcv_parameters
3448: Where organization_id = cp_organization_id;
3449:
3450: ln_receiving_accnt_id NUMBER;
3451: