APPS.EDW_ITEMS_M_C dependencies on EDW_ITEM_ITEM_CAT_LCV

Line 2649: l_view_name:='edw_item_item_cat_lcv';

2645: -- dynamic sql necessary for all the 16 staging tables
2646: edw_log.put_line('Determining the collection view to SELECT FROM');
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:

Line 2855: FROM EDW_ITEM_ITEM_CAT_LCV LCV

2851: USER_ATTRIBUTE4,
2852: USER_ATTRIBUTE5,
2853: NULL,
2854: 'READY'
2855: FROM EDW_ITEM_ITEM_CAT_LCV LCV
2856: WHERE LCV.LAST_UPDATE_DATE BETWEEN l_push_date_range1 AND l_push_date_range2
2857: AND LCV.CATEGORY_SET_NAME = l_item_catset3_name
2858: AND NOT EXISTS
2859: (SELECT NULL

Line 3033: FROM EDW_ITEM_ITEM_CAT_LCV LCV

3029: USER_ATTRIBUTE4,
3030: USER_ATTRIBUTE5,
3031: NULL,
3032: 'READY'
3033: FROM EDW_ITEM_ITEM_CAT_LCV LCV
3034: WHERE LCV.LAST_UPDATE_DATE BETWEEN l_push_date_range1 AND l_push_date_range2
3035: AND LCV.CATEGORY_SET_NAME = l_item_catset3_name
3036: AND NOT EXISTS
3037: (SELECT NULL