APPS.EDW_ITEMS_M_C dependencies on EDW_ITEM_ITEMORG_LCV

Line 551: FROM EDW_ITEM_ITEMORG_LCV

547: USER_ATTRIBUTE5,
548: NULL, -- OPERATION_CODE
549: 'READY',
550: ITEM_TYPE /* Enh# 2544906 */
551: FROM EDW_ITEM_ITEMORG_LCV
552: WHERE last_update_date BETWEEN l_push_date_range1 AND l_push_date_range2;
553:
554: l_rows_inserted := SQL%ROWCOUNT;
555: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||

Line 690: FROM EDW_ITEM_ITEMORG_LCV

686: USER_ATTRIBUTE5,
687: NULL, -- OPERATION_CODE
688: 'READY',
689: ITEM_TYPE /* Enh# 2544906 */
690: FROM EDW_ITEM_ITEMORG_LCV
691: WHERE inventory_item_id = category_assignments_rec.inventory_item_id
692: AND organization_id = category_assignments_rec.organization_id
693: AND last_update_date NOT BETWEEN l_push_date_range1 AND l_push_date_range2; /* Bug# 2659263 */
694:

Line 1065: FROM EDW_ITEM_ITEMORG_LCV

1061: ORGANIZATION_ID,
1062: SUBSTRB(l_all_item_revs || ' (' || NAME || ')', 1, 320),
1063: l_instance,
1064: 'READY'
1065: FROM EDW_ITEM_ITEMORG_LCV
1066: WHERE last_update_date BETWEEN l_push_date_range1 AND l_push_date_range2;
1067:
1068: l_rows_inserted := SQL%ROWCOUNT;
1069: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||