APPS.EGO_IMPORT_UTIL_PVT dependencies on MTL_DEFAULT_CATEGORY_SETS

Line 1535: AND NOT EXISTS (SELECT 1 FROM MTL_DEFAULT_CATEGORY_SETS dcs WHERE dcs.CATEGORY_SET_ID = mici.CATEGORY_SET_ID)

1531: AND mici.REQUEST_ID = l_request_id
1532: AND mici.TRANSACTION_TYPE = 'CREATE'
1533: AND mici.PROCESS_FLAG = 7
1534: AND msik.STYLE_ITEM_FLAG = 'N'
1535: AND NOT EXISTS (SELECT 1 FROM MTL_DEFAULT_CATEGORY_SETS dcs WHERE dcs.CATEGORY_SET_ID = mici.CATEGORY_SET_ID)
1536: AND NOT EXISTS (SELECT 1
1537: FROM MTL_ITEM_CATEGORIES mic
1538: WHERE mic.CATEGORY_SET_ID = mici.CATEGORY_SET_ID
1539: AND mic.CATEGORY_ID = mici.CATEGORY_ID

Line 1619: AND NOT EXISTS (SELECT 1 FROM MTL_DEFAULT_CATEGORY_SETS DCS WHERE DCS.CATEGORY_SET_ID = STYLE_CATS.CATEGORY_SET_ID)

1615: OR (NVL(p_skus_only, 'Y') = 'N' AND NVL(MSII.STYLE_ITEM_FLAG, 'Y') = 'Y')
1616: )
1617: AND MSII.ORGANIZATION_ID = O.ORGANIZATION_ID
1618: AND O.ORGANIZATION_ID = O.MASTER_ORGANIZATION_ID
1619: AND NOT EXISTS (SELECT 1 FROM MTL_DEFAULT_CATEGORY_SETS DCS WHERE DCS.CATEGORY_SET_ID = STYLE_CATS.CATEGORY_SET_ID)
1620: AND STYLE_CATS.INVENTORY_ITEM_ID = MSII.COPY_ITEM_ID
1621: AND STYLE_CATS.ORGANIZATION_ID = MSII.ORGANIZATION_ID
1622: AND NOT EXISTS (SELECT NULL
1623: FROM MTL_ITEM_CATEGORIES_INTERFACE MICI

Line 3445: FROM MTL_DEFAULT_CATEGORY_SETS DCS

3441: AND MSII.STYLE_ITEM_FLAG = 'N'
3442: AND MSII.ORGANIZATION_ID = O.ORGANIZATION_ID
3443: AND O.ORGANIZATION_ID = O.MASTER_ORGANIZATION_ID
3444: AND NOT EXISTS (SELECT 1
3445: FROM MTL_DEFAULT_CATEGORY_SETS DCS
3446: WHERE DCS.CATEGORY_SET_ID = STYLE_CATS.CATEGORY_SET_ID
3447: )
3448: AND STYLE_CATS.INVENTORY_ITEM_ID = MSII.STYLE_ITEM_ID
3449: AND STYLE_CATS.ORGANIZATION_ID = MSII.ORGANIZATION_ID;