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_USER_ATTRS_DATA_PVT dependencies on EGO_OBJ_AG_ASSOCS_B

Line 405: ' FROM ego_data_level_b dl, ego_obj_ag_assocs_b assoc, ego_fnd_dsc_flx_ctx_ext ag '||

401: -- new code will have p_data_level and must return only one record
402: --
403: BEGIN
404: l_dynamic_sql := 'SELECT DISTINCT(assoc.data_level_id) ' ||
405: ' FROM ego_data_level_b dl, ego_obj_ag_assocs_b assoc, ego_fnd_dsc_flx_ctx_ext ag '||
406: ' WHERE ag.attr_group_id = '||p_attr_group_id ||
407: ' AND dl.attr_group_type = ag.descriptive_flexfield_name '||
408: ' AND dl.application_id = ag.application_id ';
409: IF p_data_level_name IS NOT NULL THEN

Line 4594: l_data_level EGO_OBJ_AG_ASSOCS_B.DATA_LEVEL%TYPE;

4590: l_api_name VARCHAR2(50) := 'Is_Data_Level_Correct';
4591: l_cursor_id NUMBER;
4592: l_dummy NUMBER;
4593: l_obj_and_class VARCHAR2(1100);
4594: l_data_level EGO_OBJ_AG_ASSOCS_B.DATA_LEVEL%TYPE;
4595: l_data_level_id NUMBER;
4596: l_is_data_level_correct BOOLEAN := TRUE;
4597: l_cc_value_list VARCHAR2(1000);
4598: l_dynamic_sql VARCHAR2(5500);

Line 4683: FND_DSQL.Add_Text(' SELECT DATA_LEVEL FROM EGO_OBJ_AG_ASSOCS_B'||

4679:
4680: IF(l_data_level_matched AND l_column_matched) THEN
4681: --If the passed in data level is fine we check the association of the data level with the classification
4682: Init();
4683: FND_DSQL.Add_Text(' SELECT DATA_LEVEL FROM EGO_OBJ_AG_ASSOCS_B'||
4684: ' WHERE OBJECT_ID = ');
4685: Add_Bind(p_value => p_object_id);
4686: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4687: Add_Bind(p_value => p_attr_group_id);

Line 4753: ' FROM EGO_OBJ_AG_ASSOCS_B'||

4749: ' FROM FND_LOOKUP_VALUES'||
4750: ' WHERE LOOKUP_TYPE = ''EGO_EF_DATA_LEVEL'''||
4751: ' AND LANGUAGE = USERENV(''LANG'')'||
4752: ' AND LOOKUP_CODE = (SELECT DATA_LEVEL'||
4753: ' FROM EGO_OBJ_AG_ASSOCS_B'||
4754: ' WHERE OBJECT_ID = ');
4755: Add_Bind(p_value => p_object_id);
4756: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4757: Add_Bind(p_value => p_attr_group_id);

Line 13976: l_decode_query := l_decode_query||' FROM EGO_OBJ_AG_ASSOCS_B ';

13972: l_decode_query := l_decode_query||' FROM FND_LOOKUP_VALUES ';
13973: l_decode_query := l_decode_query||' WHERE LOOKUP_TYPE = ''EGO_EF_DATA_LEVEL'' ';
13974: l_decode_query := l_decode_query||' AND LANGUAGE = USERENV(''LANG'') ';
13975: l_decode_query := l_decode_query||' AND LOOKUP_CODE = (SELECT DATA_LEVEL ';
13976: l_decode_query := l_decode_query||' FROM EGO_OBJ_AG_ASSOCS_B ';
13977: l_decode_query := l_decode_query||' WHERE OBJECT_ID = '||l_object_id;
13978: l_decode_query := l_decode_query||' AND ATTR_GROUP_ID = '||l_attr_group_metadata_obj.ATTR_GROUP_ID;
13979: l_decode_query := l_decode_query||' AND ROWNUM = 1 ';
13980: l_decode_query := l_decode_query||' AND CLASSIFICATION_CODE IN ('||l_class_code_hierarchy;

Line 14147: l_decode_query := l_decode_query||' FROM EGO_OBJ_AG_ASSOCS_B ';

14143: l_decode_query := l_decode_query||' FROM FND_LOOKUP_VALUES ';
14144: l_decode_query := l_decode_query||' WHERE LOOKUP_TYPE = ''EGO_EF_DATA_LEVEL'' ';
14145: l_decode_query := l_decode_query||' AND LANGUAGE = USERENV(''LANG'') ';
14146: l_decode_query := l_decode_query||' AND LOOKUP_CODE = (SELECT DATA_LEVEL ';
14147: l_decode_query := l_decode_query||' FROM EGO_OBJ_AG_ASSOCS_B ';
14148: l_decode_query := l_decode_query||' WHERE OBJECT_ID = '||l_object_id;
14149: l_decode_query := l_decode_query||' AND ATTR_GROUP_ID = '||l_prev_loop_ag_id;
14150: l_decode_query := l_decode_query||' AND ROWNUM = 1 ';
14151: l_decode_query := l_decode_query||' AND CLASSIFICATION_CODE IN ('||l_class_code_hierarchy;

Line 17659: l_attr_group_id ego_obj_ag_assocs_b.attr_group_id%TYPE;

17655: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
17656: l_data_level_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
17657: l_data_level_index NUMBER;
17658: l_class_code_table LOCAL_MEDIUM_VARCHAR_TABLE;
17659: l_attr_group_id ego_obj_ag_assocs_b.attr_group_id%TYPE;
17660: l_data_level_1 VARCHAR2(150);
17661: l_data_level_2 VARCHAR2(150);
17662: l_data_level_3 VARCHAR2(150);
17663:

Line 17665: p_data_level ego_obj_ag_assocs_b.data_level%TYPE

17661: l_data_level_2 VARCHAR2(150);
17662: l_data_level_3 VARCHAR2(150);
17663:
17664: CURSOR relevant_ag_w_data_level(
17665: p_data_level ego_obj_ag_assocs_b.data_level%TYPE
17666: ,p_class_code ego_obj_ag_assocs_b.classification_code%TYPE
17667: ,p_obj_name fnd_objects.obj_name%TYPE
17668: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
17669: IS

Line 17666: ,p_class_code ego_obj_ag_assocs_b.classification_code%TYPE

17662: l_data_level_3 VARCHAR2(150);
17663:
17664: CURSOR relevant_ag_w_data_level(
17665: p_data_level ego_obj_ag_assocs_b.data_level%TYPE
17666: ,p_class_code ego_obj_ag_assocs_b.classification_code%TYPE
17667: ,p_obj_name fnd_objects.obj_name%TYPE
17668: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
17669: IS
17670: SELECT assoc.attr_group_id

Line 17671: FROM ego_obj_ag_assocs_b assoc,

17667: ,p_obj_name fnd_objects.obj_name%TYPE
17668: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
17669: IS
17670: SELECT assoc.attr_group_id
17671: FROM ego_obj_ag_assocs_b assoc,
17672: fnd_objects object,
17673: ego_fnd_dsc_flx_ctx_ext ag
17674: WHERE assoc.classification_code = p_class_code
17675: AND assoc.object_id = object.object_id

Line 17682: p_class_code ego_obj_ag_assocs_b.classification_code%TYPE

17678: AND ag.attr_group_id = assoc.attr_group_id
17679: AND assoc.data_level = p_data_level;
17680:
17681: CURSOR relevant_ag_wo_data_level(
17682: p_class_code ego_obj_ag_assocs_b.classification_code%TYPE
17683: ,p_obj_name fnd_objects.obj_name%TYPE
17684: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
17685: IS
17686: SELECT assoc.attr_group_id

Line 17687: FROM ego_obj_ag_assocs_b assoc,

17683: ,p_obj_name fnd_objects.obj_name%TYPE
17684: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
17685: IS
17686: SELECT assoc.attr_group_id
17687: FROM ego_obj_ag_assocs_b assoc,
17688: fnd_objects object,
17689: ego_fnd_dsc_flx_ctx_ext ag
17690: WHERE assoc.classification_code = p_class_code
17691: AND assoc.object_id = object.object_id

Line 18470: ' EGO_OBJ_AG_ASSOCS_B ASSOC_TBL,'||

18466: ' ATTR_TBL.END_USER_COLUMN_NAME ATTR_NAME, REQUIRED_FLAG, DEFAULT_VALUE , ASSOC_TBL.DATA_LEVEL,'||
18467: ' ATTR_EXT_TBL.DATA_TYPE'||
18468: ' FROM FND_DESCR_FLEX_COLUMN_USAGES ATTR_TBL,'||
18469: ' EGO_FND_DSC_FLX_CTX_EXT ATTR_GROUP_TBL,'||
18470: ' EGO_OBJ_AG_ASSOCS_B ASSOC_TBL,'||
18471: ' EGO_FND_DF_COL_USGS_EXT ATTR_EXT_TBL'||
18472: ' WHERE ATTR_TBL.APPLICATION_ID = ATTR_GROUP_TBL.APPLICATION_ID ';
18473:
18474: IF (p_attr_groups_to_exclude IS NOT NULL) THEN