APPS.EDW_ITEMS_M_C dependencies on EDW_ITEM_ITEMORG_TEMP

Line 431: INSERT INTO EDW_ITEM_ITEMORG_TEMP(

427:
428: l_rows_inserted := 0;
429: l_commit_count := 0;
430:
431: INSERT INTO EDW_ITEM_ITEMORG_TEMP(
432: APPROVED_SUPPLIER,
433: BUYER_FK,
434: CREATION_DATE,
435: CATSET_CATEGORY_FK,

Line 570: INSERT INTO EDW_ITEM_ITEMORG_TEMP(

566: LOOP
567: FETCH category_assignments_cursor INTO category_assignments_rec;
568: EXIT WHEN category_assignments_cursor%NOTFOUND;
569:
570: INSERT INTO EDW_ITEM_ITEMORG_TEMP(
571: APPROVED_SUPPLIER,
572: BUYER_FK,
573: CREATION_DATE,
574: CATSET_CATEGORY_FK,

Line 708: UPDATE EDW_ITEM_ITEMORG_TEMP

704:
705: /* Bug# 2631155 added DECODE by dsakalle */
706: /* Bug# 2559696 Removed the use of EDW_ITEMS_CATEGORY_FKV by dsakalle */
707:
708: UPDATE EDW_ITEM_ITEMORG_TEMP
709: SET CATSET_CATEGORY_FK =
710: (SELECT DECODE(COUNT(cat.category_id), 1, TO_CHAR(1)||'-'||MAX(cat.category_id) || '-' || l_instance, 'NA_EDW')
711: FROM
712: MTL_ITEM_CATEGORIES cat,

Line 735: UPDATE EDW_ITEM_ITEMORG_TEMP

731:
732: edw_log.put_line('Resolving lookups for staging table records');
733: edw_log.put_line(' ');
734:
735: UPDATE EDW_ITEM_ITEMORG_TEMP
736: SET MAKE_OR_BUY_FLAG =
737: (SELECT lkup.meaning
738: FROM mfg_lookups lkup
739: WHERE lkup.lookup_type = 'MTL_PLANNING_MAKE_BUY'

Line 911: FROM EDW_ITEM_ITEMORG_TEMP;

907: USER_ATTRIBUTE5,
908: NULL, -- OPERATION_CODE
909: 'READY',
910: ITEM_TYPE /* Enh# 2544906 */
911: FROM EDW_ITEM_ITEMORG_TEMP;
912:
913: COMMIT;
914:
915: IF l_collect_onetime = 'Y' THEN