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

Line 197: , wms_license_plate_numbers wlpn -- Bug 3836623

193: po_lines_trx_v pol -- CLM project, bug 9403291
194: -- , po_distributions_all pod --Commented as part of Bug# 3586116
195: , po_headers_trx_v pha, -- CLM project, bug 9403291
196: rcv_shipment_lines rsl
197: , wms_license_plate_numbers wlpn -- Bug 3836623
198: WHERE rss.transaction_id = rt.transaction_id
199: AND pol.po_line_id(+) = rt.po_line_id
200: AND pha.po_header_id(+) = rt.po_header_id
201: -- AND pod.po_distribution_id(+) = rt.po_distribution_id --Commented as part of Bug# 3586116

Line 248: , wms_license_plate_numbers wlpn -- Bug 3836623

244: -- , po_distributions_all pod --Commented as part of Bug# 3586116
245: , po_lines_trx_v pol -- CLM project, bug 9403291
246: , po_headers_trx_v pha -- CLM project, bug 9403291
247: , rcv_shipment_lines rsl
248: , wms_license_plate_numbers wlpn -- Bug 3836623
249: -- Bug 4179732, can not print serial number from putaway
250: -- Changed to link to MUT through MMT
251: , mtl_material_transactions mmt
252: WHERE mmt.rcv_transaction_id = rt.transaction_id

Line 1354: -- The cost group will be derived from the table wms_license_plate_numbers for the LPN stamped on the Delivery_detail_id.

1350: -- Cross Dock(6).
1351: -- Here in this case the delivery_detail_id is being passed.
1352: -- Delivery detail ID passed means that we just have to print serial label for the one delivery detail id and
1353: -- not all the delivery detail id's in the delivery.
1354: -- The cost group will be derived from the table wms_license_plate_numbers for the LPN stamped on the Delivery_detail_id.
1355: OPEN wdd_serial_cur;
1356:
1357: FETCH wdd_serial_cur
1358: INTO l_inventory_item_id

Line 1463: -- The cost group will be derived from the table wms_license_plate_numbers for the LPN stamped on the Delivery_detail_id.

1459: ELSIF p_label_type_info.business_flow_code IN(21) THEN
1460: -- Ship Confirm
1461: -- The delivery_id has being passed. Delivery ID passed means that all the delivery details ID have
1462: -- to be derived for the delivery ID. There will be one record per serial number in the wsh_delivery_details.
1463: -- The cost group will be derived from the table wms_license_plate_numbers for the LPN stamped on the Delivery_detail_id.
1464: IF (l_debug = 1) THEN
1465: TRACE(' Ship Confirm Flow with Delivery ID: ' || p_transaction_id);
1466: END IF;
1467: OPEN wda_serial_cur;