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.INV_LABEL_PVT5 dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 314: from wms_license_plate_numbers lpn,

310: , rt.shipment_header_id, rt.po_line_location_id
311: , rt.vendor_id, rt.vendor_site_id
312: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
313: , rt.location_id location_id
314: from wms_license_plate_numbers lpn,
315: rcv_transactions rt
316: where lpn.lpn_id = rt.lpn_id
317: and lpn.parent_lpn_id <> rt.lpn_id
318: and lpn.parent_lpn_id is not null

Line 338: from wms_license_plate_numbers lpn, rcv_transactions rt

334: , rt.shipment_header_id, rt.po_line_location_id
335: , rt.vendor_id, rt.vendor_site_id
336: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
337: , rt.location_id location_id
338: from wms_license_plate_numbers lpn, rcv_transactions rt
339: where lpn.lpn_id = rt.lpn_id
340: and lpn.outermost_lpn_id <> lpn.lpn_id
341: and lpn.outermost_lpn_id <> lpn.parent_lpn_id
342: and rt.group_id = p_transaction_id

Line 382: from wms_license_plate_numbers lpn, rcv_transactions rt

378: , rt.shipment_header_id, rt.po_line_location_id
379: , rt.vendor_id, rt.vendor_site_id
380: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
381: , rt.location_id location_id
382: from wms_license_plate_numbers lpn, rcv_transactions rt
383: where lpn.lpn_id = rt.transfer_lpn_id
384: and rt.transfer_lpn_id <> rt.lpn_id
385: and lpn.parent_lpn_id is not null
386: and lpn.parent_lpn_id <> lpn.lpn_id

Line 406: from wms_license_plate_numbers lpn, rcv_transactions rt

402: , rt.shipment_header_id, rt.po_line_location_id
403: , rt.vendor_id, rt.vendor_site_id
404: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
405: , rt.location_id location_id
406: from wms_license_plate_numbers lpn, rcv_transactions rt
407: where lpn.lpn_id = rt.transfer_lpn_id
408: and rt.transfer_lpn_id <> rt.lpn_id
409: and lpn.outermost_lpn_id <> lpn.lpn_id
410: and lpn.outermost_lpn_id <> lpn.parent_lpn_id

Line 434: , wms_license_plate_numbers wlpn -- Bug 3836623

430: -- , hr_locations_all hrl2
431: -- MOAC : changed po_vendor_sites to po_vendor_sites_all
432: , po_vendor_sites_all pvs
433: , per_people_f ppf
434: , wms_license_plate_numbers wlpn -- Bug 3836623
435: WHERE pha.po_header_id(+) = all_lpn.po_header_id
436: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
437: AND rsh.shipment_header_id = rsl.shipment_header_id
438: /* Bug 5241400, Add where clause for rsl and appl_lpn location_id */

Line 543: FROM wsh_delivery_details wdd, wms_license_plate_numbers wlpn

539: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;
540: */
541: CURSOR c_wdd_lpn IS
542: SELECT wdd.lpn_id, wlpn.organization_id, wlpn.subinventory_code
543: FROM wsh_delivery_details wdd, wms_license_plate_numbers wlpn
544: WHERE wdd.delivery_detail_id = p_transaction_id
545: AND wdd.lpn_id = wlpn.lpn_id;
546:
547: CURSOR c_wnd_lpn IS

Line 620: from wms_license_plate_numbers lpn,

616: , rsl.truck_num
617: , rsl.COUNTRY_OF_ORIGIN_CODE
618: , rsl.comments
619: , rsl.vendor_item_num
620: from wms_license_plate_numbers lpn,
621: rcv_shipment_headers rsh,
622: rcv_shipment_lines rsl
623: where lpn.source_name = rsh.shipment_num
624: AND lpn.lpn_context = 7

Line 642: from wms_license_plate_numbers lpn,

638: , rsl.truck_num
639: , rsl.COUNTRY_OF_ORIGIN_CODE
640: , rsl.comments
641: , rsl.vendor_item_num
642: from wms_license_plate_numbers lpn,
643: rcv_shipment_headers rsh,
644: rcv_shipment_lines rsl
645: where lpn.source_name = rsh.shipment_num
646: AND lpn.lpn_context = 7

Line 664: from wms_license_plate_numbers lpn,

660: , rsl.truck_num
661: , rsl.COUNTRY_OF_ORIGIN_CODE
662: , rsl.comments
663: , rsl.vendor_item_num
664: from wms_license_plate_numbers lpn,
665: rcv_shipment_headers rsh,
666: rcv_shipment_lines rsl
667: where lpn.source_name = rsh.shipment_num
668: AND lpn.lpn_context = 7

Line 766: FROM WMS_LICENSE_PLATE_NUMBERS lpn

762: , lpn.attribute14 lpn_attribute14
763: , lpn.attribute15 lpn_attribute15
764: , nvl(wph.parent_package_id, l_parent_package_id) parent_package
765: , nvl(wph.pack_level, l_pack_level) pack_level
766: FROM WMS_LICENSE_PLATE_NUMBERS lpn
767: , WMS_PACKAGING_HIST wph
768: , WMS_LICENSE_PLATE_NUMBERS plpn
769: , WMS_LICENSE_PLATE_NUMBERS olpn
770: , MTL_SYSTEM_ITEMS_KFV msik

Line 768: , WMS_LICENSE_PLATE_NUMBERS plpn

764: , nvl(wph.parent_package_id, l_parent_package_id) parent_package
765: , nvl(wph.pack_level, l_pack_level) pack_level
766: FROM WMS_LICENSE_PLATE_NUMBERS lpn
767: , WMS_PACKAGING_HIST wph
768: , WMS_LICENSE_PLATE_NUMBERS plpn
769: , WMS_LICENSE_PLATE_NUMBERS olpn
770: , MTL_SYSTEM_ITEMS_KFV msik
771: /*Commented for bug# 6334460 start
772: , DUAL d

Line 769: , WMS_LICENSE_PLATE_NUMBERS olpn

765: , nvl(wph.pack_level, l_pack_level) pack_level
766: FROM WMS_LICENSE_PLATE_NUMBERS lpn
767: , WMS_PACKAGING_HIST wph
768: , WMS_LICENSE_PLATE_NUMBERS plpn
769: , WMS_LICENSE_PLATE_NUMBERS olpn
770: , MTL_SYSTEM_ITEMS_KFV msik
771: /*Commented for bug# 6334460 start
772: , DUAL d
773: WHERE d.dummy = 'X'

Line 916: , wms_license_plate_numbers plpn

912: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id) locator
913: , sum(nvl(l_secondary_quantity,wlc.secondary_quantity)) secondary_quantity -- invconv fabdi
914: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
915: FROM wms_lpn_contents wlc
916: , wms_license_plate_numbers plpn
917: , cst_cost_groups ccg
918: , mtl_item_locations milkfv
919: WHERE plpn.lpn_id in (select lpn_id from wms_license_plate_numbers
920: where 1=1

Line 919: WHERE plpn.lpn_id in (select lpn_id from wms_license_plate_numbers

915: FROM wms_lpn_contents wlc
916: , wms_license_plate_numbers plpn
917: , cst_cost_groups ccg
918: , mtl_item_locations milkfv
919: WHERE plpn.lpn_id in (select lpn_id from wms_license_plate_numbers
920: where 1=1
921: -- Bug 4137707
922: --start with lpn_id in (select nvl(p_lpn_id, -99) from dual
923: --union all

Line 1034: , wms_license_plate_numbers plpn

1030: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id,milkfv.organization_id) locator
1031: , sum(nvl(l_secondary_quantity,wlc.secondary_quantity)) secondary_quantity -- invconv fabdi
1032: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
1033: FROM wms_lpn_contents wlc
1034: , wms_license_plate_numbers plpn
1035: , cst_cost_groups ccg
1036: , mtl_item_locations milkfv
1037: WHERE plpn.lpn_id in (select lpn_id from wms_license_plate_numbers
1038: where 1=1

Line 1037: WHERE plpn.lpn_id in (select lpn_id from wms_license_plate_numbers

1033: FROM wms_lpn_contents wlc
1034: , wms_license_plate_numbers plpn
1035: , cst_cost_groups ccg
1036: , mtl_item_locations milkfv
1037: WHERE plpn.lpn_id in (select lpn_id from wms_license_plate_numbers
1038: where 1=1
1039: start with lpn_id in (select nvl(p_lpn_id, -99) from dual
1040: union all
1041: select lpn_id from wms_packaging_hist