DBA Data[Home] [Help]

APPS.INV_RCV_STD_DELIVER_APIS dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 5197: SELECT mtl_material_transactions_s.NEXTVAL

5193: AND organization_id = p_org_id;
5194:
5195: IF (l_txn_if_id IS NULL) THEN
5196: BEGIN
5197: SELECT mtl_material_transactions_s.NEXTVAL
5198: INTO l_txn_if_id
5199: FROM sys.dual;
5200: EXCEPTION
5201: WHEN OTHERS THEN

Line 6004: select mtl_material_transactions_s.nextval

6000: IF (p_lot_number IS NOT NULL) THEN
6001:
6002: -- Generate the Serial Txn Temp Id
6003:
6004: select mtl_material_transactions_s.nextval
6005: into l_ser_txn_temp_id from dual;
6006:
6007: l_rti_tb(l_txn_id)(l_lot_num).lot_number := l_serial_rec.lot_num;
6008: l_rti_tb(l_txn_id)(l_lot_num).serial_intf_id := l_ser_txn_temp_id;