APPS.EDW_ITEMS_M_C dependencies on EDW_ITEM_PROD_LINE_LCV

Line 3452: FROM EDW_ITEM_PROD_LINE_LCV

3448: USER_ATTRIBUTE5 USER_ATTRIBUTE5,
3449: CREATION_DATE CREATION_DATE,
3450: DELETION_DATE DELETION_DATE,
3451: LAST_UPDATE_DATE LAST_UPDATE_DATE
3452: FROM EDW_ITEM_PROD_LINE_LCV
3453: WHERE last_update_date BETWEEN p_from_date AND p_to_date;
3454:
3455: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0)) ||' rows into the staging table');
3456: edw_log.put_line('');

Line 3474: FROM EDW_ITEM_PROD_LINE_LCV

3470: SUBSTRB(l_all_prod_cats||'('||NAME||')', 1, 320) NAME,
3471: l_instance, -- INSTANCE_CODE, /* Bug# 2558245 */
3472: 'READY',
3473: LAST_UPDATE_DATE
3474: FROM EDW_ITEM_PROD_LINE_LCV
3475: WHERE LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date;
3476:
3477: edw_log.put_line('Pushing Product Line to lower level EDW_ITEM_PROD_GRP');
3478:

Line 3493: FROM EDW_ITEM_PROD_LINE_LCV

3489: SUBSTRB(l_all_prod_grps||'('||NAME||')', 1, 320) NAME,
3490: l_instance, -- INSTANCE_CODE, /* Bug# 2558245 */
3491: 'READY',
3492: LAST_UPDATE_DATE
3493: FROM EDW_ITEM_PROD_LINE_LCV
3494: WHERE LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date;
3495:
3496: edw_log.put_line('Pushing Product Line to lower level EDW_ITEM_ITEM');
3497:

Line 3518: FROM EDW_ITEM_PROD_LINE_LCV

3514: 'NA_EDW',
3515: 'NA_EDW',
3516: 'NA_EDW',
3517: LAST_UPDATE_DATE
3518: FROM EDW_ITEM_PROD_LINE_LCV
3519: WHERE LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date;
3520:
3521: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||
3522: ' rows into the staging table');

Line 3545: FROM EDW_ITEM_PROD_LINE_LCV

3541: 'READY',
3542: 'NA_EDW',
3543: 'NA_EDW',
3544: LAST_UPDATE_DATE
3545: FROM EDW_ITEM_PROD_LINE_LCV
3546: WHERE LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date;
3547:
3548: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT, 0)) ||
3549: 'rows into the staging table');

Line 3568: FROM EDW_ITEM_PROD_LINE_LCV

3564: SUBSTRB(l_all_item_revs||'('||NAME||')', 1, 320) NAME,
3565: l_instance, -- INSTANCE_CODE, /* Bug# 2558245 */
3566: 'READY',
3567: LAST_UPDATE_DATE
3568: FROM EDW_ITEM_PROD_LINE_LCV
3569: WHERE LAST_UPDATE_DATE BETWEEN p_from_date AND p_to_date;
3570:
3571: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT, 0)) ||
3572: ' rows into the staging table');