APPS.EGO_IMPORT_UTIL_PVT dependencies on MTL_DEFAULT_CATEGORY_SETS

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

1701: AND mici.REQUEST_ID = l_request_id
1702: AND mici.TRANSACTION_TYPE = 'CREATE'
1703: AND mici.PROCESS_FLAG = 7
1704: AND msik.STYLE_ITEM_FLAG = 'N'
1705: AND NOT EXISTS (SELECT 1 FROM MTL_DEFAULT_CATEGORY_SETS dcs WHERE dcs.CATEGORY_SET_ID = mici.CATEGORY_SET_ID)
1706: AND NOT EXISTS (SELECT 1
1707: FROM MTL_ITEM_CATEGORIES mic
1708: WHERE mic.CATEGORY_SET_ID = mici.CATEGORY_SET_ID
1709: AND mic.CATEGORY_ID = mici.CATEGORY_ID

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

1785: OR (NVL(p_skus_only, 'Y') = 'N' AND NVL(MSII.STYLE_ITEM_FLAG, 'Y') = 'Y')
1786: )
1787: AND MSII.ORGANIZATION_ID = O.ORGANIZATION_ID
1788: AND O.ORGANIZATION_ID = O.MASTER_ORGANIZATION_ID
1789: AND NOT EXISTS (SELECT 1 FROM MTL_DEFAULT_CATEGORY_SETS DCS WHERE DCS.CATEGORY_SET_ID = STYLE_CATS.CATEGORY_SET_ID)
1790: AND STYLE_CATS.INVENTORY_ITEM_ID = MSII.COPY_ITEM_ID
1791: AND STYLE_CATS.ORGANIZATION_ID = MSII.ORGANIZATION_ID
1792: AND NOT EXISTS (SELECT NULL
1793: FROM MTL_ITEM_CATEGORIES_INTERFACE MICI

Line 3636: FROM MTL_DEFAULT_CATEGORY_SETS DCS

3632: AND MSII.STYLE_ITEM_FLAG = 'N'
3633: AND MSII.ORGANIZATION_ID = O.ORGANIZATION_ID
3634: AND O.ORGANIZATION_ID = O.MASTER_ORGANIZATION_ID
3635: AND NOT EXISTS (SELECT 1
3636: FROM MTL_DEFAULT_CATEGORY_SETS DCS
3637: WHERE DCS.CATEGORY_SET_ID = STYLE_CATS.CATEGORY_SET_ID
3638: )
3639: AND STYLE_CATS.INVENTORY_ITEM_ID = MSII.STYLE_ITEM_ID
3640: AND STYLE_CATS.ORGANIZATION_ID = MSII.ORGANIZATION_ID;