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 137: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

133: -- put that data level id here. --
134: -----------------------------------------------------------
135: UPDATE EGO_ITM_USR_ATTR_INTRFC uai
136: SET DATA_LEVEL_ID = (SELECT DATA_LEVEL_ID
137: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
138: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
139: AND ag_ext.APPLICATION_ID = 431
140: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
141: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME

Line 149: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext

145: AND uai.DATA_LEVEL_ID IS NULL
146: AND uai.DATA_LEVEL_NAME IS NULL
147: AND uai.USER_DATA_LEVEL_NAME IS NULL
148: AND (SELECT COUNT(*)
149: FROM EGO_ATTR_GROUP_DL eagd, EGO_FND_DSC_FLX_CTX_EXT ag_ext
150: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
151: AND ag_ext.APPLICATION_ID = 431
152: AND ag_ext.DESCRIPTIVE_FLEXFIELD_NAME = NVL(uai.ATTR_GROUP_TYPE, 'EGO_ITEMMGMT_GROUP')
153: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = uai.ATTR_GROUP_INT_NAME

Line 2330: FROM EGO_ATTR_GROUP_DL eagd

2326: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID
2327: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
2328: AND ext_prod.DATA_LEVEL_ID = #' || l_item_dl_id || q'#
2329: AND EXISTS (SELECT NULL
2330: FROM EGO_ATTR_GROUP_DL eagd
2331: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2332: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2333: AND NVL(eagd.DEFAULTING, 'D') = 'D'
2334: ) #';

Line 2351: FROM EGO_ATTR_GROUP_DL eagd

2347: AND msii.ORGANIZATION_ID = mp.ORGANIZATION_ID
2348: AND mp.ORGANIZATION_ID = mp.MASTER_ORGANIZATION_ID
2349: AND ext_prod.DATA_LEVEL_ID = #' || l_item_dl_id || q'#
2350: AND EXISTS (SELECT NULL
2351: FROM EGO_ATTR_GROUP_DL eagd
2352: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2353: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2354: AND NVL(eagd.DEFAULTING, 'D') = 'D'
2355: ) #';

Line 2442: FROM EGO_ATTR_GROUP_DL eagd

2438: AND ORGANIZATION_ID = ext_prod.ORGANIZATION_ID
2439: AND dr =1
2440: )
2441: AND EXISTS (SELECT NULL
2442: FROM EGO_ATTR_GROUP_DL eagd
2443: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2444: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2445: AND NVL(eagd.DEFAULTING, 'D') = 'D'
2446: ) #';

Line 2473: FROM EGO_ATTR_GROUP_DL eagd

2469: AND dr =1
2470:
2471: )
2472: AND EXISTS (SELECT NULL
2473: FROM EGO_ATTR_GROUP_DL eagd
2474: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2475: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2476: AND NVL(eagd.DEFAULTING, 'D') = 'D'
2477: ) #';

Line 2663: FROM EGO_ATTR_GROUP_DL eagd

2659: AND ext_prod.DATA_LEVEL_ID = #' || l_item_org_dl_id || q'#
2660: AND ext_prod.INVENTORY_ITEM_ID = NVL(msii.STYLE_ITEM_ID,msii.INVENTORY_ITEM_ID)
2661: AND ext_prod.ORGANIZATION_ID = NVL2(msii.STYLE_ITEM_ID,msii.ORGANIZATION_ID,mp.MASTER_ORGANIZATION_ID)
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 = ext_prod.DATA_LEVEL_ID
2666: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR msii.STYLE_ITEM_ID IS NULL )
2667: )

Line 2690: FROM EGO_ATTR_GROUP_DL eagd

2686: AND ext_prod.DATA_LEVEL_ID = #' || l_item_org_dl_id || q'#
2687: AND ext_prod.INVENTORY_ITEM_ID = NVL(msii.STYLE_ITEM_ID,msii.INVENTORY_ITEM_ID)
2688: AND ext_prod.ORGANIZATION_ID = NVL2(msii.STYLE_ITEM_ID,msii.ORGANIZATION_ID,mp.MASTER_ORGANIZATION_ID)
2689: AND EXISTS (SELECT 1
2690: FROM EGO_ATTR_GROUP_DL eagd
2691: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2692: AND eagd.DATA_LEVEL_ID = ext_prod.DATA_LEVEL_ID
2693: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR msii.STYLE_ITEM_ID IS NULL )
2694: )

Line 2823: FROM EGO_ATTR_GROUP_DL eagd

2819: AND eia.DATA_LEVEL_ID = #' || l_item_sup_dl_id || q'#
2820: AND eia.PK1_VALUE = eiai.PK1_VALUE
2821: )
2822: AND EXISTS (SELECT 1
2823: FROM EGO_ATTR_GROUP_DL eagd
2824: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2825: AND eagd.DATA_LEVEL_ID = eiai.DATA_LEVEL_ID
2826: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL )
2827: ) #';

Line 2852: FROM EGO_ATTR_GROUP_DL eagd

2848: AND eia.DATA_LEVEL_ID = #' || l_item_sup_dl_id || q'#
2849: AND eia.PK1_VALUE = eiai.PK1_VALUE
2850: )
2851: AND EXISTS (SELECT 1
2852: FROM EGO_ATTR_GROUP_DL eagd
2853: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2854: AND eagd.DATA_LEVEL_ID = eiai.DATA_LEVEL_ID
2855: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL )
2856: ) #';

Line 2941: FROM EGO_ATTR_GROUP_DL eagd

2937: AND eia.PK1_VALUE = eiai.PK1_VALUE
2938: AND eia.PK2_VALUE = eiai.PK2_VALUE
2939: )
2940: AND EXISTS (SELECT 1
2941: FROM EGO_ATTR_GROUP_DL eagd
2942: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2943: AND eagd.DATA_LEVEL_ID = eiai.DATA_LEVEL_ID
2944: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL )
2945: ) #';

Line 2975: FROM EGO_ATTR_GROUP_DL eagd

2971: AND eia.PK1_VALUE = eiai.PK1_VALUE
2972: AND eia.PK2_VALUE = eiai.PK2_VALUE
2973: )
2974: AND EXISTS (SELECT 1
2975: FROM EGO_ATTR_GROUP_DL eagd
2976: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
2977: AND eagd.DATA_LEVEL_ID = eiai.DATA_LEVEL_ID
2978: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL )
2979: ) #';

Line 3068: FROM EGO_ATTR_GROUP_DL eagd

3064: AND eia.PK1_VALUE = eiai.PK1_VALUE
3065: AND eia.PK2_VALUE = eiai.PK2_VALUE
3066: )
3067: AND EXISTS (SELECT 1
3068: FROM EGO_ATTR_GROUP_DL eagd
3069: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
3070: AND eagd.DATA_LEVEL_ID = eiai.DATA_LEVEL_ID
3071: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL )
3072: ) #';

Line 3106: FROM EGO_ATTR_GROUP_DL eagd

3102: AND eia.PK1_VALUE = eiai.PK1_VALUE
3103: AND eia.PK2_VALUE = eiai.PK2_VALUE
3104: )
3105: AND EXISTS (SELECT 1
3106: FROM EGO_ATTR_GROUP_DL eagd
3107: WHERE eagd.ATTR_GROUP_ID = ext_prod.ATTR_GROUP_ID
3108: AND eagd.DATA_LEVEL_ID = eiai.DATA_LEVEL_ID
3109: AND ( NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL )
3110: ) #';

Line 3338: FROM EGO_ATTR_GROUP_DL eagd

3334: AND ag_ext.APPLICATION_ID = 431
3335: AND NVL(ag_ext.VARIANT, 'N') = 'N'
3336: AND ext_intf.DATA_LEVEL_ID = #' || l_item_dl_id || q'#
3337: AND EXISTS (SELECT NULL
3338: FROM EGO_ATTR_GROUP_DL eagd
3339: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
3340: AND eagd.DATA_LEVEL_ID = #' || l_item_sup_dl_id || q'#
3341: AND (NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL)
3342: )

Line 3437: FROM EGO_ATTR_GROUP_DL eagd

3433: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = ext_intf.ATTR_GROUP_INT_NAME
3434: AND ag_ext.APPLICATION_ID = 431
3435: AND NVL(ag_ext.VARIANT, 'N') = 'N'
3436: AND EXISTS (SELECT NULL
3437: FROM EGO_ATTR_GROUP_DL eagd
3438: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
3439: AND eagd.DATA_LEVEL_ID = #' || l_item_sup_site_dl_id || q'#
3440: AND (NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL)
3441: )

Line 3539: FROM EGO_ATTR_GROUP_DL eagd

3535: AND ag_ext.DESCRIPTIVE_FLEX_CONTEXT_CODE = ext_intf.ATTR_GROUP_INT_NAME
3536: AND ag_ext.APPLICATION_ID = 431
3537: AND NVL(ag_ext.VARIANT, 'N') = 'N'
3538: AND EXISTS (SELECT NULL
3539: FROM EGO_ATTR_GROUP_DL eagd
3540: WHERE eagd.ATTR_GROUP_ID = ag_ext.ATTR_GROUP_ID
3541: AND eagd.DATA_LEVEL_ID = #' || l_item_sup_site_org_dl_id || q'#
3542: AND (NVL(eagd.DEFAULTING, 'D') = 'D' OR eiai.STYLE_ITEM_ID IS NULL)
3543: )

Line 4237: ego_attr_group_dl ag_dl

4233: FROM ego_mappings_b MAP,
4234: fnd_descr_flex_column_usages fl_col,
4235: ego_fnd_df_col_usgs_ext attr_ext,
4236: ego_fnd_dsc_flx_ctx_ext ag_ext,
4237: ego_attr_group_dl ag_dl
4238: WHERE MAP.mapped_obj_type = 'A'
4239: AND fl_col.application_id = MAP.mapped_to_group_pk1
4240: AND fl_col.descriptive_flexfield_name = MAP.mapped_to_group_pk2
4241: AND fl_col.descriptive_flex_context_code = MAP.mapped_to_group_pk3

Line 6203: FROM ego_attr_group_dl

6199:
6200: CURSOR c_valid_data_level
6201: IS
6202: SELECT 1
6203: FROM ego_attr_group_dl
6204: WHERE data_level_id IN (SELECT data_level_id FROM ego_data_level_b
6205: WHERE attr_group_type = p_attr_group_type
6206: AND data_level_name = p_data_level_name
6207: AND application_id = 431)