APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on RCV_TRANSACTIONS

Line 644: FROM rcv_serials_supply rss, rcv_supply rs , rcv_transactions rt , rcv_lots_supply rls, mtl_system_items msi -- for bug 14192301 added msi table

640: END IF;
641: --13722443
642: SELECT COUNT(distinct(rss.serial_num))
643: INTO l_serial_count
644: FROM rcv_serials_supply rss, rcv_supply rs , rcv_transactions rt , rcv_lots_supply rls, mtl_system_items msi -- for bug 14192301 added msi table
645: WHERE rs.rcv_transaction_id = rss.transaction_id
646: AND rs.rcv_transaction_id = rt.transaction_id
647: AND rt.inspection_status_code = l_inspection_status_code
648: AND rs.shipment_line_id = rss.shipment_line_id

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)