APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on MTL_CATEGORIES_B

Line 4151: FROM mtl_categories_b mtlb

4147: IF (ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
4148: l_err_loc := 200;
4149: OPEN p_invalid_category_csr FOR
4150: SELECT mtlb.category_id
4151: FROM mtl_categories_b mtlb
4152: WHERE mtlb.structure_id = ICX_CAT_UTIL_PVT.g_structure_id
4153: AND (NVL(mtlb.end_date_active, SYSDATE + 1) < SYSDATE
4154: OR NVL(mtlb.disable_date, SYSDATE + 1) < SYSDATE)
4155: AND EXISTS (SELECT 'x' FROM icx_cat_items_ctx_hdrs_tlp hdrs

Line 4162: FROM mtl_categories_b mtlb,

4158: ELSE
4159: l_err_loc := 300;
4160: OPEN p_invalid_category_csr FOR
4161: SELECT mtlb.category_id
4162: FROM mtl_categories_b mtlb,
4163: mtl_category_set_valid_cats mcsvc
4164: WHERE mtlb.structure_id = ICX_CAT_UTIL_PVT.g_structure_id
4165: AND (NVL(mtlb.end_date_active, SYSDATE + 1) < SYSDATE
4166: OR NVL(mtlb.disable_date, SYSDATE + 1) < SYSDATE)