DBA Data[Home] [Help]

APPS.INV_RCV_STD_TRANSFER_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 2806: SELECT mtl_material_transactions_s.NEXTVAL

2802: END;
2803:
2804: IF (l_txn_if_id IS NULL) THEN
2805: BEGIN
2806: SELECT mtl_material_transactions_s.NEXTVAL
2807: INTO l_txn_if_id
2808: FROM sys.dual;
2809: EXCEPTION
2810: WHEN OTHERS THEN

Line 3701: select mtl_material_transactions_s.nextval

3697: IF p_lot_control_code = 2 AND l_lot_num <> '@$#_' THEN -- bug 14269755 IF (p_lot_number IS NOT NULL) THEN
3698:
3699: -- Generate the Serial Txn Temp Id
3700:
3701: select mtl_material_transactions_s.nextval
3702: into l_ser_txn_temp_id from dual;
3703:
3704: l_rti_tb(l_txn_id)(l_lot_num).lot_number := l_serial_rec.lot_num;
3705: l_rti_tb(l_txn_id)(l_lot_num).serial_intf_id := l_ser_txn_temp_id;

Line 3815: select mtl_material_transactions_s.nextval

3811: IF p_lot_control_code = 2 AND l_lot_num <> '@$#_' THEN -- bug 14269755 IF (p_lot_number IS NOT NULL) THEN
3812:
3813: -- Generate the Serial Txn Temp Id
3814:
3815: select mtl_material_transactions_s.nextval
3816: into l_ser_txn_temp_id from dual;
3817:
3818: l_rti_tb(l_txn_id)(l_lot_num).lot_number := l_serial_rec.lot_num;
3819: l_rti_tb(l_txn_id)(l_lot_num).serial_intf_id := l_ser_txn_temp_id;