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

Line 647: , wms_license_plate_numbers wlpn

643: FROM wsh_delivery_details wdd_item -- records with item info
644: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
645: , wsh_delivery_assignments_v wda
646: , oe_order_lines_all oeol
647: , wms_license_plate_numbers wlpn
648: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
649: AND wda.parent_delivery_detail_id = wdd_lpn.delivery_detail_id
650: AND (wdd_item.inventory_item_id IS NOT NULL AND
651: wdd_item.lpn_id IS NULL)

Line 654: FROM wms_license_plate_numbers wlpn2

650: AND (wdd_item.inventory_item_id IS NOT NULL AND
651: wdd_item.lpn_id IS NULL)
652: AND wdd_lpn.lpn_id IN
653: (SELECT wlpn2.lpn_id
654: FROM wms_license_plate_numbers wlpn2
655: WHERE wlpn2.outermost_lpn_id = wlpn.outermost_lpn_id)
656: AND wlpn.lpn_id = p_lpn_id
657: AND wdd_item.source_line_id = oeol.line_id(+)
658: AND wdd_item.organization_id = wlpn.organization_id /*9180228*/

Line 758: , wms_license_plate_numbers wlpn

754: ,wdd_item.intmed_ship_to_contact_id
755: ,wdd_item.delivery_detail_id --Bug9261874
756: FROM wsh_delivery_details wdd_item -- records with item info
757: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
758: , wms_license_plate_numbers wlpn
759: , wsh_delivery_assignments_v wda
760: , oe_order_lines_all oeol
761: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id
762: AND (wdd_item.inventory_item_id IS NOT NULL AND

Line 1113: FROM wms_license_plate_numbers wlpn

1109: , wlpn.attribute13
1110: , wlpn.attribute14
1111: , wlpn.attribute15
1112: , msik.concatenated_segments lpn_container_item
1113: FROM wms_license_plate_numbers wlpn
1114: , mtl_system_items_kfv msik
1115: , mtl_item_locations_kfv milk
1116: WHERE wlpn.lpn_id = p_lpn_id
1117: AND msik.organization_id(+) = wlpn.organization_id

Line 2371: wms_license_plate_numbers wlpn,wms_license_plate_numbers wlpn2

2367: wsh1.lot_number lot,
2368: wsh1.revision rev,
2369: wlpn2.lpn_id lpn_id
2370: FROM wsh_delivery_details wsh1, wsh_delivery_assignments wda, wsh_delivery_details wsh2 ,
2371: wms_license_plate_numbers wlpn,wms_license_plate_numbers wlpn2
2372: WHERE wlpn.lpn_id = wsh2.lpn_id
2373: AND wlpn.outermost_lpn_id=wlpn2.outermost_lpn_id
2374: AND wda.delivery_detail_id = wsh1.delivery_detail_id
2375: AND wda.parent_delivery_detail_id = wsh2.delivery_detail_id

Line 2807: FROM wms_license_plate_numbers

2803: -- Box Count = Number of Immediate Child LPNs of the Outer LPN
2804: BEGIN
2805: SELECT count(lpn_id)
2806: INTO g_column_elements_table(get_column_hash_value('box_count')).column_content
2807: FROM wms_license_plate_numbers
2808: WHERE parent_lpn_id IS NOT NULL
2809: AND parent_lpn_id = l_cur_wdd.outer_lpn_id
2810: AND outermost_lpn_id = l_cur_wdd.outer_lpn_id;
2811: