DBA Data[Home] [Help]

APPS.CSTPCOIC dependencies on MTL_ITEM_CATEGORIES

Line 101: FROM MTL_ITEM_CATEGORIES MIC

97: /* -- SPECIFIC CATEGORY -- */
98: ( (range_option = 5) AND EXISTS
99: (
100: SELECT INVENTORY_ITEM_ID
101: FROM MTL_ITEM_CATEGORIES MIC
102: WHERE MIC.ORGANIZATION_ID = CIC.ORGANIZATION_ID
103: AND MIC.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
104: AND MIC.CATEGORY_SET_ID = spec_cat_set_id
105: AND MIC.CATEGORY_ID = DECODE(spec_cat_id,0,MIC.CATEGORY_ID,spec_cat_id)

Line 166: FROM MTL_ITEM_CATEGORIES MIC

162: /* -- SPECIFIC CATEGORY -- */
163: ( (range_option = 5) AND EXISTS
164: (
165: SELECT INVENTORY_ITEM_ID
166: FROM MTL_ITEM_CATEGORIES MIC
167: WHERE MIC.ORGANIZATION_ID = to_org_id
168: AND MIC.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
169: AND MIC.CATEGORY_SET_ID = spec_cat_set_id
170: AND MIC.CATEGORY_ID = DECODE(spec_cat_id,0,MIC.CATEGORY_ID,spec_cat_id)

Line 194: FROM MTL_ITEM_CATEGORIES MIC

190: /* -- SPECIFIC CATEGORY -- */
191: ( (range_option = 5) AND EXISTS
192: (
193: SELECT INVENTORY_ITEM_ID
194: FROM MTL_ITEM_CATEGORIES MIC
195: WHERE MIC.ORGANIZATION_ID = to_org_id
196: AND MIC.INVENTORY_ITEM_ID = CICD.INVENTORY_ITEM_ID
197: AND MIC.CATEGORY_SET_ID = spec_cat_set_id
198: AND MIC.CATEGORY_ID = DECODE(spec_cat_id,0,MIC.CATEGORY_ID,spec_cat_id)

Line 233: FROM MTL_ITEM_CATEGORIES MIC

229: /* -- SPECIFIC CATEGORY -- */
230: ( (range_option = 5) AND EXISTS
231: (
232: SELECT INVENTORY_ITEM_ID
233: FROM MTL_ITEM_CATEGORIES MIC
234: WHERE MIC.ORGANIZATION_ID = to_org_id
235: AND MIC.INVENTORY_ITEM_ID = CIC.INVENTORY_ITEM_ID
236: AND MIC.CATEGORY_SET_ID = spec_cat_set_id
237: AND MIC.CATEGORY_ID = DECODE(spec_cat_id,0,MIC.CATEGORY_ID,spec_cat_id)

Line 271: FROM MTL_ITEM_CATEGORIES MIC

267: /* -- SPECIFIC CATEGORY -- */
268: ( (range_option = 5) AND EXISTS
269: (
270: SELECT INVENTORY_ITEM_ID
271: FROM MTL_ITEM_CATEGORIES MIC
272: WHERE MIC.ORGANIZATION_ID = to_org_id
273: AND MIC.INVENTORY_ITEM_ID = CICD.INVENTORY_ITEM_ID
274: AND MIC.CATEGORY_SET_ID = spec_cat_set_id
275: AND MIC.CATEGORY_ID = DECODE(spec_cat_id,0,MIC.CATEGORY_ID,spec_cat_id)

Line 733: FROM MTL_ITEM_CATEGORIES MIC

729: AND MIF.ORGANIZATION_ID = to_org_id
730: AND MIF.ITEM_ID = CIC.INVENTORY_ITEM_ID
731: AND CIC.INVENTORY_ITEM_ID in (
732: SELECT INVENTORY_ITEM_ID
733: FROM MTL_ITEM_CATEGORIES MIC
734: WHERE MIC.ORGANIZATION_ID = to_org_id
735: AND MIC.CATEGORY_SET_ID = spec_cat_set_id
736: AND MIC.CATEGORY_ID = DECODE(spec_cat_id,0,MIC.CATEGORY_ID,spec_cat_id)
737: )