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_PVT1 dependencies on WSH_DELIVERY_DETAILS

Line 1556: FROM wsh_delivery_details wdd1

1552: , wdd1.requested_quantity_uom uom
1553: , wdd1.revision revision
1554: , wdd1.subinventory
1555: , wdd1.locator_id
1556: FROM wsh_delivery_details wdd1
1557: , wsh_delivery_details wdd2
1558: , wsh_delivery_assignments_v wda
1559: , wms_license_plate_numbers wlpn
1560: WHERE wdd1.delivery_detail_id = wda.delivery_detail_id

Line 1557: , wsh_delivery_details wdd2

1553: , wdd1.revision revision
1554: , wdd1.subinventory
1555: , wdd1.locator_id
1556: FROM wsh_delivery_details wdd1
1557: , wsh_delivery_details wdd2
1558: , wsh_delivery_assignments_v wda
1559: , wms_license_plate_numbers wlpn
1560: WHERE wdd1.delivery_detail_id = wda.delivery_detail_id
1561: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id

Line 1581: FROM wsh_delivery_details wdd1

1577: , wdd1.requested_quantity_uom uom
1578: , wdd1.revision revision
1579: , wdd1.subinventory
1580: , wdd1.locator_id
1581: FROM wsh_delivery_details wdd1
1582: , wsh_delivery_assignments_v wda
1583: , wsh_new_deliveries wnd
1584: , wms_license_plate_numbers wlpn
1585: , wsh_delivery_details wdd2

Line 1585: , wsh_delivery_details wdd2

1581: FROM wsh_delivery_details wdd1
1582: , wsh_delivery_assignments_v wda
1583: , wsh_new_deliveries wnd
1584: , wms_license_plate_numbers wlpn
1585: , wsh_delivery_details wdd2
1586: WHERE wda.delivery_id = wnd.delivery_id
1587: AND wdd1.delivery_detail_id = wda.delivery_detail_id
1588: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id
1589: AND wdd1.inventory_item_id IS NOT NULL

Line 2732: -- to be derived for the delivery ID. There will be one record per serial number in the wsh_delivery_details.

2728: END IF;
2729: ELSIF p_label_type_info.business_flow_code IN (21) THEN
2730: -- Ship Confirm
2731: -- The delivery_id has being passed. Delivery ID passed means that all the delivery details ID have
2732: -- to be derived for the delivery ID. There will be one record per serial number in the wsh_delivery_details.
2733: -- The cost group will be derived from the table wms_license_plate_numbers for the LPN stamped on the Delivery_detail_id.
2734:
2735: OPEN wda_material_cur;
2736: FETCH wda_material_cur INTO l_inventory_item_id