APPS.EDW_ITEMS_M_C dependencies on EDW_ITEM_ITEM_TEMP

Line 1170: INSERT INTO EDW_ITEM_ITEM_TEMP(

1166:
1167: edw_log.put_line(' ');
1168: edw_log.put_line('Pushing EDW_ITEM_ITEM');
1169:
1170: INSERT INTO EDW_ITEM_ITEM_TEMP(
1171: CREATION_DATE,
1172: CATSET1_CATEGORY_FK,
1173: CATSET1_CATEGORY_FK_KEY,
1174: CATSET2_CATEGORY_FK,

Line 1251: INSERT INTO EDW_ITEM_ITEM_TEMP(

1247: LOOP
1248: FETCH category_assignments_cursor INTO category_assignments_rec;
1249: EXIT WHEN category_assignments_cursor%notfound;*/
1250:
1251: INSERT INTO EDW_ITEM_ITEM_TEMP(
1252: CREATION_DATE,
1253: CATSET1_CATEGORY_FK,
1254: CATSET1_CATEGORY_FK_KEY,
1255: CATSET2_CATEGORY_FK,

Line 1344: UPDATE EDW_ITEM_ITEM_TEMP

1340: /* Bug# 2631155 added DECODE by dsakalle */
1341: /* Bug# 2559696 Removed the use of EDW_ITEMS_CATEGORY_FKV By dsakalle */
1342:
1343: IF (l_item_catset3_name = 'NA_EDW') THEN
1344: UPDATE EDW_ITEM_ITEM_TEMP
1345: SET CATSET1_CATEGORY_FK =
1346: (SELECT DECODE(COUNT(cat.category_id), 1, TO_CHAR(2)||'-'||MAX(cat.category_id) || '-' || l_instance, 'NA_EDW')
1347: FROM
1348: MTL_ITEM_CATEGORIES cat,

Line 1372: UPDATE EDW_ITEM_ITEM_TEMP

1368: product_group_fk_key, instance);
1369:
1370: COMMIT;
1371: ELSE
1372: UPDATE EDW_ITEM_ITEM_TEMP
1373: SET CATSET1_CATEGORY_FK =
1374: (SELECT DECODE(COUNT(cat.category_id), 1, TO_CHAR(2)||'-'||MAX(cat.category_id) || '-' || l_instance, 'NA_EDW')
1375: FROM
1376: MTL_ITEM_CATEGORIES cat,

Line 1409: UPDATE EDW_ITEM_ITEM_TEMP

1405:
1406: COMMIT;
1407: END IF;
1408:
1409: UPDATE EDW_ITEM_ITEM_TEMP
1410: SET
1411: CATSET1_CATEGORY_FK = NVL(CATSET1_CATEGORY_FK, 'NA_EDW'),
1412: CATSET2_CATEGORY_FK = NVL(CATSET2_CATEGORY_FK, 'NA_EDW'),
1413: CATSET3_CATEGORY_FK = NVL(CATSET3_CATEGORY_FK, 'NA_EDW'),

Line 1482: FROM EDW_ITEM_ITEM_TEMP;

1478: USER_ATTRIBUTE5,
1479: NULL, -- OPERATION_CODE
1480: 'READY',
1481: ITEM_TYPE /* Enh# 2544906 */
1482: FROM EDW_ITEM_ITEM_TEMP;
1483: COMMIT;
1484:
1485: edw_log.put_line('Pushing EDW_ITEM_ITEM records to Item Org level');
1486: