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.CSI_ITEM_INSTANCE_PUB dependencies on MTL_ITEM_CATEGORIES

Line 5749: INDEX(ic MTL_ITEM_CATEGORIES_U1)

5745: AND ia.instance_id = p_instance_id
5746: UNION ALL
5747: SELECT /*+ INDEX(ia CSI_ITEM_INSTANCES_U01)
5748: INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)
5749: INDEX(ic MTL_ITEM_CATEGORIES_U1)
5750: */ -- Added by sguthiva for bug 2367664
5751: iea.attribute_id attribute_id
5752: ,iea.attribute_level attribute_level
5753: ,iea.master_organization_id master_organization_id

Line 5782: ,mtl_item_categories ic

5778: ,iea.attribute15 attribute15
5779: ,iea.object_version_number object_version_number
5780: FROM csi_i_extended_attribs iea
5781: ,csi_item_instances ia
5782: ,mtl_item_categories ic
5783: WHERE iea.attribute_level = 'CATEGORY'
5784: -- AND iea.inventory_item_id = ia.inventory_item_id -- commented for Bug # 3189494
5785: -- AND iea.master_organization_id = ia.inv_master_organization_id -- commented for Bug # 3189494
5786: AND ic.organization_id = ia.inv_master_organization_id