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_UTIL_PVT dependencies on EGO_ATTR_GROUP_DL

Line 114: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

110: -- put that data level id here. --
111: -----------------------------------------------------------
112: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
113: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
114: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
115: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
116: AND ag_ext.APPLICATION_ID = 431
117: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
118: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME

Line 126: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

122: AND uai.DATA_LEVEL_ID IS NULL
123: AND uai.DATA_LEVEL_NAME IS NULL
124: AND uai.USER_DATA_LEVEL_NAME IS NULL
125: AND (SELECT COUNT(*)
126: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
127: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
128: AND ag_ext.APPLICATION_ID = 431
129: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
130: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME

Line 2156: FROM EGO_ATTR_GROUP_DL eagd

2152: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID
2153: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
2154: AND ext_prod.DATA_LEVEL_ID = #' || l_item_dl_id || q'#
2155: AND EXISTS (SELECT NULL
2156: FROM EGO_ATTR_GROUP_DL eagd
2157: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2158: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2159: AND NVL(eagd.DEFAULTING, 'D') = 'D'
2160: ) #';

Line 2177: FROM EGO_ATTR_GROUP_DL eagd

2173: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID
2174: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
2175: AND ext_prod.DATA_LEVEL_ID = #' || l_item_dl_id || q'#
2176: AND EXISTS (SELECT NULL
2177: FROM EGO_ATTR_GROUP_DL eagd
2178: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2179: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2180: AND NVL(eagd.DEFAULTING, 'D') = 'D'
2181: ) #';

Line 2265: FROM EGO_ATTR_GROUP_DL eagd

2261: AND mirb.INVENTORY_ITEM_ID = ext_prod.INVENTORY_ITEM_ID
2262: AND mirb.ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2263: )
2264: AND EXISTS (SELECT NULL
2265: FROM EGO_ATTR_GROUP_DL eagd
2266: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2267: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2268: AND NVL(eagd.DEFAULTING, 'D') = 'D'
2269: ) #';

Line 2293: FROM EGO_ATTR_GROUP_DL eagd

2289: AND mirb.INVENTORY_ITEM_ID = ext_prod.INVENTORY_ITEM_ID
2290: AND mirb.ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2291: )
2292: AND EXISTS (SELECT NULL
2293: FROM EGO_ATTR_GROUP_DL eagd
2294: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2295: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2296: AND NVL(eagd.DEFAULTING, 'D') = 'D'
2297: ) #';

Line 2474: FROM EGO_ATTR_GROUP_DL eagd

2470: AND ext_prod.DATA_LEVEL_ID = #' || l_item_org_dl_id || q'#
2471: AND ext_prod.INVENTORY_ITEM_ID = NVL(msii.STYLE_ITEM_ID,msii.INVENTORY_ITEM_ID)
2472: AND ext_prod.ORGANIZATION_ID = NVL2(msii.STYLE_ITEM_ID,msii.ORGANIZATION_ID,mp.MASTER_ORGANIZATION_ID)
2473: AND EXISTS (SELECT 1
2474: FROM EGO_ATTR_GROUP_DL eagd
2475: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2476: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2477: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR msii.STYLE_ITEM_ID IS NULL )
2478: )

Line 2501: FROM EGO_ATTR_GROUP_DL eagd

2497: AND ext_prod.DATA_LEVEL_ID = #' || l_item_org_dl_id || q'#
2498: AND ext_prod.INVENTORY_ITEM_ID = NVL(msii.STYLE_ITEM_ID,msii.INVENTORY_ITEM_ID)
2499: AND ext_prod.ORGANIZATION_ID = NVL2(msii.STYLE_ITEM_ID,msii.ORGANIZATION_ID,mp.MASTER_ORGANIZATION_ID)
2500: AND EXISTS (SELECT 1
2501: FROM EGO_ATTR_GROUP_DL eagd
2502: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2503: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2504: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR msii.STYLE_ITEM_ID IS NULL )
2505: )

Line 2634: FROM EGO_ATTR_GROUP_DL eagd

2630: AND eia.DATA_LEVEL_ID = #' || l_item_sup_dl_id || q'#
2631: AND eia.PK1_VALUE = eiai.PK1_VALUE
2632: )
2633: AND EXISTS (SELECT 1
2634: FROM EGO_ATTR_GROUP_DL eagd
2635: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2636: AND eagd.DATA_LEVEL_ID = eiai.DATA_LEVEL_ID
2637: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL )
2638: ) #';

Line 2663: FROM EGO_ATTR_GROUP_DL eagd

2659: AND eia.DATA_LEVEL_ID = #' || l_item_sup_dl_id || q'#
2660: AND eia.PK1_VALUE = eiai.PK1_VALUE
2661: )
2662: AND EXISTS (SELECT 1
2663: FROM EGO_ATTR_GROUP_DL eagd
2664: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2665: AND eagd.DATA_LEVEL_ID = eiai.DATA_LEVEL_ID
2666: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL )
2667: ) #';

Line 2752: FROM EGO_ATTR_GROUP_DL eagd

2748: AND eia.PK1_VALUE = eiai.PK1_VALUE
2749: AND eia.PK2_VALUE = eiai.PK2_VALUE
2750: )
2751: AND EXISTS (SELECT 1
2752: FROM EGO_ATTR_GROUP_DL eagd
2753: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2754: AND eagd.DATA_LEVEL_ID = eiai.DATA_LEVEL_ID
2755: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL )
2756: ) #';

Line 2786: FROM EGO_ATTR_GROUP_DL eagd

2782: AND eia.PK1_VALUE = eiai.PK1_VALUE
2783: AND eia.PK2_VALUE = eiai.PK2_VALUE
2784: )
2785: AND EXISTS (SELECT 1
2786: FROM EGO_ATTR_GROUP_DL eagd
2787: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2788: AND eagd.DATA_LEVEL_ID = eiai.DATA_LEVEL_ID
2789: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL )
2790: ) #';

Line 2879: FROM EGO_ATTR_GROUP_DL eagd

2875: AND eia.PK1_VALUE = eiai.PK1_VALUE
2876: AND eia.PK2_VALUE = eiai.PK2_VALUE
2877: )
2878: AND EXISTS (SELECT 1
2879: FROM EGO_ATTR_GROUP_DL eagd
2880: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2881: AND eagd.DATA_LEVEL_ID = eiai.DATA_LEVEL_ID
2882: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL )
2883: ) #';

Line 2917: FROM EGO_ATTR_GROUP_DL eagd

2913: AND eia.PK1_VALUE = eiai.PK1_VALUE
2914: AND eia.PK2_VALUE = eiai.PK2_VALUE
2915: )
2916: AND EXISTS (SELECT 1
2917: FROM EGO_ATTR_GROUP_DL eagd
2918: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2919: AND eagd.DATA_LEVEL_ID = eiai.DATA_LEVEL_ID
2920: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL )
2921: ) #';

Line 3148: FROM EGO_ATTR_GROUP_DL eagd

3144: AND ag_ext.APPLICATION_ID = 431
3145: AND NVL(ag_ext.VARIANT, 'N') = 'N'
3146: AND ext_intf.DATA_LEVEL_ID = #' || l_item_dl_id || q'#
3147: AND EXISTS (SELECT NULL
3148: FROM EGO_ATTR_GROUP_DL eagd
3149: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
3150: AND eagd.DATA_LEVEL_ID = #' || l_item_sup_dl_id || q'#
3151: AND (NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL)
3152: )

Line 3247: FROM EGO_ATTR_GROUP_DL eagd

3243: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = ext_intf.ATTR_GROUP_INT_NAME
3244: AND ag_ext.APPLICATION_ID = 431
3245: AND NVL(ag_ext.VARIANT, 'N') = 'N'
3246: AND EXISTS (SELECT NULL
3247: FROM EGO_ATTR_GROUP_DL eagd
3248: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
3249: AND eagd.DATA_LEVEL_ID = #' || l_item_sup_site_dl_id || q'#
3250: AND (NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL)
3251: )

Line 3349: FROM EGO_ATTR_GROUP_DL eagd

3345: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = ext_intf.ATTR_GROUP_INT_NAME
3346: AND ag_ext.APPLICATION_ID = 431
3347: AND NVL(ag_ext.VARIANT, 'N') = 'N'
3348: AND EXISTS (SELECT NULL
3349: FROM EGO_ATTR_GROUP_DL eagd
3350: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
3351: AND eagd.DATA_LEVEL_ID = #' || l_item_sup_site_org_dl_id || q'#
3352: AND (NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL)
3353: )

Line 5419: FROM ego_attr_group_dl

5415:
5416: CURSOR c_valid_data_level
5417: IS
5418: SELECT 1
5419: FROM ego_attr_group_dl
5420: WHERE data_level_id IN (SELECT data_level_id FROM ego_data_level_b
5421: WHERE attr_group_type = p_attr_group_type
5422: AND data_level_name = p_data_level_name
5423: AND application_id = 431)