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 dependencies on MTL_SYSTEM_ITEMS

Line 2327: FROM MTL_SYSTEM_ITEMS_B

2323: -- joabraha :Added an exception around this select so that the exception when the item is is not Lot Cotrolled is caught
2324: -- and the API can proceed executing.
2325: Begin
2326: SELECT lot_control_code INTO l_lot_control_code
2327: FROM MTL_SYSTEM_ITEMS_B
2328: WHERE organization_id = p_organization_id
2329: AND inventory_item_id = p_inventory_item_id;
2330:
2331: Exception

Line 3717: mtl_system_items_kfv msik,

3713: wlrh.label_request_id label_request_id
3714: from wms_label_requests_hist wlrh,
3715: wms_label_formats wlf,
3716: wms_license_plate_numbers wlpn,
3717: mtl_system_items_kfv msik,
3718: mfg_lookups mfglkup1,
3719: mfg_lookups mfglkup2
3720: where wlrh.label_format_id = wlf.label_format_id (+)
3721: and wlrh.lpn_id = wlpn.lpn_id (+)