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_LOT_SERIAL_DATE_EVENT_PKG dependencies on MTL_SERIAL_NUMBERS

Line 52: FROM mtl_serial_numbers msn

48: , msn.gen_object_id
49: , msn.current_status
50: , mfgl.meaning serial_status
51: , msn.initialization_date date_column
52: FROM mtl_serial_numbers msn
53: , mtl_parameters mtp
54: , mtl_system_items_kfv msi
55: , mfg_lookups mfgl;
56:

Line 500: ' mtl_serial_numbers msn, mtl_parameters mtp, mtl_system_items_kfv msi, '

496: || ' msn.current_status, mfgl.meaning serial_status, '
497: || p_date_type
498: || ' date_column ';
499: l_serial_table_list :=
500: ' mtl_serial_numbers msn, mtl_parameters mtp, mtl_system_items_kfv msi, '
501: || ' mfg_lookups mfgl ';
502: l_serial_where_clause :=
503: ' mtp.organization_id = :b_organization_id '
504: || ' and mtp.organization_id = msi.organization_id '