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.PO_UDA_TEMPLATES_UTIL dependencies on EGO_FND_DSC_FLX_CTX_EXT

Line 799: FROM ego_fnd_dsc_flx_ctx_ext

795: x_return_status := 'F';
796:
797: SELECT ATTR_GROUP_ID
798: INTO l_attr_grp_id
799: FROM ego_fnd_dsc_flx_ctx_ext
800: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_attribute_group_type
801: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attribute_group_name
802: AND ROWNUM < 2;
803:

Line 959: FROM ego_fnd_dsc_flx_ctx_ext

955: BEGIN
956:
957: SELECT CREATED_BY
958: INTO l_created_by
959: FROM ego_fnd_dsc_flx_ctx_ext
960: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_attribute_group_type
961: AND ATTR_GROUP_ID = p_attribute_group_id
962: AND ROWNUM < 2;
963:

Line 1238: FROM ego_fnd_dsc_flx_ctx_ext

1234: p_internal_name IN VARCHAR2
1235: )
1236: IS
1237: SELECT ATTR_GROUP_ID
1238: FROM ego_fnd_dsc_flx_ctx_ext
1239: WHERE DESCRIPTIVE_FLEX_CONTEXT_CODE = p_internal_name;
1240:
1241:
1242:

Line 1255: FROM ego_fnd_dsc_flx_ctx_ext

1251: END IF;
1252:
1253: SELECT ATTR_GROUP_ID
1254: INTO l_attr_grp_id
1255: FROM ego_fnd_dsc_flx_ctx_ext
1256: WHERE DESCRIPTIVE_FLEXFIELD_NAME = p_attribute_group_type
1257: AND DESCRIPTIVE_FLEX_CONTEXT_CODE = p_attribute_group_name
1258: AND ROWNUM < 2;
1259:

Line 1349: FROM ego_fnd_dsc_flx_ctx_ext

1345:
1346: -- Query to check if it is a total dummy delete case
1347: SELECT 1
1348: INTO l_total_delete
1349: FROM ego_fnd_dsc_flx_ctx_ext
1350: WHERE ATTR_GROUP_ID = p_attribute_group_id
1351: AND ROWNUM < 2;
1352:
1353: IF PO_LOG.d_stmt THEN

Line 2015: EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT

2011: l_business_event_flag,
2012: l_pre_business_event_flag,
2013: l_owner
2014: FROM FND_DESCR_FLEX_CONTEXTS_TL FL_CTX_TL,
2015: EGO_FND_DSC_FLX_CTX_EXT FL_CTX_EXT
2016: WHERE FL_CTX_EXT.APPLICATION_ID = FL_CTX_TL.APPLICATION_ID
2017: AND FL_CTX_EXT.DESCRIPTIVE_FLEXFIELD_NAME = FL_CTX_TL.DESCRIPTIVE_FLEXFIELD_NAME
2018: AND FL_CTX_EXT.DESCRIPTIVE_FLEX_CONTEXT_CODE = FL_CTX_TL.DESCRIPTIVE_FLEX_CONTEXT_CODE
2019: AND FL_CTX_EXT.ATTR_GROUP_ID = p_attribute_group_id

Line 2404: FROM ego_fnd_dsc_flx_ctx_ext

2400: OWNING_PARTY_ID, REGION_CODE, VIEW_PRIVILEGE_ID, EDIT_PRIVILEGE_ID
2401: INTO l_security_type, l_multi_row, l_business_event_flag,
2402: l_pre_business_event_flag, l_num_of_cols, l_num_of_rows, l_variant,
2403: l_owning_party_id, l_region_code, l_view_privilege_id, l_edit_privilege_id
2404: FROM ego_fnd_dsc_flx_ctx_ext
2405: WHERE ATTR_GROUP_ID = p_dummy_attribute_group_id;
2406:
2407: d_progress := 20;
2408:

Line 2428: FROM ego_fnd_dsc_flx_ctx_ext

2424:
2425: -- Fetching the internal name from Dummy Attribute Group
2426: SELECT DESCRIPTIVE_FLEX_CONTEXT_CODE
2427: INTO l_internal_name
2428: FROM ego_fnd_dsc_flx_ctx_ext
2429: WHERE ATTR_GROUP_ID = p_dummy_attribute_group_id;
2430:
2431: d_progress := 30;
2432:

Line 2446: FROM ego_fnd_dsc_flx_ctx_ext

2442: AND APPLICATION_ID = p_glb_application_id
2443: AND DESCRIPTIVE_FLEXFIELD_NAME IN
2444: (
2445: SELECT DESCRIPTIVE_FLEXFIELD_NAME
2446: FROM ego_fnd_dsc_flx_ctx_ext
2447: WHERE ATTR_GROUP_ID = p_dummy_attribute_group_id
2448: )
2449: AND LANGUAGE = USERENV('LANG')
2450: AND USERENV('LANG') in (LANGUAGE , SOURCE_LANG);

Line 3016: FROM ego_fnd_dsc_flx_ctx_ext dummy_def,

3012:
3013: BEGIN
3014: SELECT 1, dummy_def.DESCRIPTIVE_FLEX_CONTEXT_CODE
3015: INTO l_data_level_present, x_internal_name
3016: FROM ego_fnd_dsc_flx_ctx_ext dummy_def,
3017: ego_data_level_b levels,
3018: ego_attr_group_dl dummy_level
3019: WHERE levels.DATA_LEVEL_ID = dummy_level.DATA_LEVEL_ID
3020: AND dummy_def.DESCRIPTIVE_FLEXFIELD_NAME = 'PO_UDA_DUMMY_EXT_ATTRS'

Line 3614: ego_fnd_dsc_flx_ctx_ext a

3610:
3611: CURSOR c_attr_group_ids(p_template_id NUMBER) IS
3612: SELECT distinct(attribute_group_id)
3613: FROM po_uda_ag_template_usages u,
3614: ego_fnd_dsc_flx_ctx_ext a
3615: WHERE u.template_id = p_template_id
3616: and u.attribute_group_id = a.attr_group_id
3617: and a.multi_row = 'N';
3618:

Line 3621: FROM ego_fnd_dsc_flx_ctx_ext efdfce , ego_fnd_df_col_usgs_ext efdcue

3617: and a.multi_row = 'N';
3618:
3619: CURSOR l_uda_attr_col_name(p_attr_grp_id NUMBER, p_entity_code VARCHAR2) IS
3620: SELECT efdcue.APPLICATION_COLUMN_NAME AS APPLICATION_COLUMN_NAME
3621: FROM ego_fnd_dsc_flx_ctx_ext efdfce , ego_fnd_df_col_usgs_ext efdcue
3622: WHERE ATTR_GROUP_ID = p_attr_grp_id
3623: AND efdfce.DESCRIPTIVE_FLEX_CONTEXT_CODE = efdcue.DESCRIPTIVE_FLEX_CONTEXT_CODE
3624: AND efdcue.DESCRIPTIVE_FLEXFIELD_NAME <> 'PO_UDA_DUMMY_EXT_ATTRS'
3625: AND efdcue.DESCRIPTIVE_FLEXFIELD_NAME = p_entity_code;

Line 3794: FROM ego_fnd_dsc_flx_ctx_ext efdfce , ego_fnd_df_col_usgs_ext efdcue

3790: AND b.template_id = u.template_id;
3791:
3792: CURSOR l_uda_attr_col_name(p_attr_grp_id NUMBER, p_entity_code VARCHAR2) IS
3793: SELECT efdcue.APPLICATION_COLUMN_NAME AS APPLICATION_COLUMN_NAME
3794: FROM ego_fnd_dsc_flx_ctx_ext efdfce , ego_fnd_df_col_usgs_ext efdcue
3795: WHERE ATTR_GROUP_ID = p_attr_grp_id
3796: AND efdfce.DESCRIPTIVE_FLEX_CONTEXT_CODE = efdcue.DESCRIPTIVE_FLEX_CONTEXT_CODE
3797: AND efdcue.DESCRIPTIVE_FLEXFIELD_NAME = p_entity_code
3798: AND efdcue.DESCRIPTIVE_FLEXFIELD_NAME <> 'PO_UDA_DUMMY_EXT_ATTRS';

Line 3922: ego_fnd_dsc_flx_ctx_ext efdfce

3918: select fdfcu.APPLICATION_COLUMN_NAME AS APPLICATION_COLUMN_NAME, fdfcu.END_USER_COLUMN_NAME AS END_USER_COLUMN_NAME,
3919: efdfce.DESCRIPTIVE_FLEX_CONTEXT_CODE AS AG_internal_name
3920: FROM fnd_descr_flex_column_usages fdfcu,
3921: ego_fnd_df_col_usgs_ext efdcue,
3922: ego_fnd_dsc_flx_ctx_ext efdfce
3923: where efdfce.ATTR_GROUP_ID = P_ATTR_GRP_ID
3924: AND efdfce.DESCRIPTIVE_FLEX_CONTEXT_CODE = fdfcu.DESCRIPTIVE_FLEX_CONTEXT_CODE
3925: AND fdfcu.DESCRIPTIVE_FLEX_CONTEXT_CODE = efdcue.DESCRIPTIVE_FLEX_CONTEXT_CODE
3926: AND fdfcu.APPLICATION_COLUMN_NAME = efdcue.APPLICATION_COLUMN_NAME