APPS.EDW_ITEMS_M_C dependencies on EDW_ITEM_ITEM_ORG_CAT_LCV

Line 2612: FROM edw_item_item_org_cat_lcv

2608: CATEGORY_SET_ID,
2609: LAST_UPDATE_DATE,
2610: SUBSTRB('(' || NAME || ')', 1, 320) NAME,
2611: 'READY' COLLECTION_STATUS
2612: FROM edw_item_item_org_cat_lcv
2613: WHERE last_update_date BETWEEN l_push_date_range1 AND l_push_date_range2 AND category_set_name = c_category_set_name;
2614:
2615: -- 3296641
2616: -- CURSOR to push VBH categories down to lower levels

Line 2631: FROM edw_item_item_org_cat_lcv

2627: CATEGORY_SET_ID,
2628: LAST_UPDATE_DATE,
2629: SUBSTRB('(' || NAME || ')', 1, 320) NAME,
2630: 'READY' COLLECTION_STATUS
2631: FROM edw_item_item_org_cat_lcv
2632: WHERE category_set_name = c_category_set_name;
2633:
2634: BEGIN
2635:

Line 2651: l_view_name:='edw_item_item_org_cat_lcv';

2647:
2648: IF p_item_item_org=0 THEN
2649: l_view_name:='edw_item_item_cat_lcv';
2650: ELSE
2651: l_view_name:='edw_item_item_org_cat_lcv';
2652: END IF;
2653:
2654: edw_log.put_line('Determining the control level');
2655: