DBA Data[Home] [Help]

APPS.ICX_CAT_POPULATE_ITEM_PVT dependencies on MTL_CATEGORIES_B

Line 4176: FROM mtl_categories_b mtlb

4172: IF (ICX_CAT_UTIL_PVT.g_validate_flag = 'N') THEN
4173: l_err_loc := 200;
4174: OPEN p_invalid_category_csr FOR
4175: SELECT mtlb.category_id
4176: FROM mtl_categories_b mtlb
4177: WHERE mtlb.structure_id = ICX_CAT_UTIL_PVT.g_structure_id
4178: AND (NVL(mtlb.end_date_active, SYSDATE + 1) < SYSDATE
4179: OR NVL(mtlb.disable_date, SYSDATE + 1) < SYSDATE)
4180: AND EXISTS (SELECT 'x' FROM icx_cat_items_ctx_hdrs_tlp hdrs

Line 4187: FROM mtl_categories_b mtlb,

4183: ELSE
4184: l_err_loc := 300;
4185: OPEN p_invalid_category_csr FOR
4186: SELECT mtlb.category_id
4187: FROM mtl_categories_b mtlb,
4188: mtl_category_set_valid_cats mcsvc
4189: WHERE mtlb.structure_id = ICX_CAT_UTIL_PVT.g_structure_id
4190: AND (NVL(mtlb.end_date_active, SYSDATE + 1) < SYSDATE
4191: OR NVL(mtlb.disable_date, SYSDATE + 1) < SYSDATE)