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 305: ' FROM ego_data_level_b dl, ego_obj_ag_assocs_b assoc, ego_fnd_dsc_flx_ctx_ext ag '||

301: -- new code will have p_data_level and must return only one record
302: --
303: BEGIN
304: l_dynamic_sql := 'SELECT DISTINCT(assoc.data_level_id) ' ||
305: ' FROM ego_data_level_b dl, ego_obj_ag_assocs_b assoc, ego_fnd_dsc_flx_ctx_ext ag '||
306: ' WHERE ag.attr_group_id = '||p_attr_group_id ||
307: ' AND dl.attr_group_type = ag.descriptive_flexfield_name '||
308: ' AND dl.application_id = ag.application_id ';
309: IF p_data_level_name IS NOT NULL THEN

Line 4143: l_data_level EGO_OBJ_AG_ASSOCS_B.DATA_LEVEL%TYPE;

4139: l_api_name VARCHAR2(50) := 'Is_Data_Level_Correct';
4140: l_cursor_id NUMBER;
4141: l_dummy NUMBER;
4142: l_obj_and_class VARCHAR2(1100);
4143: l_data_level EGO_OBJ_AG_ASSOCS_B.DATA_LEVEL%TYPE;
4144: l_data_level_id NUMBER;
4145: l_is_data_level_correct BOOLEAN := TRUE;
4146: l_cc_value_list VARCHAR2(1000);
4147: l_dynamic_sql VARCHAR2(5500);

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

4216:
4217: IF(l_data_level_matched AND l_column_matched) THEN
4218: --If the passed in data level is fine we check the association of the data level with the classification
4219: Init();
4220: FND_DSQL.Add_Text(' SELECT DATA_LEVEL FROM EGO_OBJ_AG_ASSOCS_B'||
4221: ' WHERE OBJECT_ID = ');
4222: Add_Bind(p_value => p_object_id);
4223: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4224: Add_Bind(p_value => p_attr_group_id);

Line 4287: ' FROM EGO_OBJ_AG_ASSOCS_B'||

4283: ' FROM FND_LOOKUP_VALUES'||
4284: ' WHERE LOOKUP_TYPE = ''EGO_EF_DATA_LEVEL'''||
4285: ' AND LANGUAGE = USERENV(''LANG'')'||
4286: ' AND LOOKUP_CODE = (SELECT DATA_LEVEL'||
4287: ' FROM EGO_OBJ_AG_ASSOCS_B'||
4288: ' WHERE OBJECT_ID = ');
4289: Add_Bind(p_value => p_object_id);
4290: FND_DSQL.Add_Text(' AND ATTR_GROUP_ID = ');
4291: Add_Bind(p_value => p_attr_group_id);

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

12946: l_decode_query := l_decode_query||' FROM FND_LOOKUP_VALUES ';
12947: l_decode_query := l_decode_query||' WHERE LOOKUP_TYPE = ''EGO_EF_DATA_LEVEL'' ';
12948: l_decode_query := l_decode_query||' AND LANGUAGE = USERENV(''LANG'') ';
12949: l_decode_query := l_decode_query||' AND LOOKUP_CODE = (SELECT DATA_LEVEL ';
12950: l_decode_query := l_decode_query||' FROM EGO_OBJ_AG_ASSOCS_B ';
12951: l_decode_query := l_decode_query||' WHERE OBJECT_ID = '||l_object_id;
12952: l_decode_query := l_decode_query||' AND ATTR_GROUP_ID = '||l_attr_group_metadata_obj.ATTR_GROUP_ID;
12953: l_decode_query := l_decode_query||' AND ROWNUM = 1 ';
12954: l_decode_query := l_decode_query||' AND CLASSIFICATION_CODE IN ('||l_class_code_hierarchy;

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

13114: l_decode_query := l_decode_query||' FROM FND_LOOKUP_VALUES ';
13115: l_decode_query := l_decode_query||' WHERE LOOKUP_TYPE = ''EGO_EF_DATA_LEVEL'' ';
13116: l_decode_query := l_decode_query||' AND LANGUAGE = USERENV(''LANG'') ';
13117: l_decode_query := l_decode_query||' AND LOOKUP_CODE = (SELECT DATA_LEVEL ';
13118: l_decode_query := l_decode_query||' FROM EGO_OBJ_AG_ASSOCS_B ';
13119: l_decode_query := l_decode_query||' WHERE OBJECT_ID = '||l_object_id;
13120: l_decode_query := l_decode_query||' AND ATTR_GROUP_ID = '||l_prev_loop_ag_id;
13121: l_decode_query := l_decode_query||' AND ROWNUM = 1 ';
13122: l_decode_query := l_decode_query||' AND CLASSIFICATION_CODE IN ('||l_class_code_hierarchy;

Line 16498: l_attr_group_id ego_obj_ag_assocs_b.attr_group_id%TYPE;

16494: l_attributes_data_table EGO_USER_ATTR_DATA_TABLE;
16495: l_data_level_obj EGO_COL_NAME_VALUE_PAIR_OBJ;
16496: l_data_level_index NUMBER;
16497: l_class_code_table LOCAL_MEDIUM_VARCHAR_TABLE;
16498: l_attr_group_id ego_obj_ag_assocs_b.attr_group_id%TYPE;
16499: l_data_level_1 VARCHAR2(150);
16500: l_data_level_2 VARCHAR2(150);
16501: l_data_level_3 VARCHAR2(150);
16502:

Line 16504: p_data_level ego_obj_ag_assocs_b.data_level%TYPE

16500: l_data_level_2 VARCHAR2(150);
16501: l_data_level_3 VARCHAR2(150);
16502:
16503: CURSOR relevant_ag_w_data_level(
16504: p_data_level ego_obj_ag_assocs_b.data_level%TYPE
16505: ,p_class_code ego_obj_ag_assocs_b.classification_code%TYPE
16506: ,p_obj_name fnd_objects.obj_name%TYPE
16507: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
16508: IS

Line 16505: ,p_class_code ego_obj_ag_assocs_b.classification_code%TYPE

16501: l_data_level_3 VARCHAR2(150);
16502:
16503: CURSOR relevant_ag_w_data_level(
16504: p_data_level ego_obj_ag_assocs_b.data_level%TYPE
16505: ,p_class_code ego_obj_ag_assocs_b.classification_code%TYPE
16506: ,p_obj_name fnd_objects.obj_name%TYPE
16507: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
16508: IS
16509: SELECT assoc.attr_group_id

Line 16510: FROM ego_obj_ag_assocs_b assoc,

16506: ,p_obj_name fnd_objects.obj_name%TYPE
16507: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
16508: IS
16509: SELECT assoc.attr_group_id
16510: FROM ego_obj_ag_assocs_b assoc,
16511: fnd_objects object,
16512: ego_fnd_dsc_flx_ctx_ext ag
16513: WHERE assoc.classification_code = p_class_code
16514: AND assoc.object_id = object.object_id

Line 16521: p_class_code ego_obj_ag_assocs_b.classification_code%TYPE

16517: AND ag.attr_group_id = assoc.attr_group_id
16518: AND assoc.data_level = p_data_level;
16519:
16520: CURSOR relevant_ag_wo_data_level(
16521: p_class_code ego_obj_ag_assocs_b.classification_code%TYPE
16522: ,p_obj_name fnd_objects.obj_name%TYPE
16523: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
16524: IS
16525: SELECT assoc.attr_group_id

Line 16526: FROM ego_obj_ag_assocs_b assoc,

16522: ,p_obj_name fnd_objects.obj_name%TYPE
16523: ,p_ag_type ego_fnd_dsc_flx_ctx_ext.descriptive_flexfield_name%TYPE)
16524: IS
16525: SELECT assoc.attr_group_id
16526: FROM ego_obj_ag_assocs_b assoc,
16527: fnd_objects object,
16528: ego_fnd_dsc_flx_ctx_ext ag
16529: WHERE assoc.classification_code = p_class_code
16530: AND assoc.object_id = object.object_id

Line 17307: ' EGO_OBJ_AG_ASSOCS_B ASSOC_TBL,'||

17303: ' ATTR_TBL.END_USER_COLUMN_NAME ATTR_NAME, REQUIRED_FLAG, DEFAULT_VALUE , ASSOC_TBL.DATA_LEVEL,'||
17304: ' ATTR_EXT_TBL.DATA_TYPE'||
17305: ' FROM FND_DESCR_FLEX_COLUMN_USAGES ATTR_TBL,'||
17306: ' EGO_FND_DSC_FLX_CTX_EXT ATTR_GROUP_TBL,'||
17307: ' EGO_OBJ_AG_ASSOCS_B ASSOC_TBL,'||
17308: ' EGO_FND_DF_COL_USGS_EXT ATTR_EXT_TBL'||
17309: ' WHERE ATTR_TBL.APPLICATION_ID = ATTR_GROUP_TBL.APPLICATION_ID ';
17310:
17311: IF (p_attr_groups_to_exclude IS NOT NULL) THEN