APPS.CLN_SYNCITEM_PKG dependencies on MTL_ITEM_CATEGORIES

Line 185: FROM mtl_item_categories mic, mtl_category_set_valid_cats mcsvc

181: WHERE ORGANIZATION_ID= p_inventory_org_id
182: AND ( p_category_set_id IS NULL OR
183: p_category_set_id IN
184: ( SELECT mcsvc.category_set_id
185: FROM mtl_item_categories mic, mtl_category_set_valid_cats mcsvc
186: WHERE mcsvc.category_set_id = mic.category_set_id AND
187: mic.inventory_item_id = CLN_ITEMMST_ITEMHEADER_V.INVENTORY_ITEM_ID AND
188: mic.organization_id = p_inventory_org_id
189: )

Line 194: FROM mtl_item_categories mic, mtl_category_set_valid_cats mcsvc

190: )
191: AND ( p_category_id IS NULL OR
192: p_category_id IN
193: ( SELECT mcsvc.category_id
194: FROM mtl_item_categories mic, mtl_category_set_valid_cats mcsvc
195: WHERE mcsvc.category_id = mic.category_id AND
196: mic.inventory_item_id = CLN_ITEMMST_ITEMHEADER_V.INVENTORY_ITEM_ID AND
197: mic.organization_id = p_inventory_org_id
198: )

Line 344: FROM mtl_item_categories mic,

340: ( ( NVL (fnd_profile.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY'),'N') = 'Y' AND mci.customer_item_number IS NOT NULL ) OR
341: NVL (fnd_profile.VALUE ('CLN_ITEM_SEND_CUST_XREF_ONLY'), 'N') ='N' ) AND
342: ( p_category_set_id IS NULL OR p_category_set_id IN
343: ( SELECT mcsvc.category_set_id
344: FROM mtl_item_categories mic,
345: mtl_category_set_valid_cats mcsvc
346: WHERE mcsvc.category_set_id = mic.category_set_id AND
347: mic.inventory_item_id = msib.INVENTORY_ITEM_ID AND
348: mic.organization_id = p_inventory_org_id )

Line 352: FROM mtl_item_categories mic

348: mic.organization_id = p_inventory_org_id )
349: ) AND
350: ( p_category_id IS NULL OR p_category_id IN
351: ( SELECT mic.category_id
352: FROM mtl_item_categories mic
353: WHERE mic.category_id = p_category_id AND
354: mic.inventory_item_id = msib.INVENTORY_ITEM_ID AND
355: mic.organization_id = p_inventory_org_id )
356: )AND