APPS.ICX_CAT_FPI_UPGRADE dependencies on ICX_CAT_CATEGORIES_TL

Line 358: FROM icx_cat_categories_tl cat

354: INTO xRtCategoryId
355: FROM icx_cat_category_items ci
356: WHERE ci.rt_item_id = pRtItemId
357: AND EXISTS (SELECT 'primary category'
358: FROM icx_cat_categories_tl cat
359: WHERE cat.rt_category_id = ci.rt_category_id
360: AND cat.type = ICX_POR_EXT_CLASS.CATEGORY_TYPE)
361: AND ROWNUM = 1;
362: RETURN xRtCategoryId;

Line 1612: FROM icx_cat_categories_tl cat

1608: -- store old_rt_item_id during the upgrade process
1609: PROCEDURE updateExtItemsTLP IS
1610: CURSOR cAllCategories IS
1611: SELECT cat.rt_category_id
1612: FROM icx_cat_categories_tl cat
1613: WHERE cat.type = ICX_POR_EXT_CLASS.CATEGORY_TYPE
1614: AND cat.language = (SELECT language_code
1615: FROM fnd_languages
1616: WHERE installed_flag = 'B')

Line 1958: --so join with icx_cat_categories_tl to get the valid category

1954: gl_sets_of_books gsb,
1955: financials_system_params_all fsp,
1956: --Bug#3581356
1957: --Since categories are already upgraded,
1958: --so join with icx_cat_categories_tl to get the valid category
1959: icx_cat_categories_tl ictl
1960: WHERE mi.inventory_item_id = xInventoryItemIds(i)
1961: AND fsp.org_id = xOrgIds(i)
1962: AND mi.organization_id = fsp.inventory_organization_id

Line 1959: icx_cat_categories_tl ictl

1955: financials_system_params_all fsp,
1956: --Bug#3581356
1957: --Since categories are already upgraded,
1958: --so join with icx_cat_categories_tl to get the valid category
1959: icx_cat_categories_tl ictl
1960: WHERE mi.inventory_item_id = xInventoryItemIds(i)
1961: AND fsp.org_id = xOrgIds(i)
1962: AND mi.organization_id = fsp.inventory_organization_id
1963: AND mi.inventory_item_id = mic.inventory_item_id

Line 1966: --Join with icx_cat_categories_tl to get the valid category

1962: AND mi.organization_id = fsp.inventory_organization_id
1963: AND mi.inventory_item_id = mic.inventory_item_id
1964: AND mic.organization_id = mi.organization_id
1965: --Bug#3581356
1966: --Join with icx_cat_categories_tl to get the valid category
1967: --Add the join between gl_sets_of_books and
1968: --financials_system_params_all
1969: AND fsp.set_of_books_id = gsb.set_of_books_id
1970: AND ictl.key = to_char(mic.category_id)

Line 2511: FROM icx_cat_categories_tl

2507: SELECT 1
2508: INTO xResult
2509: FROM dual
2510: WHERE EXISTS (SELECT 'schema records'
2511: FROM icx_cat_categories_tl
2512: WHERE rt_category_id > 0)
2513: OR EXISTS (SELECT 'data records'
2514: FROM icx_cat_items_b);
2515: RETURN xResult;