4098: SELECT distinct wlpn.license_plate_number
4099: , wlpn.lpn_id
4100: , count_row.n
4101: FROM wsh_delivery_details_ob_grp_v wdd
4102: , wsh_delivery_assignments_v wda
4103: , wsh_delivery_details_ob_grp_v wdd1
4104: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4105: FROM wsh_delivery_details_ob_grp_v wdd
4106: , wms_license_plate_numbers wlpn
4104: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4105: FROM wsh_delivery_details_ob_grp_v wdd
4106: , wms_license_plate_numbers wlpn
4107: WHERE wdd.lpn_id in (SELECT wdd.lpn_id
4108: FROM wsh_delivery_assignments_v wda
4109: , wsh_delivery_details_ob_grp_v wdd
4110: WHERE wda.delivery_detail_id in (select delivery_detail_id
4111: FROM wsh_delivery_details_ob_grp_v
4112: WHERE source_header_id = l_order_header_id)
4127: SELECT distinct wlpn.license_plate_number
4128: , wlpn.lpn_id
4129: , count_row.n
4130: FROM wsh_delivery_details_ob_grp_v wdd
4131: , wsh_delivery_assignments_v wda
4132: , wsh_delivery_details_ob_grp_v wdd1
4133: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4134: FROM wsh_delivery_details_ob_grp_v wdd
4135: , wms_license_plate_numbers wlpn
4133: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4134: FROM wsh_delivery_details_ob_grp_v wdd
4135: , wms_license_plate_numbers wlpn
4136: WHERE wdd.lpn_id in (SELECT wdd.lpn_id
4137: FROM wsh_delivery_assignments_v wda
4138: , wsh_delivery_details_ob_grp_v wdd
4139: WHERE wda.delivery_detail_id in (select delivery_detail_id
4140: FROM wsh_delivery_details_ob_grp_v
4141: WHERE source_header_id = l_order_header_id)
4174: SELECT distinct wlpn.license_plate_number
4175: , wlpn.lpn_id
4176: , count_row.n
4177: FROM wsh_delivery_details_ob_grp_v wdd
4178: , wsh_delivery_assignments_v wda
4179: , wsh_delivery_details_ob_grp_v wdd1
4180: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4181: FROM wsh_delivery_details_ob_grp_v wdd
4182: , wms_license_plate_numbers wlpn
4180: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4181: FROM wsh_delivery_details_ob_grp_v wdd
4182: , wms_license_plate_numbers wlpn
4183: WHERE wdd.lpn_id in (SELECT wdd.lpn_id
4184: FROM wsh_delivery_assignments_v wda
4185: , wsh_delivery_details_ob_grp_v wdd
4186: WHERE wda.delivery_detail_id in (select delivery_detail_id
4187: FROM wsh_delivery_details_ob_grp_v
4188: WHERE source_header_id = l_order_header_id)
4209: SELECT distinct wlpn.license_plate_number
4210: , wlpn.lpn_id
4211: , count_row.n
4212: FROM wsh_delivery_details_ob_grp_v wdd
4213: , wsh_delivery_assignments_v wda
4214: , wsh_delivery_details_ob_grp_v wdd1
4215: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4216: FROM wsh_delivery_details_ob_grp_v wdd
4217: , wms_license_plate_numbers wlpn
4215: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4216: FROM wsh_delivery_details_ob_grp_v wdd
4217: , wms_license_plate_numbers wlpn
4218: WHERE wdd.lpn_id in (SELECT wdd.lpn_id
4219: FROM wsh_delivery_assignments_v wda
4220: , wsh_delivery_details_ob_grp_v wdd
4221: WHERE wda.delivery_detail_id in (select delivery_detail_id
4222: FROM wsh_delivery_details_ob_grp_v
4223: WHERE source_header_id = l_order_header_id)