APPS.WMS_RCV_PUP_PVT dependencies on DUAL

Line 408: FROM dual;

404:
405: /* Create a dummy RT ID */
406: SELECT rcv_transactions_interface_s.NEXTVAL
407: INTO l_intf_id
408: FROM dual;
409:
410: inv_rcv_integration_apis.insert_mtli
411: (p_api_version => 1.0
412: ,x_return_status => x_return_status

Line 621: FROM dual;

617: IF (l_intf_id IS NULL) THEN
618: /* Create a dummy RT ID */
619: SELECT rcv_transactions_interface_s.NEXTVAL
620: INTO l_intf_id
621: FROM dual;
622: END IF;
623:
624: inv_rcv_integration_apis.insert_msni
625: (p_api_version => 1.0

Line 2310: FROM dual;

2306:
2307: /* Create a dummy RT ID */
2308: SELECT rcv_transactions_interface_s.NEXTVAL
2309: INTO l_new_intf_id
2310: FROM dual;
2311:
2312: l_progress := '6.2.7';
2313:
2314: /* Split lot serial */

Line 2542: FROM dual

2538:
2539: BEGIN
2540: SELECT 1
2541: INTO l_xfer_lpn_loaded
2542: FROM dual
2543: WHERE EXISTS (SELECT /*+ INDEX (wdt, WMS_DISPATCHED_TASKS_U2) */ 'LOADED' --Bug#8555935 Changed index WMS_DISPATCHED_TASKS_N2 to WMS_DISPATCHED_TASKS_U2
2544: FROM mtl_material_transactions_temp mmtt,
2545: wms_dispatched_tasks wdt
2546: WHERE mmtt.organization_id = l_tmp_mmtt_rec.organization_id

Line 2873: FROM dual;

2869:
2870: /* Create a dummy RT ID */
2871: SELECT rcv_transactions_interface_s.NEXTVAL
2872: INTO l_new_intf_id
2873: FROM dual;
2874: l_progress := '7.2.7';
2875:
2876: /* Split lot serial */
2877: l_rti_tb.DELETE;