DBA Data[Home] [Help]

APPS.INV_RCV_STD_DELIVER_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 5319: SELECT mtl_material_transactions_s.NEXTVAL

5315: AND organization_id = p_org_id;
5316:
5317: IF (l_txn_if_id IS NULL) THEN
5318: BEGIN
5319: SELECT mtl_material_transactions_s.NEXTVAL
5320: INTO l_txn_if_id
5321: FROM sys.dual;
5322: EXCEPTION
5323: WHEN OTHERS THEN

Line 6147: select mtl_material_transactions_s.nextval

6143: IF (p_lot_number IS NOT NULL) THEN
6144:
6145: -- Generate the Serial Txn Temp Id
6146:
6147: select mtl_material_transactions_s.nextval
6148: into l_ser_txn_temp_id from dual;
6149:
6150: l_rti_tb(l_txn_id)(l_lot_num).lot_number := l_serial_rec.lot_num;
6151: l_rti_tb(l_txn_id)(l_lot_num).serial_intf_id := l_ser_txn_temp_id;