APPS.CSTPCOIC dependencies on MTL_ITEM_CATEGORIES

Line 113: ' FROM MTL_ITEM_CATEGORIES MIC'||

109: l_sql_stmnt := l_sql_stmnt ||' AND CIC.INVENTORY_ITEM_ID = :spec_item_id';
110: ELSIF (range_option = 5) THEN /* -- SPECIFIC CATEGORY -- */
111: l_sql_stmnt := l_sql_stmnt ||' AND CIC.INVENTORY_ITEM_ID IN '||
112: ' ( SELECT INVENTORY_ITEM_ID'||
113: ' FROM MTL_ITEM_CATEGORIES MIC'||
114: ' WHERE MIC.ORGANIZATION_ID = :to_org_id3'||
115: ' AND MIC.CATEGORY_SET_ID = :spec_cat_set_id'||
116: ' AND MIC.CATEGORY_ID = DECODE(:spec_cat_id,0,MIC.CATEGORY_ID,:spec_cat_id2)'||
117: ')';

Line 178: FROM MTL_ITEM_CATEGORIES MIC

174: /* -- SPECIFIC CATEGORY -- */
175: ( (range_option = 5) AND EXISTS
176: (
177: SELECT INVENTORY_ITEM_ID
178: FROM MTL_ITEM_CATEGORIES MIC
179: WHERE MIC.ORGANIZATION_ID = to_org_id
180: AND MIC.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
181: AND MIC.CATEGORY_SET_ID = spec_cat_set_id
182: AND MIC.CATEGORY_ID = DECODE(spec_cat_id,0,MIC.CATEGORY_ID,spec_cat_id)

Line 206: FROM MTL_ITEM_CATEGORIES MIC

202: /* -- SPECIFIC CATEGORY -- */
203: ( (range_option = 5) AND EXISTS
204: (
205: SELECT INVENTORY_ITEM_ID
206: FROM MTL_ITEM_CATEGORIES MIC
207: WHERE MIC.ORGANIZATION_ID = to_org_id
208: AND MIC.INVENTORY_ITEM_ID = CICD.INVENTORY_ITEM_ID
209: AND MIC.CATEGORY_SET_ID = spec_cat_set_id
210: AND MIC.CATEGORY_ID = DECODE(spec_cat_id,0,MIC.CATEGORY_ID,spec_cat_id)

Line 245: FROM MTL_ITEM_CATEGORIES MIC

241: /* -- SPECIFIC CATEGORY -- */
242: ( (range_option = 5) AND EXISTS
243: (
244: SELECT INVENTORY_ITEM_ID
245: FROM MTL_ITEM_CATEGORIES MIC
246: WHERE MIC.ORGANIZATION_ID = to_org_id
247: AND MIC.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
248: AND MIC.CATEGORY_SET_ID = spec_cat_set_id
249: AND MIC.CATEGORY_ID = DECODE(spec_cat_id,0,MIC.CATEGORY_ID,spec_cat_id)

Line 283: FROM MTL_ITEM_CATEGORIES MIC

279: /* -- SPECIFIC CATEGORY -- */
280: ( (range_option = 5) AND EXISTS
281: (
282: SELECT INVENTORY_ITEM_ID
283: FROM MTL_ITEM_CATEGORIES MIC
284: WHERE MIC.ORGANIZATION_ID = to_org_id
285: AND MIC.INVENTORY_ITEM_ID = CICD.INVENTORY_ITEM_ID
286: AND MIC.CATEGORY_SET_ID = spec_cat_set_id
287: AND MIC.CATEGORY_ID = DECODE(spec_cat_id,0,MIC.CATEGORY_ID,spec_cat_id)

Line 745: FROM MTL_ITEM_CATEGORIES MIC

741: AND MIF.ORGANIZATION_ID = to_org_id
742: AND MIF.ITEM_ID = CIC.INVENTORY_ITEM_ID
743: AND CIC.INVENTORY_ITEM_ID in (
744: SELECT INVENTORY_ITEM_ID
745: FROM MTL_ITEM_CATEGORIES MIC
746: WHERE MIC.ORGANIZATION_ID = to_org_id
747: AND MIC.CATEGORY_SET_ID = spec_cat_set_id
748: AND MIC.CATEGORY_ID = DECODE(spec_cat_id,0,MIC.CATEGORY_ID,spec_cat_id)
749: )