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