DBA Data[Home] [Help]

APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on RCV_SUPPLY

Line 560: from rcv_supply rs

556: if p_lpn is null then
557: if (p_txn_source_id <> fnd_api.g_miss_num) then
558: begin
559: select lpn_id into l_lpn_id_chk
560: from rcv_supply rs
561: where rs.rcv_transaction_id = p_txn_source_id
562: and rs.lpn_id is null;
563: exception
564: when others then

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