DBA Data[Home] [Help]

APPS.INV_LPN_TRX_PUB dependencies on DUAL

Line 218: FROM DUAL;

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

Line 2642: FROM DUAL;

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

Line 3859: FROM DUAL

3855: IF (wms_install.g_wms_installation_status = 'I') THEN
3856: BEGIN
3857: SELECT 1
3858: INTO l_is_cartonization
3859: FROM DUAL
3860: WHERE EXISTS(
3861: SELECT 1
3862: FROM mtl_material_transactions_temp
3863: WHERE transaction_action_id = inv_globals.g_action_containerpack

Line 5162: FROM DUAL

5158:
5159: BEGIN
5160: SELECT 1
5161: INTO l_is_from_mti
5162: FROM DUAL
5163: WHERE EXISTS(SELECT 1
5164: FROM mtl_material_transactions_temp
5165: WHERE transaction_header_id = p_trx_hdr_id
5166: AND transaction_mode = inv_txn_manager_pub.proc_mode_mti);