APPS.WMS_LPN_LOVS dependencies on WSH_DELIVERY_ASSIGNMENTS_V

Line 4101: , wsh_delivery_assignments_v wda

4097: SELECT distinct wlpn.license_plate_number
4098: , wlpn.lpn_id
4099: , count_row.n
4100: FROM wsh_delivery_details_ob_grp_v wdd
4101: , wsh_delivery_assignments_v wda
4102: , wsh_delivery_details_ob_grp_v wdd1
4103: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4104: FROM wsh_delivery_details_ob_grp_v wdd
4105: , wms_license_plate_numbers wlpn

Line 4107: FROM wsh_delivery_assignments_v wda

4103: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4104: FROM wsh_delivery_details_ob_grp_v wdd
4105: , wms_license_plate_numbers wlpn
4106: WHERE wdd.lpn_id in (SELECT wdd.lpn_id
4107: FROM wsh_delivery_assignments_v wda
4108: , wsh_delivery_details_ob_grp_v wdd
4109: WHERE wda.delivery_detail_id in (select delivery_detail_id
4110: FROM wsh_delivery_details_ob_grp_v
4111: WHERE source_header_id = l_order_header_id)

Line 4130: , wsh_delivery_assignments_v wda

4126: SELECT distinct wlpn.license_plate_number
4127: , wlpn.lpn_id
4128: , count_row.n
4129: FROM wsh_delivery_details_ob_grp_v wdd
4130: , wsh_delivery_assignments_v wda
4131: , wsh_delivery_details_ob_grp_v wdd1
4132: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4133: FROM wsh_delivery_details_ob_grp_v wdd
4134: , wms_license_plate_numbers wlpn

Line 4136: FROM wsh_delivery_assignments_v wda

4132: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4133: FROM wsh_delivery_details_ob_grp_v wdd
4134: , wms_license_plate_numbers wlpn
4135: WHERE wdd.lpn_id in (SELECT wdd.lpn_id
4136: FROM wsh_delivery_assignments_v wda
4137: , wsh_delivery_details_ob_grp_v wdd
4138: WHERE wda.delivery_detail_id in (select delivery_detail_id
4139: FROM wsh_delivery_details_ob_grp_v
4140: WHERE source_header_id = l_order_header_id)

Line 4177: , wsh_delivery_assignments_v wda

4173: SELECT distinct wlpn.license_plate_number
4174: , wlpn.lpn_id
4175: , count_row.n
4176: FROM wsh_delivery_details_ob_grp_v wdd
4177: , wsh_delivery_assignments_v wda
4178: , wsh_delivery_details_ob_grp_v wdd1
4179: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4180: FROM wsh_delivery_details_ob_grp_v wdd
4181: , wms_license_plate_numbers wlpn

Line 4183: FROM wsh_delivery_assignments_v wda

4179: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4180: FROM wsh_delivery_details_ob_grp_v wdd
4181: , wms_license_plate_numbers wlpn
4182: WHERE wdd.lpn_id in (SELECT wdd.lpn_id
4183: FROM wsh_delivery_assignments_v wda
4184: , wsh_delivery_details_ob_grp_v wdd
4185: WHERE wda.delivery_detail_id in (select delivery_detail_id
4186: FROM wsh_delivery_details_ob_grp_v
4187: WHERE source_header_id = l_order_header_id)

Line 4212: , wsh_delivery_assignments_v wda

4208: SELECT distinct wlpn.license_plate_number
4209: , wlpn.lpn_id
4210: , count_row.n
4211: FROM wsh_delivery_details_ob_grp_v wdd
4212: , wsh_delivery_assignments_v wda
4213: , wsh_delivery_details_ob_grp_v wdd1
4214: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4215: FROM wsh_delivery_details_ob_grp_v wdd
4216: , wms_license_plate_numbers wlpn

Line 4218: FROM wsh_delivery_assignments_v wda

4214: , wms_license_plate_numbers wlpn, (SELECT count(*) n
4215: FROM wsh_delivery_details_ob_grp_v wdd
4216: , wms_license_plate_numbers wlpn
4217: WHERE wdd.lpn_id in (SELECT wdd.lpn_id
4218: FROM wsh_delivery_assignments_v wda
4219: , wsh_delivery_details_ob_grp_v wdd
4220: WHERE wda.delivery_detail_id in (select delivery_detail_id
4221: FROM wsh_delivery_details_ob_grp_v
4222: WHERE source_header_id = l_order_header_id)