APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on RCV_TRANSACTIONS_INTERFACE

Line 4333: SELECT rcv_transactions_interface_s.NEXTVAL

4329: mydebug('complete_putaway: p_product_transaction_id: inside lot_serial' || l_product_transaction_id);
4330: END IF;
4331:
4332: IF l_product_transaction_id IS NULL THEN
4333: SELECT rcv_transactions_interface_s.NEXTVAL
4334: INTO l_product_transaction_id
4335: FROM sys.dual;
4336: END IF;
4337:

Line 4724: SELECT rcv_transactions_interface_s.NEXTVAL

4720: mydebug('complete_putaway: Inserting MSNI - serial controlled only' || p_temp_id);
4721: END IF;
4722:
4723: IF l_product_transaction_id IS NULL THEN
4724: SELECT rcv_transactions_interface_s.NEXTVAL
4725: INTO l_product_transaction_id
4726: FROM sys.dual;
4727: END IF;
4728:

Line 6141: FROM rcv_transactions_interface

6137:
6138: BEGIN
6139: SELECT 1
6140: INTO l_rti_cnt
6141: FROM rcv_transactions_interface
6142: WHERE (transfer_lpn_id IN (SELECT lpn_id
6143: FROM wms_license_plate_numbers
6144: START WITH lpn_id = l_lpn_id
6145: CONNECT BY PRIOR lpn_id = parent_lpn_id)