APPS.EDW_ITEMS_M_C dependencies on EDW_ITEM_PROD_GRP_LCV

Line 3808: FROM edw_item_prod_grp_lcv

3804: USER_ATTRIBUTE5 USER_ATTRIBUTE5,
3805: CREATION_DATE CREATION_DATE,
3806: DELETION_DATE DELETION_DATE,
3807: LAST_UPDATE_DATE LAST_UPDATE_DATE
3808: FROM edw_item_prod_grp_lcv
3809: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
3810:
3811: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT, 0)) ||
3812: ' rows into the staging table');

Line 3831: FROM EDW_ITEM_PROD_GRP_LCV

3827: SUBSTRB(l_all_item_revs||'('||NAME||')', 1, 320) NAME,
3828: l_instance, -- INSTANCE_CODE, /* Bug# 2558245 */
3829: 'READY',
3830: LAST_UPDATE_DATE
3831: FROM EDW_ITEM_PROD_GRP_LCV
3832: WHERE LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date;
3833:
3834: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT, 0)) ||
3835: ' rows into the staging table');

Line 3858: FROM EDW_ITEM_PROD_GRP_LCV

3854: 'READY',
3855: 'NA_EDW',
3856: 'NA_EDW',
3857: LAST_UPDATE_DATE
3858: FROM EDW_ITEM_PROD_GRP_LCV
3859: WHERE LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date;
3860:
3861: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT, 0)) ||
3862: 'rows into the staging table');

Line 3887: FROM EDW_ITEM_PROD_GRP_LCV

3883: 'NA_EDW',
3884: 'NA_EDW',
3885: 'NA_EDW',
3886: LAST_UPDATE_DATE
3887: FROM EDW_ITEM_PROD_GRP_LCV
3888: WHERE LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date;
3889:
3890: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0)) ||
3891: ' rows into the stagint table');