DBA Data[Home] [Help]

APPS.JAI_MTL_TRXS_PKG dependencies on RCV_PARAMETERS

Line 1465: FROM rcv_parameters

1461: WHERE transaction_temp_id = p_transaction_temp_id;
1462:
1463: CURSOR c_rcv_params (p_organization_id IN NUMBER) IS
1464: select receiving_account_id
1465: FROM rcv_parameters
1466: WHERE organization_id = p_organization_id;
1467:
1468: CURSOR c_org_code(p_org_id IN NUMBER) IS
1469: SELECT organization_code

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

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

Line 2692: SELECT * from rcv_parameters

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
2692: SELECT * from rcv_parameters
2693: WHERE organization_id = cp_organization_id;
2694:
2695: CURSOR c_mtl_params(cp_organization_id IN NUMBER) IS
2696: SELECT *

Line 3283: from rcv_parameters

3279:
3280: cursor cur_rcv_accnt(cp_organization_id NUMBER) /*6487489..added the cursor*/
3281: IS
3282: select receiving_account_id
3283: from rcv_parameters
3284: Where organization_id = cp_organization_id;
3285:
3286: ln_receiving_accnt_id NUMBER;
3287: