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_LOT_NUMBERS

Line 451: p_lot_number mtl_lot_numbers.lot_number%TYPE

447:
448: /*=================================================================*/
449: PROCEDURE get_data_lot(
450: x_out_tbl IN OUT NOCOPY output_tbl_type,
451: p_lot_number mtl_lot_numbers.lot_number%TYPE
452: )IS
453:
454: CURSOR lot_curs IS
455: SELECT

Line 522: FROM MTL_LOT_NUMBERS lot,

518: lot.width,
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: