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 CSI_I_EXTENDED_ATTRIBS

Line 5574: SELECT /+ INDEX(iea CSI_I_EXTENDED_ATTRIBS_N04)/ -- Added by sguthiva for bug 2367664

5570: l_trace_enable_flag VARCHAR2(1) :='N';
5571: l_row NUMBER := 0;
5572:
5573: CURSOR ext_attrib_csr (p_instance_id NUMBER) IS
5574: SELECT /*+ INDEX(iea CSI_I_EXTENDED_ATTRIBS_N04)*/ -- Added by sguthiva for bug 2367664
5575: iea.attribute_id attribute_id
5576: ,iea.attribute_level attribute_level
5577: ,iea.master_organization_id master_organization_id
5578: ,iea.inventory_item_id inventory_item_id

Line 5604: FROM csi_i_extended_attribs iea

5600: ,iea.attribute13 attribute13
5601: ,iea.attribute14 attribute14
5602: ,iea.attribute15 attribute15
5603: ,iea.object_version_number object_version_number
5604: FROM csi_i_extended_attribs iea
5605: WHERE attribute_level = 'GLOBAL'
5606: UNION ALL
5607: SELECT /*+ INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)*/ -- Added by sguthiva for bug 2367664
5608: iea.attribute_id attribute_id

Line 5607: SELECT /+ INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)/ -- Added by sguthiva for bug 2367664

5603: ,iea.object_version_number object_version_number
5604: FROM csi_i_extended_attribs iea
5605: WHERE attribute_level = 'GLOBAL'
5606: UNION ALL
5607: SELECT /*+ INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)*/ -- Added by sguthiva for bug 2367664
5608: iea.attribute_id attribute_id
5609: ,iea.attribute_level attribute_level
5610: ,iea.master_organization_id master_organization_id
5611: ,iea.inventory_item_id inventory_item_id

Line 5637: FROM csi_i_extended_attribs iea

5633: ,iea.attribute13 attribute13
5634: ,iea.attribute14 attribute14
5635: ,iea.attribute15 attribute15
5636: ,iea.object_version_number object_version_number
5637: FROM csi_i_extended_attribs iea
5638: WHERE attribute_level = 'INSTANCE'
5639: AND instance_id = p_instance_id
5640: UNION ALL
5641: SELECT /*+ INDEX(ia CSI_ITEM_INSTANCES_U01)

Line 5642: INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)

5638: WHERE attribute_level = 'INSTANCE'
5639: AND instance_id = p_instance_id
5640: UNION ALL
5641: SELECT /*+ INDEX(ia CSI_ITEM_INSTANCES_U01)
5642: INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)
5643: */ -- Added by sguthiva for bug 2367664
5644: iea.attribute_id attribute_id
5645: ,iea.attribute_level attribute_level
5646: ,iea.master_organization_id master_organization_id

Line 5673: FROM csi_i_extended_attribs iea, csi_item_instances ia

5669: ,iea.attribute13 attribute13
5670: ,iea.attribute14 attribute14
5671: ,iea.attribute15 attribute15
5672: ,iea.object_version_number object_version_number
5673: FROM csi_i_extended_attribs iea, csi_item_instances ia
5674: WHERE iea.attribute_level = 'ITEM'
5675: AND iea.inventory_item_id = ia.inventory_item_id --p_inv_item_id
5676: AND iea.master_organization_id = ia.inv_master_organization_id --p_org_id;
5677: AND ia.instance_id = p_instance_id

Line 5680: INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)

5676: AND iea.master_organization_id = ia.inv_master_organization_id --p_org_id;
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

Line 5712: FROM csi_i_extended_attribs iea

5708: ,iea.attribute13 attribute13
5709: ,iea.attribute14 attribute14
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

Line 5822: 'FROM csi_iea_values cv, csi_i_extended_attribs ca ' ||

5818: ',cv.attribute13 attribute13' ||
5819: ',cv.attribute14 attribute14' ||
5820: ',cv.attribute15 attribute15' ||
5821: ',cv.object_version_number object_version_number '||
5822: 'FROM csi_iea_values cv, csi_i_extended_attribs ca ' ||
5823: 'WHERE cv.attribute_id = ca.attribute_id' ;
5824:
5825: l_select_stmt := l_select_stmt || ' AND '||l_where_clause;
5826: