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 5681: INDEX(ic MTL_ITEM_CATEGORIES_U1)

5677: AND ia.instance_id = p_instance_id
5678: UNION ALL
5679: SELECT /*+ INDEX(ia CSI_ITEM_INSTANCES_U01)
5680: INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)
5681: INDEX(ic MTL_ITEM_CATEGORIES_U1)
5682: */ -- Added by sguthiva for bug 2367664
5683: iea.attribute_id attribute_id
5684: ,iea.attribute_level attribute_level
5685: ,iea.master_organization_id master_organization_id

Line 5714: ,mtl_item_categories ic

5710: ,iea.attribute15 attribute15
5711: ,iea.object_version_number object_version_number
5712: FROM csi_i_extended_attribs iea
5713: ,csi_item_instances ia
5714: ,mtl_item_categories ic
5715: WHERE iea.attribute_level = 'CATEGORY'
5716: -- AND iea.inventory_item_id = ia.inventory_item_id -- commented for Bug # 3189494
5717: -- AND iea.master_organization_id = ia.inv_master_organization_id -- commented for Bug # 3189494
5718: AND ic.organization_id = ia.inv_master_organization_id