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.FND_FLEX_DIAGNOSE dependencies on FND_ID_FLEXS

Line 33: SUBTYPE kff_flx_type IS fnd_id_flexs%ROWTYPE;

29: SUBTYPE dff_flx_type IS fnd_descriptive_flexs%ROWTYPE;
30: SUBTYPE dff_ctx_type IS fnd_descr_flex_contexts%ROWTYPE;
31: SUBTYPE dff_seg_type IS fnd_descr_flex_column_usages%ROWTYPE;
32:
33: SUBTYPE kff_flx_type IS fnd_id_flexs%ROWTYPE;
34: SUBTYPE kff_str_type IS fnd_id_flex_structures%ROWTYPE;
35: SUBTYPE kff_seg_type IS fnd_id_flex_segments%ROWTYPE;
36: SUBTYPE kff_flq_type IS fnd_segment_attribute_types%ROWTYPE;
37: SUBTYPE kff_qlv_type IS fnd_segment_attribute_values%ROWTYPE;

Line 482: FROM fnd_id_flexs

478: IS
479: BEGIN
480: SELECT *
481: INTO x_kff_flx
482: FROM fnd_id_flexs
483: WHERE application_id = p_application_id
484: AND id_flex_code = p_id_flex_code;
485: RETURN(TRUE);
486: EXCEPTION

Line 488: x_message := msg_uts('FND_ID_FLEXS',

484: AND id_flex_code = p_id_flex_code;
485: RETURN(TRUE);
486: EXCEPTION
487: WHEN OTHERS THEN
488: x_message := msg_uts('FND_ID_FLEXS',
489: 'application_id', p_application_id,
490: 'id_flex_code', p_id_flex_code);
491: RETURN(FALSE);
492: END fetch_kff_flx;

Line 3490: FROM fnd_id_flexs

3486: SELECT id_flex_code || '/' ||
3487: id_flex_name || '/' ||
3488: Nvl(description, '')
3489: INTO l_return
3490: FROM fnd_id_flexs
3491: WHERE application_id = p_application_id
3492: AND id_flex_code = p_id_flex_code;
3493: RETURN(line_return(l_return));
3494: EXCEPTION

Line 3703: FROM fnd_application_vl avl, fnd_id_flexs idf

3699: SELECT To_char(avl.application_id) || '/' ||
3700: avl.application_short_name || '/' ||
3701: avl.application_name
3702: INTO l_return
3703: FROM fnd_application_vl avl, fnd_id_flexs idf
3704: WHERE avl.application_id = idf.table_application_id
3705: AND idf.application_id = p_application_id
3706: AND idf.id_flex_code = p_id_flex_code;
3707: RETURN(line_return(l_return));

Line 3725: FROM user_synonyms us, fnd_tables ft, fnd_id_flexs idf

3721: SELECT us.table_owner || '/' ||
3722: ft.table_name || '/' ||
3723: To_char(table_id)
3724: INTO l_return
3725: FROM user_synonyms us, fnd_tables ft, fnd_id_flexs idf
3726: WHERE us.synonym_name = idf.application_table_name
3727: AND ft.application_id = idf.table_application_id
3728: AND ft.table_name = idf.application_table_name
3729: AND idf.application_id = p_application_id

Line 3754: FROM fnd_columns fc, fnd_tables ft, fnd_id_flexs idf

3750: fc.flexfield_usage_code || '/' ||
3751: Nvl(To_char(fc.flexfield_application_id), '') || '/' ||
3752: Nvl(fc.flexfield_name, '')
3753: INTO l_return
3754: FROM fnd_columns fc, fnd_tables ft, fnd_id_flexs idf
3755: WHERE idf.application_id = p_application_id
3756: AND idf.id_flex_code = p_id_flex_code
3757: AND ft.application_id = idf.table_application_id
3758: AND ft.table_name = idf.application_table_name

Line 4169: FROM fnd_id_flexs idf

4165: -- KFF with invalid APPLICATION_ID.
4166: --
4167: BEGIN
4168: DELETE
4169: FROM fnd_id_flexs idf
4170: WHERE application_id = p_application_id
4171: AND id_flex_code = p_id_flex_code
4172: AND NOT EXISTS
4173: (SELECT null

Line 4181: 'Unable to delete from FND_ID_FLEXS. ' || Sqlerrm;

4177: GOTO return_success;
4178: EXCEPTION
4179: WHEN OTHERS THEN
4180: x_message :=
4181: 'Unable to delete from FND_ID_FLEXS. ' || Sqlerrm;
4182: GOTO return_error;
4183: END;
4184: END IF;
4185:

Line 4197: FROM fnd_id_flexs idf

4193: WHERE application_id = p_application_id
4194: AND id_flex_code = p_id_flex_code
4195: AND NOT EXISTS
4196: (SELECT null
4197: FROM fnd_id_flexs idf
4198: WHERE idf.application_id = cif.application_id
4199: AND idf.id_flex_code = cif.id_flex_code);
4200: x_message := SQL%rowcount || ' row(s) deleted.';
4201: GOTO return_success;

Line 4368: UPDATE fnd_id_flexs SET

4364: l_kff_flx.index_flag := 'N';
4365: END IF;
4366:
4367: BEGIN
4368: UPDATE fnd_id_flexs SET
4369: application_table_type = l_kff_flx.application_table_type,
4370: allow_id_valuesets = l_kff_flx.allow_id_valuesets,
4371: dynamic_inserts_feasible_flag = l_kff_flx.dynamic_inserts_feasible_flag,
4372: index_flag = l_kff_flx.index_flag,

Line 4381: x_message := 'Unable to update FND_ID_FLEXS. ' || Sqlerrm;

4377: x_message := SQL%rowcount || ' row(s) updated.';
4378: GOTO return_success;
4379: EXCEPTION
4380: WHEN OTHERS THEN
4381: x_message := 'Unable to update FND_ID_FLEXS. ' || Sqlerrm;
4382: GOTO return_error;
4383: END;
4384: END IF;
4385:

Line 4417: FROM fnd_id_flexs idf

4413: AND id_flex_code = p_id_flex_code
4414: AND id_flex_num = p_id_flex_num
4415: AND NOT EXISTS
4416: (SELECT null
4417: FROM fnd_id_flexs idf
4418: WHERE idf.application_id = ifst.application_id
4419: AND idf.id_flex_code = ifst.id_flex_code);
4420: x_message := SQL%rowcount || ' row(s) deleted.';
4421: GOTO return_success;

Line 5324: FROM fnd_id_flexs idf

5320: AND id_flex_code = p_id_flex_code
5321: AND segment_attribute_type = p_segment_attribute_type
5322: AND NOT EXISTS
5323: (SELECT null
5324: FROM fnd_id_flexs idf
5325: WHERE idf.application_id = sat.application_id
5326: AND idf.id_flex_code = sat.id_flex_code);
5327: x_message := SQL%rowcount || ' row(s) deleted.';
5328: GOTO return_success;

Line 5840: FROM fnd_id_flexs

5836:
5837: BEGIN
5838: SELECT *
5839: INTO l_kff_flx
5840: FROM fnd_id_flexs
5841: WHERE table_application_id = l_tbl.application_id
5842: AND application_table_name = l_tbl.table_name
5843: AND unique_id_column_name = l_col.column_name;
5844: x_message := ('This column is used by ' ||

Line 5853: x_message := 'Unable to select from FND_ID_FLEXS. ' || Sqlerrm;

5849: EXCEPTION
5850: WHEN no_data_found THEN
5851: NULL;
5852: WHEN OTHERS THEN
5853: x_message := 'Unable to select from FND_ID_FLEXS. ' || Sqlerrm;
5854: GOTO return_error;
5855: END;
5856:
5857: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN

Line 5876: FROM fnd_id_flexs

5872:
5873: BEGIN
5874: SELECT *
5875: INTO l_kff_flx
5876: FROM fnd_id_flexs
5877: WHERE table_application_id = l_tbl.application_id
5878: AND application_table_name = l_tbl.table_name
5879: AND set_defining_column_name = l_col.column_name;
5880: x_message := ('This column is used by ' ||

Line 5889: x_message := 'Unable to select from FND_ID_FLEXS. ' || Sqlerrm;

5885: EXCEPTION
5886: WHEN no_data_found THEN
5887: NULL;
5888: WHEN OTHERS THEN
5889: x_message := 'Unable to select from FND_ID_FLEXS. ' || Sqlerrm;
5890: GOTO return_error;
5891: END;
5892:
5893: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN

Line 5912: FROM fnd_id_flexs

5908:
5909: BEGIN
5910: SELECT *
5911: INTO l_kff_flx
5912: FROM fnd_id_flexs
5913: WHERE table_application_id = l_tbl.application_id
5914: AND application_table_name = l_tbl.table_name;
5915: x_message := ('This column is possibly used by ' ||
5916: To_char(l_kff_flx.application_id) || '/' ||

Line 5924: x_message := 'Unable to select from FND_ID_FLEXS. ' || Sqlerrm;

5920: EXCEPTION
5921: WHEN no_data_found THEN
5922: NULL;
5923: WHEN OTHERS THEN
5924: x_message := 'Unable to select from FND_ID_FLEXS. ' || Sqlerrm;
5925: GOTO return_error;
5926: END;
5927:
5928: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN

Line 5947: FROM fnd_id_flexs

5943:
5944: BEGIN
5945: SELECT *
5946: INTO l_kff_flx
5947: FROM fnd_id_flexs
5948: WHERE table_application_id = l_tbl.application_id
5949: AND application_table_name = l_tbl.table_name;
5950: BEGIN
5951: SELECT *

Line 5977: x_message := 'Unable to select from FND_ID_FLEXS. ' || Sqlerrm;

5973: EXCEPTION
5974: WHEN no_data_found THEN
5975: NULL;
5976: WHEN OTHERS THEN
5977: x_message := 'Unable to select from FND_ID_FLEXS. ' || Sqlerrm;
5978: GOTO return_error;
5979: END;
5980:
5981: IF (update_fnd_columns(l_col, 'N', NULL, NULL, x_message)) THEN