APPS.EDW_ITEMS_M_C dependencies on EDW_ITEM_PROD_CATG_LCV

Line 3642: FROM edw_item_prod_catg_lcv

3638: user_attribute5 USER_ATTRIBUTE5,
3639: creation_date CREATION_DATE,
3640: deletion_date DELETION_DATE,
3641: last_update_date LAST_UPDATE_DATE
3642: FROM edw_item_prod_catg_lcv
3643: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
3644:
3645: edw_log.put_line('Pushing Product Category to lower level EDW_ITEM_PROD_GRP');
3646:

Line 3661: FROM EDW_ITEM_PROD_CATG_LCV

3657: SUBSTRB(l_all_prod_grps||'('||NAME||')', 1, 320) NAME,
3658: l_instance, -- INSTANCE_CODE, /* Bug# 2558245 */
3659: 'READY',
3660: LAST_UPDATE_DATE
3661: FROM EDW_ITEM_PROD_CATG_LCV
3662: WHERE LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date;
3663:
3664: edw_log.put_line('Pushing Product Category to lower level EDW_ITEM_ITEM');
3665:

Line 3686: FROM EDW_ITEM_PROD_CATG_LCV

3682: 'NA_EDW',
3683: 'NA_EDW',
3684: 'NA_EDW',
3685: LAST_UPDATE_DATE
3686: FROM EDW_ITEM_PROD_CATG_LCV
3687: WHERE LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date;
3688:
3689: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||
3690: ' rows into the staging table');

Line 3713: FROM EDW_ITEM_PROD_CATG_LCV

3709: 'READY',
3710: 'NA_EDW',
3711: 'NA_EDW',
3712: LAST_UPDATE_DATE
3713: FROM EDW_ITEM_PROD_CATG_LCV
3714: WHERE LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date;
3715:
3716: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT, 0)) ||
3717: 'rows into the staging table');

Line 3736: FROM EDW_ITEM_PROD_CATG_LCV

3732: l_instance, -- INSTANCE_CODE, /* Bug# 2558245 */
3733: SUBSTRB(l_all_item_revs||'('||NAME||')', 1, 320) NAME,
3734: 'READY',
3735: LAST_UPDATE_DATE
3736: FROM EDW_ITEM_PROD_CATG_LCV
3737: WHERE LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date;
3738:
3739: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT, 0)) ||
3740: ' rows into the staging table');