APPS.CSI_ITEM_INSTANCE_PUB dependencies on CSI_I_EXTENDED_ATTRIBS

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

5638: l_trace_enable_flag VARCHAR2(1) :='N';
5639: l_row NUMBER := 0;
5640:
5641: CURSOR ext_attrib_csr (p_instance_id NUMBER) IS
5642: SELECT /*+ INDEX(iea CSI_I_EXTENDED_ATTRIBS_N04)*/ -- Added by sguthiva for bug 2367664
5643: iea.attribute_id attribute_id
5644: ,iea.attribute_level attribute_level
5645: ,iea.master_organization_id master_organization_id
5646: ,iea.inventory_item_id inventory_item_id

Line 5672: FROM csi_i_extended_attribs iea

5668: ,iea.attribute13 attribute13
5669: ,iea.attribute14 attribute14
5670: ,iea.attribute15 attribute15
5671: ,iea.object_version_number object_version_number
5672: FROM csi_i_extended_attribs iea
5673: WHERE attribute_level = 'GLOBAL'
5674: UNION ALL
5675: SELECT /*+ INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)*/ -- Added by sguthiva for bug 2367664
5676: iea.attribute_id attribute_id

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

5671: ,iea.object_version_number object_version_number
5672: FROM csi_i_extended_attribs iea
5673: WHERE attribute_level = 'GLOBAL'
5674: UNION ALL
5675: SELECT /*+ INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)*/ -- Added by sguthiva for bug 2367664
5676: iea.attribute_id attribute_id
5677: ,iea.attribute_level attribute_level
5678: ,iea.master_organization_id master_organization_id
5679: ,iea.inventory_item_id inventory_item_id

Line 5705: FROM csi_i_extended_attribs iea

5701: ,iea.attribute13 attribute13
5702: ,iea.attribute14 attribute14
5703: ,iea.attribute15 attribute15
5704: ,iea.object_version_number object_version_number
5705: FROM csi_i_extended_attribs iea
5706: WHERE attribute_level = 'INSTANCE'
5707: AND instance_id = p_instance_id
5708: UNION ALL
5709: SELECT /*+ INDEX(ia CSI_ITEM_INSTANCES_U01)

Line 5710: INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)

5706: WHERE attribute_level = 'INSTANCE'
5707: AND instance_id = p_instance_id
5708: UNION ALL
5709: SELECT /*+ INDEX(ia CSI_ITEM_INSTANCES_U01)
5710: INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)
5711: */ -- Added by sguthiva for bug 2367664
5712: iea.attribute_id attribute_id
5713: ,iea.attribute_level attribute_level
5714: ,iea.master_organization_id master_organization_id

Line 5741: FROM csi_i_extended_attribs iea, csi_item_instances ia

5737: ,iea.attribute13 attribute13
5738: ,iea.attribute14 attribute14
5739: ,iea.attribute15 attribute15
5740: ,iea.object_version_number object_version_number
5741: FROM csi_i_extended_attribs iea, csi_item_instances ia
5742: WHERE iea.attribute_level = 'ITEM'
5743: AND iea.inventory_item_id = ia.inventory_item_id --p_inv_item_id
5744: AND iea.master_organization_id = ia.inv_master_organization_id --p_org_id;
5745: AND ia.instance_id = p_instance_id

Line 5748: INDEX(iea CSI_I_EXTENDED_ATTRIBS_N01)

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

Line 5780: FROM csi_i_extended_attribs iea

5776: ,iea.attribute13 attribute13
5777: ,iea.attribute14 attribute14
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

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

5886: ',cv.attribute13 attribute13' ||
5887: ',cv.attribute14 attribute14' ||
5888: ',cv.attribute15 attribute15' ||
5889: ',cv.object_version_number object_version_number '||
5890: 'FROM csi_iea_values cv, csi_i_extended_attribs ca ' ||
5891: 'WHERE cv.attribute_id = ca.attribute_id' ;
5892:
5893: l_select_stmt := l_select_stmt || ' AND '||l_where_clause;
5894: