eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.EDW_ITEMS_M_C dependencies on EDW_ITEM_CATSETI3_C1_LSTG

Line 2807: INSERT INTO EDW_ITEM_CATSETI3_C1_LSTG

2803: -- with an FK of NA_EDW
2804:
2805: BEGIN
2806:
2807: INSERT INTO EDW_ITEM_CATSETI3_C1_LSTG
2808: (CATEGORY_FK,
2809: CATEGORY_FK_KEY,
2810: CATEGORY_NAME,
2811: CATEGORY_SET_NAME,

Line 2860: FROM EDW_ITEM_CATSETI3_C1_LSTG LSTG

2856: WHERE LCV.LAST_UPDATE_DATE BETWEEN l_push_date_range1 AND l_push_date_range2
2857: AND LCV.CATEGORY_SET_NAME = l_item_catset3_name
2858: AND NOT EXISTS
2859: (SELECT NULL
2860: FROM EDW_ITEM_CATSETI3_C1_LSTG LSTG
2861: WHERE SUBSTRB(LSTG.CATEGORY_PK, 3) = LCV.CATEGORY_PK || '-' || l_instance /* Bug 2558245 */
2862: AND LSTG.CATEGORY_SET_NAME = l_item_catset3_name
2863: AND LSTG.COLLECTION_STATUS = 'READY')
2864: AND EXISTS /* Bug# 2559696 Removed the use of EDW_ITEMS_CATEGORY_FKV by dsakalle */

Line 2985: INSERT INTO EDW_ITEM_CATSETI3_C1_LSTG

2981: -- with an FK of NA_EDW
2982:
2983: BEGIN
2984:
2985: INSERT INTO EDW_ITEM_CATSETI3_C1_LSTG
2986: (CATEGORY_FK,
2987: CATEGORY_FK_KEY,
2988: CATEGORY_NAME,
2989: CATEGORY_SET_NAME,

Line 3038: FROM EDW_ITEM_CATSETI3_C1_LSTG LSTG

3034: WHERE LCV.LAST_UPDATE_DATE BETWEEN l_push_date_range1 AND l_push_date_range2
3035: AND LCV.CATEGORY_SET_NAME = l_item_catset3_name
3036: AND NOT EXISTS
3037: (SELECT NULL
3038: FROM EDW_ITEM_CATSETI3_C1_LSTG LSTG
3039: WHERE SUBSTRB(LSTG.CATEGORY_PK, 3) = LCV.CATEGORY_PK || '-' || l_instance /* Bug 2558245 */
3040: AND LSTG.CATEGORY_SET_NAME = l_item_catset3_name
3041: AND LSTG.COLLECTION_STATUS = 'READY')
3042: AND EXISTS /* Bug# 2559696 Removed the use of EDW_ITEMS_CATEGORY_FKV by dsakalle */