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 4101: FROM wsh_delivery_details_ob_grp_v wdd

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

Line 4103: , wsh_delivery_details_ob_grp_v wdd1

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

Line 4105: FROM wsh_delivery_details_ob_grp_v wdd

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

Line 4109: , wsh_delivery_details_ob_grp_v wdd

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

Line 4111: FROM wsh_delivery_details_ob_grp_v

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

Line 4130: FROM wsh_delivery_details_ob_grp_v wdd

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

Line 4132: , wsh_delivery_details_ob_grp_v wdd1

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

Line 4134: FROM wsh_delivery_details_ob_grp_v wdd

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

Line 4138: , wsh_delivery_details_ob_grp_v wdd

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

Line 4140: FROM wsh_delivery_details_ob_grp_v

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

Line 4161: wsh_delivery_details_ob_grp_v wdd

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

Line 4177: FROM wsh_delivery_details_ob_grp_v wdd

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

Line 4179: , wsh_delivery_details_ob_grp_v wdd1

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

Line 4181: FROM wsh_delivery_details_ob_grp_v wdd

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

Line 4185: , wsh_delivery_details_ob_grp_v wdd

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

Line 4187: FROM wsh_delivery_details_ob_grp_v

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

Line 4212: FROM wsh_delivery_details_ob_grp_v wdd

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

Line 4214: , wsh_delivery_details_ob_grp_v wdd1

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

Line 4216: FROM wsh_delivery_details_ob_grp_v wdd

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

Line 4220: , wsh_delivery_details_ob_grp_v wdd

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

Line 4222: FROM wsh_delivery_details_ob_grp_v

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

Line 4406: wsh_delivery_details wdd

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

Line 4458: wsh_delivery_details wdd ,

4454: wlpn.content_volume_uom_code,
4455: NVL(wlpn.content_volume, 0),
4456: wdd.delivery_detail_id
4457: FROM wms_license_plate_numbers wlpn,
4458: wsh_delivery_details wdd ,
4459: wms_lpn_contents wlc
4460: WHERE wlpn.organization_id = p_organization_id
4461: AND wlpn.lpn_id = wlc.parent_lpn_id
4462: AND wlpn.lpn_context = WMS_Container_PUB.LPN_CONTEXT_INV