DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on MTL_MATERIAL_TRANSACTIONS_S

Line 216: SELECT mtl_material_transactions_s.NEXTVAL

212: l_wlc_prim_qty NUMBER; --13591755
213: l_wlc_trx_qty NUMBER;
214:
215: BEGIN
216: SELECT mtl_material_transactions_s.NEXTVAL
217: INTO x_trxtempid
218: FROM DUAL;
219:
220: v_mmtt_rec.transaction_temp_id := x_trxtempid;

Line 2640: SELECT mtl_material_transactions_s.NEXTVAL

2636: -- If not all serials in this detail are part of split. no need to split ranges
2637: IF (l_split_quantity > 0
2638: AND l_split_quantity < dd_rec.requested_quantity) THEN
2639:
2640: SELECT mtl_material_transactions_s.NEXTVAL
2641: INTO l_invpcinrectype.transaction_temp_id
2642: FROM DUAL;
2643:
2644: IF (l_debug = 1) THEN

Line 4270: SET material_allocation_temp_id = mtl_material_transactions_s.NEXTVAL

4266: IF (wip_mtltempproc_grp.istxnidrequired(v_mmtt.transaction_temp_id)) THEN
4267: inv_log_util.TRACE('Going to update mmtt with material_allocation_temp_id', 'INV_LPN_TRX_PUB', 1);
4268:
4269: UPDATE mtl_material_transactions_temp
4270: SET material_allocation_temp_id = mtl_material_transactions_s.NEXTVAL
4271: WHERE transaction_temp_id = v_mmtt.transaction_temp_id;
4272: END IF;
4273: END IF;
4274: