APPS.FND_FLEX_DIAGNOSE dependencies on FND_TABLES

Line 14: SUBTYPE tbl_type IS fnd_tables%ROWTYPE;

10: g_text_size NUMBER := 1950;
11: g_newline VARCHAR2(10);
12:
13: SUBTYPE app_type IS fnd_application%ROWTYPE;
14: SUBTYPE tbl_type IS fnd_tables%ROWTYPE;
15: SUBTYPE col_type IS fnd_columns%ROWTYPE;
16: SUBTYPE rsp_type IS fnd_responsibility%ROWTYPE;
17:
18: SUBTYPE vst_set_type IS fnd_flex_value_sets%ROWTYPE;

Line 180: FROM fnd_tables

176: IS
177: BEGIN
178: SELECT *
179: INTO x_tbl
180: FROM fnd_tables
181: WHERE application_id = p_application_id
182: AND table_name = p_table_name;
183: RETURN(TRUE);
184: EXCEPTION

Line 186: x_message := msg_uts('FND_TABLES',

182: AND table_name = p_table_name;
183: RETURN(TRUE);
184: EXCEPTION
185: WHEN OTHERS THEN
186: x_message := msg_uts('FND_TABLES',
187: 'application_id', p_application_id,
188: 'table_name', p_table_name);
189: RETURN(FALSE);
190: END fetch_tbl;

Line 903: FROM fnd_tables ft

899: BEGIN
900: SELECT ft.table_name || '/' ||
901: To_char(table_id)
902: INTO l_return
903: FROM fnd_tables ft
904: WHERE ft.application_id = p_application_id
905: AND ft.table_name = p_table_name;
906: EXCEPTION
907: WHEN no_data_found THEN

Line 909: '/get_tbl(FND_TABLES): no data found.'));

905: AND ft.table_name = p_table_name;
906: EXCEPTION
907: WHEN no_data_found THEN
908: RETURN(line_return(p_table_name ||
909: '/get_tbl(FND_TABLES): no data found.'));
910: END;
911: BEGIN
912: SELECT us.table_owner || '/' || l_return
913: INTO l_return

Line 950: FROM fnd_tables

946: INTO l_return
947: FROM fnd_columns
948: WHERE ((application_id, table_id) =
949: (SELECT application_id, table_id
950: FROM fnd_tables
951: WHERE application_id = p_application_id
952: AND table_name = p_table_name))
953: AND column_name = p_column_name;
954: RETURN(line_return(l_return));

Line 2547: FROM user_synonyms us, fnd_tables ft, fnd_descriptive_flexs df

2543: SELECT us.table_owner || '/' ||
2544: ft.table_name || '/' ||
2545: To_char(table_id)
2546: INTO l_return
2547: FROM user_synonyms us, fnd_tables ft, fnd_descriptive_flexs df
2548: WHERE us.synonym_name = df.application_table_name
2549: AND ft.application_id = df.table_application_id
2550: AND ft.table_name = df.application_table_name
2551: AND df.application_id = p_application_id

Line 2577: FROM fnd_columns fc, fnd_tables ft, fnd_descriptive_flexs df

2573: fc.flexfield_usage_code || '/' ||
2574: Nvl(To_char(fc.flexfield_application_id), '') || '/' ||
2575: Nvl(fc.flexfield_name, '')
2576: INTO l_return
2577: FROM fnd_columns fc, fnd_tables ft, fnd_descriptive_flexs df
2578: WHERE df.application_id = p_application_id
2579: AND df.descriptive_flexfield_name = p_descriptive_flexfield_name
2580: AND ft.application_id = df.table_application_id
2581: AND ft.table_name = df.application_table_name

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