APPS.INV_LPN_TRX_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 199: SELECT mtl_material_transactions_s.NEXTVAL

195: l_temp_uom_code VARCHAR(3);
196: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
197: l_sign NUMBER := 1; --Added bug3984746
198: BEGIN
199: SELECT mtl_material_transactions_s.NEXTVAL
200: INTO x_trxtempid
201: FROM DUAL;
202:
203: v_mmtt_rec.transaction_temp_id := x_trxtempid;

Line 2415: SELECT mtl_material_transactions_s.NEXTVAL

2411: l_invpcinrectype.transaction_temp_id := NULL;
2412: l_shipping_attr(1).serial_number := ser_tbl(1);
2413: ELSE
2414: -- More than on serial needs to be split from this MSNT record
2415: SELECT mtl_material_transactions_s.NEXTVAL
2416: INTO l_invpcinrectype.transaction_temp_id
2417: FROM DUAL;
2418:
2419: IF (l_debug = 1) THEN

Line 3983: SET material_allocation_temp_id = mtl_material_transactions_s.NEXTVAL

3979: IF (wip_mtltempproc_grp.istxnidrequired(v_mmtt.transaction_temp_id)) THEN
3980: inv_log_util.TRACE('Going to update mmtt with material_allocation_temp_id', 'INV_LPN_TRX_PUB', 1);
3981:
3982: UPDATE mtl_material_transactions_temp
3983: SET material_allocation_temp_id = mtl_material_transactions_s.NEXTVAL
3984: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
3985: END IF;
3986: END IF;
3987: