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 WSH_DELIVERY_DETAILS

Line 276: , wsh_delivery_details wdd

272:
273: CURSOR c_delivery(v_cartonization_id NUMBER) IS
274: SELECT distinct wda.delivery_id
275: FROM wsh_delivery_assignments wda
276: , wsh_delivery_details wdd
277: , mtl_material_transactions_temp mmtt
278: WHERE mmtt.cartonization_id = v_cartonization_id
279: AND mmtt.move_order_line_id = wdd.move_order_line_id
280: AND wda.delivery_detail_id = wdd.delivery_detail_id;

Line 462: wsh_delivery_details wdd,

458: mtl_material_transactions_temp mmtt1,
459: mtl_transaction_lots_temp mtlt1
460: WHERE mmtt1.transaction_temp_id = mtlt1.transaction_temp_id(+)
461: ) mmtt, -- mmtt with lot number information
462: wsh_delivery_details wdd,
463: wsh_delivery_assignments_v wda,
464: mtl_item_locations_kfv milk,
465: mtl_item_locations_kfv milk2,
466: oe_order_lines_all oeol

Line 567: FROM wsh_delivery_details wdd_item -- records with item info

563: ,NULL wnd_ship_method_code -- Place holder, get later with c_delivery
564: ,NULL intmed_ship_to_location_id -- Place holder, get later with c_delivery
565: ,wdd_item.intmed_ship_to_contact_id
566:
567: FROM wsh_delivery_details wdd_item -- records with item info
568: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
569: , wsh_delivery_assignments_v wda
570: , oe_order_lines_all oeol
571: , wms_license_plate_numbers wlpn

Line 568: , wsh_delivery_details wdd_lpn -- records of the immediate lpn

564: ,NULL intmed_ship_to_location_id -- Place holder, get later with c_delivery
565: ,wdd_item.intmed_ship_to_contact_id
566:
567: FROM wsh_delivery_details wdd_item -- records with item info
568: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
569: , wsh_delivery_assignments_v wda
570: , oe_order_lines_all oeol
571: , wms_license_plate_numbers wlpn
572: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id

Line 669: FROM wsh_delivery_details wdd_item -- records with item info

665: ,NULL wnd_carrier_id -- Place holder, get later with c_delivery
666: ,NULL wnd_ship_method_code -- Place holder, get later with c_delivery
667: ,NULL intmed_ship_to_location_id -- Place holder, get later with c_delivery
668: ,wdd_item.intmed_ship_to_contact_id
669: FROM wsh_delivery_details wdd_item -- records with item info
670: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
671: , wms_license_plate_numbers wlpn
672: , wsh_delivery_assignments_v wda
673: , oe_order_lines_all oeol

Line 670: , wsh_delivery_details wdd_lpn -- records of the immediate lpn

666: ,NULL wnd_ship_method_code -- Place holder, get later with c_delivery
667: ,NULL intmed_ship_to_location_id -- Place holder, get later with c_delivery
668: ,wdd_item.intmed_ship_to_contact_id
669: FROM wsh_delivery_details wdd_item -- records with item info
670: , wsh_delivery_details wdd_lpn -- records of the immediate lpn
671: , wms_license_plate_numbers wlpn
672: , wsh_delivery_assignments_v wda
673: , oe_order_lines_all oeol
674: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id

Line 768: FROM wsh_delivery_details wdd_item -- records with item info

764: ,NULL wnd_carrier_id -- Place holder, get later with c_delivery
765: ,NULL wnd_ship_method_code -- Place holder, get later with c_delivery
766: ,NULL intmed_ship_to_location_id -- Place holder, get later with c_delivery
767: ,wdd_item.intmed_ship_to_contact_id
768: FROM wsh_delivery_details wdd_item -- records with item info
769: , wsh_delivery_assignments_v wda
770: , mtl_item_locations_kfv milk
771: , oe_order_lines_all oeol
772: WHERE wda.delivery_detail_id = wdd_item.delivery_detail_id

Line 830: FROM wsh_delivery_details wdd

826: , (wdd.gross_weight - wdd.net_weight) tare_weight
827: , wdd.weight_uom_code tare_weight_uom
828: , wdd.volume
829: , wdd.volume_uom_code
830: FROM wsh_delivery_details wdd
831: WHERE lpn_id = p_lpn_id;
832:
833: CURSOR c_item(p_organization_id NUMBER, p_inventory_item_id NUMBER) IS
834: SELECT msik.concatenated_segments

Line 1475: FROM wsh_delivery_details

1471: --End Bug 6696594
1472: ELSIF p_label_type_info.business_flow_code in (6) THEN
1473: BEGIN
1474: SELECT lpn_id INTO l_outer_lpn_id
1475: FROM wsh_delivery_details
1476: WHERE delivery_detail_id = p_transaction_id;
1477: EXCEPTION
1478: WHEN others THEN
1479: IF (l_debug =1 ) THEN