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 1512: FROM wsh_delivery_details wdd1

1508: , wdd1.requested_quantity_uom uom
1509: , wdd1.revision revision
1510: , wdd1.subinventory
1511: , wdd1.locator_id
1512: FROM wsh_delivery_details wdd1
1513: , wsh_delivery_details wdd2
1514: , wsh_delivery_assignments_v wda
1515: , wms_license_plate_numbers wlpn
1516: WHERE wdd1.delivery_detail_id = wda.delivery_detail_id

Line 1513: , wsh_delivery_details wdd2

1509: , wdd1.revision revision
1510: , wdd1.subinventory
1511: , wdd1.locator_id
1512: FROM wsh_delivery_details wdd1
1513: , wsh_delivery_details wdd2
1514: , wsh_delivery_assignments_v wda
1515: , wms_license_plate_numbers wlpn
1516: WHERE wdd1.delivery_detail_id = wda.delivery_detail_id
1517: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id

Line 1537: FROM wsh_delivery_details wdd1

1533: , wdd1.requested_quantity_uom uom
1534: , wdd1.revision revision
1535: , wdd1.subinventory
1536: , wdd1.locator_id
1537: FROM wsh_delivery_details wdd1
1538: , wsh_delivery_assignments_v wda
1539: , wsh_new_deliveries wnd
1540: , wms_license_plate_numbers wlpn
1541: , wsh_delivery_details wdd2

Line 1541: , wsh_delivery_details wdd2

1537: FROM wsh_delivery_details wdd1
1538: , wsh_delivery_assignments_v wda
1539: , wsh_new_deliveries wnd
1540: , wms_license_plate_numbers wlpn
1541: , wsh_delivery_details wdd2
1542: WHERE wda.delivery_id = wnd.delivery_id
1543: AND wdd1.delivery_detail_id = wda.delivery_detail_id
1544: AND wdd2.delivery_detail_id = wda.parent_delivery_detail_id
1545: AND wdd1.inventory_item_id IS NOT NULL

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

2583: END IF;
2584: ELSIF p_label_type_info.business_flow_code IN (21) THEN
2585: -- Ship Confirm
2586: -- The delivery_id has being passed. Delivery ID passed means that all the delivery details ID have
2587: -- to be derived for the delivery ID. There will be one record per serial number in the wsh_delivery_details.
2588: -- The cost group will be derived from the table wms_license_plate_numbers for the LPN stamped on the Delivery_detail_id.
2589:
2590: OPEN wda_material_cur;
2591: FETCH wda_material_cur INTO l_inventory_item_id