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.EGO_IMPORT_PVT dependencies on EGO_ATTR_GROUP_DL

Line 859: FROM EGO_ATTR_GROUP_DL A

855: AND FL_CTX_EXT.APPLICATION_ID = 431
856: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
857: AND FL_CTX_EXT.MULTI_ROW = 'N'
858: AND EXISTS( SELECT NULL
859: FROM EGO_ATTR_GROUP_DL A
860: WHERE A.DATA_LEVEL_ID = cp_rev_dl_id
861: AND A.ATTR_GROUP_ID = FL_CTX_EXT.ATTR_GROUP_ID
862: )
863: ) sub

Line 943: FROM EGO_ATTR_GROUP_DL A

939: AND FL_CTX_EXT.APPLICATION_ID = 431
940: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
941: AND FL_CTX_EXT.MULTI_ROW = 'N'
942: AND EXISTS( SELECT NULL
943: FROM EGO_ATTR_GROUP_DL A
944: WHERE A.DATA_LEVEL_ID = cp_rev_dl_id
945: AND A.ATTR_GROUP_ID = FL_CTX_EXT.ATTR_GROUP_ID
946: )
947: ) sub

Line 1280: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL

1276: AND FL_CTX_EXT.APPLICATION_ID = 431
1277: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
1278: AND FL_CTX_EXT.MULTI_ROW = 'N'
1279: AND EXISTS( SELECT NULL
1280: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL
1281: WHERE DL.APPLICATION_ID = 431
1282: AND DL.ATTR_GROUP_TYPE = FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME
1283: AND DL.DATA_LEVEL_NAME IN ( 'ITEM_LEVEL' , 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG' )
1284: AND DL.DATA_LEVEL_ID = DL.DATA_LEVEL_ID

Line 1359: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL

1355: AND FL_CTX_EXT.APPLICATION_ID = 431
1356: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
1357: AND FL_CTX_EXT.MULTI_ROW = 'N'
1358: AND EXISTS( SELECT NULL
1359: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL
1360: WHERE DL.APPLICATION_ID = 431
1361: AND DL.ATTR_GROUP_TYPE = FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME
1362: AND DL.DATA_LEVEL_NAME IN ( 'ITEM_LEVEL' , 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG' )
1363: AND DL.DATA_LEVEL_ID = DL.DATA_LEVEL_ID

Line 4315: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL

4311: AND FL_CTX_EXT.APPLICATION_ID = 431
4312: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
4313: AND FL_CTX_EXT.MULTI_ROW = 'N'
4314: AND EXISTS( SELECT NULL
4315: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL
4316: WHERE DL.APPLICATION_ID = 431
4317: AND DL.ATTR_GROUP_TYPE = FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME
4318: AND DL.DATA_LEVEL_NAME IN ( 'ITEM_LEVEL' , 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG' )
4319: AND DL.DATA_LEVEL_ID = DL.DATA_LEVEL_ID

Line 4630: FROM EGO_ATTR_GROUP_DL A

4626: AND FL_CTX_EXT.APPLICATION_ID = 431
4627: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
4628: AND FL_CTX_EXT.MULTI_ROW = 'N'
4629: AND EXISTS( SELECT NULL
4630: FROM EGO_ATTR_GROUP_DL A
4631: WHERE A.DATA_LEVEL_ID = cp_rev_dl_id
4632: AND A.ATTR_GROUP_ID = FL_CTX_EXT.ATTR_GROUP_ID
4633: )
4634: ) sub

Line 6595: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

6591: -- put that data level id here. --
6592: -----------------------------------------------------------
6593: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
6594: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
6595: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
6596: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
6597: AND ag_ext.APPLICATION_ID = 431
6598: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
6599: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME

Line 6607: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

6603: AND uai.DATA_LEVEL_ID IS NULL
6604: AND uai.DATA_LEVEL_NAME IS NULL
6605: AND uai.USER_DATA_LEVEL_NAME IS NULL
6606: AND (SELECT COUNT(*)
6607: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
6608: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
6609: AND ag_ext.APPLICATION_ID = 431
6610: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
6611: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME