APPS.EGO_IMPORT_PVT dependencies on EGO_ATTR_GROUP_DL

Line 874: FROM EGO_ATTR_GROUP_DL A

870: AND FL_CTX_EXT.APPLICATION_ID = 431
871: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
872: AND FL_CTX_EXT.MULTI_ROW = 'N'
873: AND EXISTS( SELECT NULL
874: FROM EGO_ATTR_GROUP_DL A
875: WHERE A.DATA_LEVEL_ID = cp_rev_dl_id
876: AND A.ATTR_GROUP_ID = FL_CTX_EXT.ATTR_GROUP_ID
877: )
878: ) sub

Line 958: FROM EGO_ATTR_GROUP_DL A

954: AND FL_CTX_EXT.APPLICATION_ID = 431
955: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
956: AND FL_CTX_EXT.MULTI_ROW = 'N'
957: AND EXISTS( SELECT NULL
958: FROM EGO_ATTR_GROUP_DL A
959: WHERE A.DATA_LEVEL_ID = cp_rev_dl_id
960: AND A.ATTR_GROUP_ID = FL_CTX_EXT.ATTR_GROUP_ID
961: )
962: ) sub

Line 1295: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL

1291: AND FL_CTX_EXT.APPLICATION_ID = 431
1292: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
1293: AND FL_CTX_EXT.MULTI_ROW = 'N'
1294: AND EXISTS( SELECT NULL
1295: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL
1296: WHERE DL.APPLICATION_ID = 431
1297: AND DL.ATTR_GROUP_TYPE = FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME
1298: AND DL.DATA_LEVEL_NAME IN ( 'ITEM_LEVEL' , 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG' )
1299: /* Bug:11887867

Line 1377: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL

1373: AND FL_CTX_EXT.APPLICATION_ID = 431
1374: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
1375: AND FL_CTX_EXT.MULTI_ROW = 'N'
1376: AND EXISTS( SELECT NULL
1377: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL
1378: WHERE DL.APPLICATION_ID = 431
1379: AND DL.ATTR_GROUP_TYPE = FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME
1380: AND DL.DATA_LEVEL_NAME IN ( 'ITEM_LEVEL' , 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG' )
1381: /* Bug:11887867

Line 4377: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL

4373: AND FL_CTX_EXT.APPLICATION_ID = 431
4374: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
4375: AND FL_CTX_EXT.MULTI_ROW = 'N'
4376: AND EXISTS( SELECT NULL
4377: FROM EGO_ATTR_GROUP_DL A, EGO_DATA_LEVEL_B DL
4378: WHERE DL.APPLICATION_ID = 431
4379: AND DL.ATTR_GROUP_TYPE = FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME
4380: AND DL.DATA_LEVEL_NAME IN ( 'ITEM_LEVEL' , 'ITEM_ORG', 'ITEM_SUP', 'ITEM_SUP_SITE', 'ITEM_SUP_SITE_ORG' )
4381: /* Bug:11887867

Line 4695: FROM EGO_ATTR_GROUP_DL A

4691: AND FL_CTX_EXT.APPLICATION_ID = 431
4692: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = EIUAI.ATTR_GROUP_INT_NAME
4693: AND FL_CTX_EXT.MULTI_ROW = 'N'
4694: AND EXISTS( SELECT NULL
4695: FROM EGO_ATTR_GROUP_DL A
4696: WHERE A.DATA_LEVEL_ID = cp_rev_dl_id
4697: AND A.ATTR_GROUP_ID = FL_CTX_EXT.ATTR_GROUP_ID
4698: )
4699: ) sub

Line 6677: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

6673: -- put that data level id here. --
6674: -----------------------------------------------------------
6675: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
6676: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
6677: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
6678: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
6679: AND ag_ext.APPLICATION_ID = 431
6680: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
6681: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME

Line 6689: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

6685: AND uai.DATA_LEVEL_ID IS NULL
6686: AND uai.DATA_LEVEL_NAME IS NULL
6687: AND uai.USER_DATA_LEVEL_NAME IS NULL
6688: AND (SELECT COUNT(*)
6689: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
6690: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
6691: AND ag_ext.APPLICATION_ID = 431
6692: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
6693: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME