APPS.INV_LPN_TRX_PUB dependencies on DUAL

Line 201: FROM DUAL;

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;
204: v_mmtt_rec.subinventory_code := v_subinv;
205: v_mmtt_rec.locator_id := v_locatorid;

Line 2417: FROM DUAL;

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
2420: inv_log_util.TRACE('Created new trxtmpid=' || l_invpcinrectype.transaction_temp_id || ' ser_tbl.count=' || l_split_quantity
2421: , l_api_name, 9);

Line 3572: FROM DUAL

3568: IF (wms_install.g_wms_installation_status = 'I') THEN
3569: BEGIN
3570: SELECT 1
3571: INTO l_is_cartonization
3572: FROM DUAL
3573: WHERE EXISTS(
3574: SELECT 1
3575: FROM mtl_material_transactions_temp
3576: WHERE transaction_action_id = inv_globals.g_action_containerpack

Line 4662: FROM DUAL

4658:
4659: BEGIN
4660: SELECT 1
4661: INTO l_is_from_mti
4662: FROM DUAL
4663: WHERE EXISTS(SELECT 1
4664: FROM mtl_material_transactions_temp
4665: WHERE transaction_header_id = p_trx_hdr_id
4666: AND transaction_mode = inv_txn_manager_pub.proc_mode_mti);