eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_LPN_LOVS dependencies on WSH_DELIVERY_DETAILS

Line 4100: FROM wsh_delivery_details_ob_grp_v wdd

4096: OPEN x_lpn_lov FOR
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

Line 4102: , wsh_delivery_details_ob_grp_v wdd1

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
4106: WHERE wdd.lpn_id in (SELECT wdd.lpn_id

Line 4104: FROM wsh_delivery_details_ob_grp_v wdd

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
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

Line 4108: , wsh_delivery_details_ob_grp_v wdd

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)
4112: AND wda.PARENT_DELIVERY_DETAIL_ID = wdd.delivery_detail_id)

Line 4110: FROM wsh_delivery_details_ob_grp_v

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)
4112: AND wda.PARENT_DELIVERY_DETAIL_ID = wdd.delivery_detail_id)
4113: AND wlpn.lpn_context = 6
4114: AND wlpn.organization_id = wdd.organization_id

Line 4129: FROM wsh_delivery_details_ob_grp_v wdd

4125: /* OPEN x_lpn_lov FOR
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

Line 4131: , wsh_delivery_details_ob_grp_v wdd1

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
4135: WHERE wdd.lpn_id in (SELECT wdd.lpn_id

Line 4133: FROM wsh_delivery_details_ob_grp_v wdd

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
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

Line 4137: , wsh_delivery_details_ob_grp_v wdd

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)
4141: AND wda.PARENT_DELIVERY_DETAIL_ID = wdd.delivery_detail_id)

Line 4139: FROM wsh_delivery_details_ob_grp_v

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)
4141: AND wda.PARENT_DELIVERY_DETAIL_ID = wdd.delivery_detail_id)
4142: AND wlpn.lpn_context = 6
4143: AND wlpn.organization_id = wdd.organization_id

Line 4160: wsh_delivery_details_ob_grp_v wdd

4156: SELECT distinct wln.license_plate_number
4157: , wln.lpn_id
4158: , 1
4159: FROM wms_license_plate_numbers wln,
4160: wsh_delivery_details_ob_grp_v wdd
4161: WHERE wln.lpn_context= 6
4162: AND wln.lpn_id = wdd.lpn_id
4163: AND wln.license_plate_number LIKE (p_lpn)
4164: ORDER BY wln.license_plate_number;

Line 4176: FROM wsh_delivery_details_ob_grp_v wdd

4172: OPEN x_lpn_lov FOR
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

Line 4178: , wsh_delivery_details_ob_grp_v wdd1

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
4182: WHERE wdd.lpn_id in (SELECT wdd.lpn_id

Line 4180: FROM wsh_delivery_details_ob_grp_v wdd

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
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

Line 4184: , wsh_delivery_details_ob_grp_v wdd

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)
4188: AND wda.PARENT_DELIVERY_DETAIL_ID = wdd.delivery_detail_id)

Line 4186: FROM wsh_delivery_details_ob_grp_v

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)
4188: AND wda.PARENT_DELIVERY_DETAIL_ID = wdd.delivery_detail_id)
4189: AND wlpn.lpn_context = 6
4190: AND wlpn.organization_id = wdd.organization_id

Line 4211: FROM wsh_delivery_details_ob_grp_v wdd

4207: OPEN x_lpn_lov FOR
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

Line 4213: , wsh_delivery_details_ob_grp_v wdd1

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
4217: WHERE wdd.lpn_id in (SELECT wdd.lpn_id

Line 4215: FROM wsh_delivery_details_ob_grp_v wdd

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
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

Line 4219: , wsh_delivery_details_ob_grp_v wdd

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)
4223: AND wda.PARENT_DELIVERY_DETAIL_ID = wdd.delivery_detail_id)

Line 4221: FROM wsh_delivery_details_ob_grp_v

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)
4223: AND wda.PARENT_DELIVERY_DETAIL_ID = wdd.delivery_detail_id)
4224: AND wlpn.lpn_context = 6
4225: AND wlpn.organization_id = wdd.organization_id

Line 4404: wsh_delivery_details wdd

4400: wlpn.content_volume_uom_code,
4401: NVL(wlpn.content_volume, 0),
4402: wdd.delivery_detail_id
4403: FROM wms_license_plate_numbers wlpn,
4404: wsh_delivery_details wdd
4405: WHERE wlpn.organization_id = p_organization_id
4406: AND wlpn.lpn_context = 11
4407: AND wlpn.license_plate_number LIKE (p_lpn_id)
4408: AND wms_lpn_lovs.SUB_LPN_CONTROLLED(wlpn.subinventory_code, p_organization_id) ='Y'