APPS.WMS_TASK_DISPATCH_PUT_AWAY dependencies on RCV_SERIALS_SUPPLY

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 4400: * fetches the serial by matches the serials in rcv_serials_supply for

4396: -- ER 7307189 changes end
4397: /*
4398: * If the MOL LPN context is "RESIDES IN RECEIVING" and INV and PO Patch
4399: * levels are J or higher, then open the cursor c_rcv_ser_csr that
4400: * fetches the serial by matches the serials in rcv_serials_supply for
4401: * the parent transaction.
4402: * If either of these is not true, then open the original cursor
4403: */
4404: IF (l_lpn_context = 3) THEN

Line 4633: * fetches the serial by matches the serials in rcv_serials_supply for

4629:
4630: /* FP-J Lot/Serial Support Enhancement
4631: * If the MOL LPN context is "RESIDES IN RECEIVING" and INV and PO Patch
4632: * levels are J or higher, then open the cursor c_rcv_ser_csr that
4633: * fetches the serial by matches the serials in rcv_serials_supply for
4634: * the parent transaction
4635: * If either of these is not true, then open the original cursor
4636: */
4637: IF (l_lpn_context = 3) THEN

Line 4856: * serials in RCV_SERIALS_SUPPLY for the parent transaction

4852: * If the MOL LPN context is "RESIDES IN RECEIVING" and INV and PO Patch
4853: * levels are J or higher then MSNI records would have been created before
4854: * calling complete_putaway, one per serial number.
4855: * Over here we need to match the serials confirmed in the UI against the
4856: * serials in RCV_SERIALS_SUPPLY for the parent transaction
4857: * Get the parent transaction from the current MOL and check for serials
4858: * that exist in MSNI but not in RCV_SERIALS_SUPPLY. If at least one such
4859: * serial is found, then error out the transaction since match failed
4860: */

Line 4858: * that exist in MSNI but not in RCV_SERIALS_SUPPLY. If at least one such

4854: * calling complete_putaway, one per serial number.
4855: * Over here we need to match the serials confirmed in the UI against the
4856: * serials in RCV_SERIALS_SUPPLY for the parent transaction
4857: * Get the parent transaction from the current MOL and check for serials
4858: * that exist in MSNI but not in RCV_SERIALS_SUPPLY. If at least one such
4859: * serial is found, then error out the transaction since match failed
4860: */
4861: IF (l_lpn_context = 3) THEN
4862: