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 2268: FROM dual;

2264:
2265: /* Create a dummy RT ID */
2266: SELECT rcv_transactions_interface_s.NEXTVAL
2267: INTO l_new_intf_id
2268: FROM dual;
2269:
2270: l_progress := '6.2.7';
2271:
2272: /* Split lot serial */

Line 2498: FROM dual

2494:
2495: BEGIN
2496: SELECT 1
2497: INTO l_xfer_lpn_loaded
2498: FROM dual
2499: WHERE EXISTS (SELECT /*+ INDEX (wdt, WMS_DISPATCHED_TASKS_N2) */ 'LOADED'
2500: FROM mtl_material_transactions_temp mmtt,
2501: wms_dispatched_tasks wdt
2502: WHERE mmtt.organization_id = l_tmp_mmtt_rec.organization_id

Line 2828: FROM dual;

2824:
2825: /* Create a dummy RT ID */
2826: SELECT rcv_transactions_interface_s.NEXTVAL
2827: INTO l_new_intf_id
2828: FROM dual;
2829: l_progress := '7.2.7';
2830:
2831: /* Split lot serial */
2832: l_rti_tb.DELETE;