APPS.EDW_ITEMS_M_C dependencies on EDW_ITEM_ITEM_LCV

Line 1232: FROM EDW_ITEM_ITEM_LCV

1228: USER_ATTRIBUTE5,
1229: NULL, -- OPERATION_CODE
1230: 'READY',
1231: ITEM_TYPE /* Enh# 2544906 */
1232: FROM EDW_ITEM_ITEM_LCV
1233: WHERE last_update_date BETWEEN l_push_date_range1 AND l_push_date_range2;
1234:
1235: l_rows_inserted := l_rows_inserted + SQL%ROWCOUNT;
1236: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||

Line 1313: FROM EDW_ITEM_ITEM_LCV eil,

1309: USER_ATTRIBUTE5,
1310: NULL, -- OPERATION_CODE
1311: 'READY',
1312: ITEM_TYPE /* Enh# 2544906 */
1313: FROM EDW_ITEM_ITEM_LCV eil,
1314: (
1315: SELECT
1316: MIC.INVENTORY_ITEM_ID,
1317: MIC.ORGANIZATION_ID

Line 1507: FROM edw_item_item_lcv

1503: l_instance, --INSTANCE, /* Bug# 2558245 */
1504: 'READY',
1505: 'NA_EDW',
1506: 'NA_EDW'
1507: FROM edw_item_item_lcv
1508: WHERE last_update_date BETWEEN l_push_date_range1 AND l_push_date_range2;
1509:
1510: l_rows_inserted := SQL%ROWCOUNT;
1511: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||

Line 1534: FROM edw_item_item_lcv

1530: ORGANIZATION_ID,
1531: SUBSTRB(l_all_item_revs || '(' || NAME || ')', 1, 320),
1532: l_instance, --INSTANCE, /* Bug# 2558245 */
1533: 'READY'
1534: FROM edw_item_item_lcv
1535: WHERE last_update_date BETWEEN l_push_date_range1 AND l_push_date_range2;
1536:
1537: l_rows_inserted := SQL%ROWCOUNT;
1538: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||