APPS.EDW_ITEMS_M_C dependencies on EDW_ITEM_ONETIME_ITEM_LCV

Line 1604: FROM EDW_ITEM_ONETIME_ITEM_LCV

1600: USER_ATTRIBUTE4,
1601: USER_ATTRIBUTE5,
1602: OPERATION_CODE,
1603: 'READY'
1604: FROM EDW_ITEM_ONETIME_ITEM_LCV
1605: WHERE last_update_date BETWEEN l_push_date_range1 AND l_push_date_range2;
1606:
1607: l_rows_inserted := SQL%ROWCOUNT;
1608: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||

Line 1631: FROM edw_item_onetime_item_lcv

1627: l_instance, --INSTANCE, /* Bug# 2558245 */
1628: 'READY',
1629: 'NA_EDW',
1630: 'NA_EDW'
1631: FROM edw_item_onetime_item_lcv
1632: WHERE last_update_date BETWEEN l_push_date_range1 AND l_push_date_range2;
1633:
1634: l_rows_inserted := SQL%ROWCOUNT;
1635: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||

Line 1652: FROM edw_item_onetime_item_lcv

1648: SUBSTRB(ITEM_NUMBER_PK || '-' || l_instance,1,307) || '-ONETIME' || '-ITEM', /* Bug# 2558245 */
1649: SUBSTRB(l_all_item_revs || '(' || NAME || ')', 1, 320),
1650: l_instance, --INSTANCE, /* Bug# 2558245 */
1651: 'READY'
1652: FROM edw_item_onetime_item_lcv
1653: WHERE last_update_date BETWEEN l_push_date_range1 AND l_push_date_range2;
1654:
1655: l_rows_inserted := SQL%ROWCOUNT;
1656: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||