[Home] [Help]
1373:
1374:
1375: select count(*)
1376: into l_rows
1377: from rcv_shipment_lines rsl, rcv_transactions rt,
1378: mtl_transaction_lot_numbers mtln
1379: where rsl.shipment_line_id = rt.shipment_line_id
1380: and rt.transaction_type = 'RECEIVE'
1381: and rt.transaction_id = mtln.PRODUCT_TRANSACTION_ID
1384: and mtln.LOT_NUMBER is not null;
1385:
1386: select count(*)
1387: into l_temp
1388: from rcv_shipment_lines rsl, rcv_lots_supply rcvls, mtl_lot_numbers mln
1389: where rsl.SHIPMENT_LINE_ID= rcvls.SHIPMENT_LINE_ID
1390: and rsl.to_organization_id = mln.ORGANIZATION_ID
1391: and rsl.ITEM_ID = mln.INVENTORY_ITEM_ID
1392: and rcvls.LOT_NUM = mln.LOT_NUMBER
1417:
1418: /*only for S*/
1419: select count(*)
1420: into l_rows
1421: from rcv_shipment_lines rsl, rcv_transactions rt,
1422: mtl_unit_transactions mut
1423: where rsl.shipment_line_id = rt.shipment_line_id
1424: and rt.transaction_type = 'RECEIVE'
1425: and rt.transaction_id = mut.PRODUCT_TRANSACTION_ID
1428: and mut.SERIAL_NUMBER is not null;
1429:
1430: select count(*)
1431: into l_temp
1432: from rcv_serials_supply rss, rcv_shipment_lines rsl,
1433: mtl_serial_numbers msn
1434: where rsl.SHIPMENT_LINE_ID = rss.SHIPMENT_LINE_ID
1435: and rsl.to_organization_id = msn.CURRENT_ORGANIZATION_ID
1436: and rsl.ITEM_ID = msn.INVENTORY_ITEM_ID
1465: /*only for S*/
1466:
1467: select count(*)
1468: into l_rows
1469: from rcv_shipment_lines rsl, po_headers_all poh, po_releases_all por,
1470: wms_license_plate_numbers wlpn, po_line_locations_all pll
1471: where rsl.po_header_id = poh.po_header_id
1472: and rsl.po_release_id = por.po_release_id(+)
1473: and rsl.ASN_LPN_ID = wlpn.LPN_ID