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_ITEM_CATEGORIES

Line 69: , mtl_item_categories mic

65: , mcv.category_id
66: , mcv.category_concat_segs
67: FROM mtl_default_sets_view mdsv
68: , mtl_categories_v mcv
69: , mtl_item_categories mic
70: WHERE mdsv.functional_area_id = 1
71: AND mdsv.structure_id = mcv.structure_id
72: AND mic.category_set_id = mdsv.category_set_id
73: AND mcv.category_id = mic.category_id

Line 89: , mtl_item_categories mic

85: , mcv.category_id
86: , mcv.category_concat_segs
87: FROM mtl_default_sets_view mdsv
88: , mtl_categories_v mcv
89: , mtl_item_categories mic
90: WHERE mdsv.functional_area_id = 1
91: AND mdsv.structure_id = mcv.structure_id
92: AND mic.category_set_id = mdsv.category_set_id
93: AND mcv.category_id = mic.category_id