APPS.INV_LOT_TRX_VALIDATION_PVT dependencies on MTL_TRANSACTIONS_INTERFACE

Line 197: FROM mtl_transactions_interface

193: , cost_group_id
194: , transfer_cost_group_id
195: , lpn_id
196: , transfer_lpn_id
197: FROM mtl_transactions_interface
198: WHERE parent_id = p_parent_id;
199:
200: CURSOR mtli_csr (p_transaction_interface_id NUMBER)
201: IS

Line 761: UPDATE mtl_transactions_interface

757: END IF;
758:
759:
760:
761: UPDATE mtl_transactions_interface
762: SET transaction_quantity = l_transaction_quantity
763: , primary_quantity = l_primary_quantity
764: WHERE transaction_interface_id = l_transaction_interface_id;
765:

Line 1599: || ' FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI, MTL_TRANSACTIONS_INTERFACE MTI, '

1595: THEN
1596: /*Bug:5354721. Appending FROM clause to the global statement. */
1597: l_select_stmt :=
1598: g_select_stmt
1599: || ' FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI, MTL_TRANSACTIONS_INTERFACE MTI, '
1600: || ' MTL_LOT_NUMBERS MLN '
1601: || ' WHERE mtli.transaction_interface_id = :b_interface_id '
1602: || ' AND mtli.lot_number = :b_lot_number '
1603: || ' AND mtli.transaction_interface_id = mti.transaction_interface_id '

Line 1614: || ' FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI, MTL_TRANSACTIONS_INTERFACE MTI, '

1610: -- parent lot. Passing a new parameter called starting lot
1611: -- which is the lot number of the parent lot.
1612: l_select_stmt :=
1613: g_select_stmt
1614: || ' FROM MTL_TRANSACTION_LOTS_INTERFACE MTLI, MTL_TRANSACTIONS_INTERFACE MTI, '
1615: || ' MTL_LOT_NUMBERS MLN '
1616: || ' WHERE mtli.transaction_interface_id = :b_interface_id '
1617: || ' AND mtli.lot_number = :b_lot_number '
1618: || ' AND mtli.transaction_interface_id = mti.transaction_interface_id '

Line 2286: UPDATE mtl_transactions_interface

2282: RAISE fnd_api.g_exc_error;
2283: ELSE
2284: FOR i IN 1 .. l_rs_interface_id_tbl.COUNT
2285: LOOP
2286: UPDATE mtl_transactions_interface
2287: SET cost_group_id = l_rs_cost_group_id_tbl (i)
2288: WHERE transaction_interface_id = l_rs_interface_id_tbl (i);
2289: END LOOP;
2290: END IF;

Line 3104: UPDATE mtl_transactions_interface

3100: RAISE fnd_api.g_exc_error;
3101: ELSE
3102: FOR i IN 1 .. l_rs_interface_id_tbl.COUNT
3103: LOOP
3104: UPDATE mtl_transactions_interface
3105: SET cost_group_id = l_rs_cost_group_id_tbl (i)
3106: WHERE transaction_interface_id = l_rs_interface_id_tbl (i);
3107: END LOOP;
3108: END IF;

Line 3348: FROM mtl_transactions_interface

3344: ---populate the attributes based on the lot else send the default lot
3345: -- number ****/
3346: SELECT representative_lot_number
3347: INTO l_represenatative_lot
3348: FROM mtl_transactions_interface
3349: WHERE transaction_interface_id = l_st_interface_id_tbl (1);
3350:
3351: IF l_represenatative_lot IS NULL
3352: THEN

Line 3906: UPDATE mtl_transactions_interface

3902: , 'Validate_lot_translate'
3903: );
3904: END IF;
3905:
3906: UPDATE mtl_transactions_interface
3907: SET distribution_account_id = l_distribution_account_id
3908: WHERE transaction_interface_id IN
3909: (l_st_interface_id_tbl (1), l_rs_interface_id_tbl (1));
3910: END IF;

Line 4055: UPDATE mtl_transactions_interface

4051: RAISE fnd_api.g_exc_error;
4052: ELSE
4053: FOR i IN 1 .. l_rs_interface_id_tbl.COUNT
4054: LOOP
4055: UPDATE mtl_transactions_interface
4056: SET cost_group_id = l_rs_cost_group_id_tbl (i)
4057: , distribution_account_id = l_distribution_account_id
4058: WHERE transaction_interface_id = l_rs_interface_id_tbl (i);
4059: END LOOP;