DBA Data[Home] [Help]

APPS.EDW_ITEMS_M_C dependencies on EDW_ITEM_ONETIME_ITEMORG_LCV

Line 1028: FROM EDW_ITEM_ONETIME_ITEMORG_LCV

1024: USER_ATTRIBUTE4,
1025: USER_ATTRIBUTE5,
1026: NULL, -- OPERATION_CODE
1027: 'READY'
1028: FROM EDW_ITEM_ONETIME_ITEMORG_LCV
1029: WHERE last_update_date BETWEEN l_push_date_range1 AND l_push_date_range2;
1030:
1031: l_rows_inserted := SQL%ROWCOUNT;
1032: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||

Line 1092: FROM EDW_ITEM_ONETIME_ITEMORG_LCV

1088: SUBSTRB(ITEM_ORG_PK || '-' || l_instance,1,307) || '-ONETIME' || '-IORG',
1089: SUBSTRB(l_all_item_revs || '(' || NAME || ')',1,320),
1090: l_instance,
1091: 'READY' --COLLECTION_STATUS
1092: FROM EDW_ITEM_ONETIME_ITEMORG_LCV
1093: WHERE last_update_date BETWEEN l_push_date_range1 AND l_push_date_range2;
1094:
1095: l_rows_inserted := SQL%ROWCOUNT;
1096: edw_log.put_line('Inserted '||TO_CHAR(NVL(SQL%ROWCOUNT,0))||