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_PVT4 dependencies on WMS_LICENSE_PLATE_NUMBERS

Line 244: from wms_license_plate_numbers lpn,

240: , rt.vendor_id, rt.vendor_site_id
241: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
242: , rt.location_id location_id
243: , rt.quantity
244: from wms_license_plate_numbers lpn,
245: rcv_transactions rt
246: where lpn.lpn_id = rt.lpn_id
247: and lpn.parent_lpn_id <> rt.lpn_id
248: and rt.group_id = p_transaction_id

Line 269: from wms_license_plate_numbers lpn, rcv_transactions rt

265: , rt.vendor_id, rt.vendor_site_id
266: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
267: , rt.location_id location_id
268: , rt.quantity
269: from wms_license_plate_numbers lpn, rcv_transactions rt
270: where lpn.lpn_id = rt.lpn_id
271: and lpn.outermost_lpn_id <> lpn.lpn_id
272: and lpn.outermost_lpn_id <> lpn.parent_lpn_id
273: and rt.group_id = p_transaction_id

Line 316: from wms_license_plate_numbers lpn, rcv_transactions rt

312: , rt.vendor_id, rt.vendor_site_id
313: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
314: , rt.location_id location_id
315: , rt.quantity
316: from wms_license_plate_numbers lpn, rcv_transactions rt
317: where lpn.lpn_id = rt.transfer_lpn_id
318: and rt.transfer_lpn_id <> rt.lpn_id
319: and lpn.parent_lpn_id <> lpn.lpn_id
320: and lpn.parent_lpn_id is not null -- parentLPN could be null for single-level LPN

Line 341: from wms_license_plate_numbers lpn, rcv_transactions rt

337: , rt.vendor_id, rt.vendor_site_id
338: , rt.deliver_to_person_id, rt.deliver_to_location_id deliver_to_location_id
339: , rt.location_id location_id
340: , rt.quantity
341: from wms_license_plate_numbers lpn, rcv_transactions rt
342: where lpn.lpn_id = rt.transfer_lpn_id
343: and rt.transfer_lpn_id <> rt.lpn_id
344: and lpn.outermost_lpn_id <> lpn.lpn_id
345: and lpn.outermost_lpn_id <> lpn.parent_lpn_id

Line 369: , wms_license_plate_numbers wlpn

365: -- , hr_locations_all hrl2
366: -- MOAC : po_vendor_sites changed to po_vendor_sites_all
367: , po_vendor_sites_all pvs
368: , per_people_f ppf
369: , wms_license_plate_numbers wlpn
370: WHERE pha.po_header_id(+) = all_lpn.po_header_id
371: AND rsh.shipment_header_id(+) = all_lpn.shipment_header_id
372: AND rsh.shipment_header_id = rsl.shipment_header_id
373: /* Bug 5241400, Add where clause for rsl and appl_lpn location_id */

Line 480: WMS_LICENSE_PLATE_NUMBERS lpn

476: wph1.gross_weight_uom_code, wph1.gross_weight, wph.inventory_item_id, wph1.parent_package_id,
477: wph1.pack_level, wph.header_id,wph.packaging_mode, wph1.tare_weight, wph1.tare_weight_uom_code,
478: msik.concatenated_segments container_item, lpn.license_plate_number, wph2.pack_level
479: FROM wms_packaging_hist wph, wms_packaging_hist wph1, wms_packaging_hist wph2, mtl_system_items_kfv msik,
480: WMS_LICENSE_PLATE_NUMBERS lpn
481: WHERE wph.rowid in (select rowid
482: from wms_packaging_hist
483: where pack_level = 0
484: START WITH parent_lpn_id = p_transaction_id

Line 498: msik, WMS_LICENSE_PLATE_NUMBERS lpn

494: wph1.gross_weight_uom_code, wph1.gross_weight, wph.inventory_item_id, wph1.parent_package_id,
495: wph1.pack_level, wph.header_id,wph.packaging_mode, wph1.tare_weight, wph1.tare_weight_uom_code,
496: msik.concatenated_segments container_item,lpn.license_plate_number
497: FROM wms_packaging_hist wph, wms_packaging_hist wph1, mtl_system_items_kfv
498: msik, WMS_LICENSE_PLATE_NUMBERS lpn
499: WHERE wph.rowid in (select rowid
500: from wms_packaging_hist
501: where pack_level = 0
502: START WITH parent_lpn_id = p_transaction_id

Line 534: FROM wsh_delivery_details wdd, wms_license_plate_numbers wlpn

530: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;
531: */
532: CURSOR c_wdd_lpn IS
533: SELECT wdd.lpn_id, wlpn.organization_id, wlpn.subinventory_code
534: FROM wsh_delivery_details wdd, wms_license_plate_numbers wlpn
535: WHERE wdd.delivery_detail_id = p_transaction_id
536: AND wdd.lpn_id = wlpn.lpn_id;
537:
538:

Line 561: FROM wms_license_plate_numbers

557: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id;
558:
559: CURSOR c_child_lpns(p_lpn_id NUMBER) IS
560: SELECT lpn_id
561: FROM wms_license_plate_numbers
562: WHERE parent_lpn_id = p_lpn_id;
563:
564: CURSOR c_lpn_attributes (p_org_id NUMBER, p_lpn_id NUMBER)IS
565: SELECT lpn.LICENSE_PLATE_NUMBER lpn

Line 596: FROM WMS_LICENSE_PLATE_NUMBERS lpn

592: , lpn.attribute14 lpn_attribute14
593: , lpn.attribute15 lpn_attribute15
594: , nvl(wph.parent_package_id, l_package_id) parent_package --l_parent_package_id) parent_package
595: , nvl(wph.pack_level, l_pack_level) pack_level
596: FROM WMS_LICENSE_PLATE_NUMBERS lpn
597: , WMS_PACKAGING_HIST wph
598: , WMS_LICENSE_PLATE_NUMBERS plpn
599: , WMS_LICENSE_PLATE_NUMBERS olpn
600: , MTL_SYSTEM_ITEMS_KFV msik

Line 598: , WMS_LICENSE_PLATE_NUMBERS plpn

594: , nvl(wph.parent_package_id, l_package_id) parent_package --l_parent_package_id) parent_package
595: , nvl(wph.pack_level, l_pack_level) pack_level
596: FROM WMS_LICENSE_PLATE_NUMBERS lpn
597: , WMS_PACKAGING_HIST wph
598: , WMS_LICENSE_PLATE_NUMBERS plpn
599: , WMS_LICENSE_PLATE_NUMBERS olpn
600: , MTL_SYSTEM_ITEMS_KFV msik
601: , DUAL d
602: WHERE d.dummy = 'X'

Line 599: , WMS_LICENSE_PLATE_NUMBERS olpn

595: , nvl(wph.pack_level, l_pack_level) pack_level
596: FROM WMS_LICENSE_PLATE_NUMBERS lpn
597: , WMS_PACKAGING_HIST wph
598: , WMS_LICENSE_PLATE_NUMBERS plpn
599: , WMS_LICENSE_PLATE_NUMBERS olpn
600: , MTL_SYSTEM_ITEMS_KFV msik
601: , DUAL d
602: WHERE d.dummy = 'X'
603: AND lpn.license_plate_number (+) <> NVL('@@@',d.dummy)

Line 744: , wms_license_plate_numbers plpn

740: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
741: , sum(nvl(l_secondary_transaction_qty,wlc.secondary_quantity)) secondary_quantity -- invconv fabdi
742: , wlc.secondary_uom_code secondary_uom -- invconv fabdi
743: FROM wms_lpn_contents wlc
744: , wms_license_plate_numbers plpn
745: , cst_cost_groups ccg
746: , mtl_item_locations milkfv
747: -- Bug 4137707, Do not need to include this where clause,
748: -- This will be controlled when opening this cursor

Line 751: wlc.parent_lpn_id IN (SELECT lpn_id FROM wms_license_plate_numbers plpn

747: -- Bug 4137707, Do not need to include this where clause,
748: -- This will be controlled when opening this cursor
749: --WHERE cartonization_flag = 0 -- non Cartonization Flow
750: WHERE --wlc.parent_lpn_id = p_lpn_id /* Modified for the bug # 4771610*/
751: wlc.parent_lpn_id IN (SELECT lpn_id FROM wms_license_plate_numbers plpn
752: WHERE 1 = 1
753: start with lpn_id = p_lpn_id
754: connect by parent_lpn_id = prior lpn_id)
755: AND plpn.lpn_id (+) = wlc.parent_lpn_id

Line 797: FROM wms_license_plate_numbers plpn

793: , milkfv.inventory_location_id locator_id
794: , INV_PROJECT.GET_LOCSEGS(milkfv.inventory_location_id, milkfv.organization_id) locator
795: , sum(nvl(l_secondary_transaction_qty,mmtt.secondary_transaction_quantity)) secondary_quantity -- invconv fabdi
796: , mmtt.secondary_uom_code secondary_uom -- invconv fabdi
797: FROM wms_license_plate_numbers plpn
798: , cst_cost_groups ccg
799: , mtl_item_locations milkfv
800: , mtl_material_transactions_temp mmtt
801: -- Bug 4137707, Do not need to include this where clause,

Line 936: from wms_license_plate_numbers lpn,

932: , rsl.truck_num
933: , rsl.COUNTRY_OF_ORIGIN_CODE
934: , rsl.comments
935: , rsl.vendor_item_num
936: from wms_license_plate_numbers lpn,
937: rcv_shipment_headers rsh,
938: rcv_shipment_lines rsl
939: where lpn.source_name = rsh.shipment_num
940: AND lpn.lpn_context = 7

Line 958: from wms_license_plate_numbers lpn,

954: , rsl.truck_num
955: , rsl.COUNTRY_OF_ORIGIN_CODE
956: , rsl.comments
957: , rsl.vendor_item_num
958: from wms_license_plate_numbers lpn,
959: rcv_shipment_headers rsh,
960: rcv_shipment_lines rsl
961: where lpn.source_name = rsh.shipment_num
962: AND lpn.lpn_context = 7

Line 980: from wms_license_plate_numbers lpn,

976: , rsl.truck_num
977: , rsl.COUNTRY_OF_ORIGIN_CODE
978: , rsl.comments
979: , rsl.vendor_item_num
980: from wms_license_plate_numbers lpn,
981: rcv_shipment_headers rsh,
982: rcv_shipment_lines rsl
983: where lpn.source_name = rsh.shipment_num
984: AND lpn.lpn_context = 7

Line 1079: FROM wms_license_plate_numbers plpn, cst_cost_groups ccg, mtl_item_locations milkfv,

1075: , milkfv.inventory_location_id locator_id
1076: , inv_project.get_locsegs(milkfv.inventory_location_id, milkfv.organization_id) LOCATOR
1077: , sum(nvl(l_secondary_transaction_qty,mcce.count_quantity_current)) secondary_quantity
1078: , mcce.count_uom_current secondary_uom
1079: FROM wms_license_plate_numbers plpn, cst_cost_groups ccg, mtl_item_locations milkfv,
1080: mtl_cycle_count_entries mcce
1081: WHERE cartonization_flag = 0 -- non Cartonization Flow
1082: AND plpn.lpn_id(+) = p_lpn_id
1083: AND milkfv.organization_id(+) = NVL(p_organization_id, plpn.organization_id)

Line 2111: from wms_license_plate_numbers

2107: trace('checkin on hand status');
2108: END IF;
2109: BEGIN
2110: select lpn_context into l_lpn_context_id
2111: from wms_license_plate_numbers
2112: where lpn_id = l_lpn_id;
2113: EXCEPTION
2114: WHEN No_Data_Found THEN
2115: l_lpn_context_id := -99 ;