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_PVT10 dependencies on MTL_MATERIAL_STATUSES_VL

Line 523: MTL_MATERIAL_STATUSES_VL lot_status

519: lot.width_uom,
520: to_char(lot.expiration_date,G_DATE_FORMAT_MASK),
521: lot_status.status_code
522: FROM MTL_LOT_NUMBERS lot,
523: MTL_MATERIAL_STATUSES_VL lot_status
524: WHERE lot.lot_number = p_lot_number
525: AND lot.status_id = lot_status.status_id (+);
526:
527: BEGIN

Line 643: MTL_MATERIAL_STATUSES_VL serial_status

639: serial.vendor_serial_number,
640: serial.serial_number,
641: serial_status.status_code
642: FROM MTL_SERIAL_NUMBERS serial,
643: MTL_MATERIAL_STATUSES_VL serial_status
644: WHERE serial.inventory_item_id = p_inventory_item_id
645: AND serial.serial_number = p_serial_number
646: AND serial.status_id = serial_status.status_id (+);
647: