214: RETURN(FALSE);
215: END column_exists;
216:
217: -- --------------------------------------------------
218: FUNCTION is_fake_table(p_application_id IN fnd_tables.application_id%TYPE,
219: p_table_name IN fnd_tables.table_name%TYPE)
220: RETURN BOOLEAN
221: IS
222: l_table_type fnd_tables.table_type%TYPE;
215: END column_exists;
216:
217: -- --------------------------------------------------
218: FUNCTION is_fake_table(p_application_id IN fnd_tables.application_id%TYPE,
219: p_table_name IN fnd_tables.table_name%TYPE)
220: RETURN BOOLEAN
221: IS
222: l_table_type fnd_tables.table_type%TYPE;
223: BEGIN
218: FUNCTION is_fake_table(p_application_id IN fnd_tables.application_id%TYPE,
219: p_table_name IN fnd_tables.table_name%TYPE)
220: RETURN BOOLEAN
221: IS
222: l_table_type fnd_tables.table_type%TYPE;
223: BEGIN
224: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
225: ft.table_type
226: INTO l_table_type
223: BEGIN
224: SELECT /* $Header: AFFFUPUB.pls 120.4.12010000.1 2008/07/25 14:14:37 appldev ship $ */
225: ft.table_type
226: INTO l_table_type
227: FROM fnd_tables ft
228: WHERE ft.application_id = p_application_id
229: AND ft.table_name = p_table_name;
230:
231: IF (l_table_type = 'F') THEN
1455: AND dfc.descriptive_flexfield_name = dfcu.descriptive_flexfield_name
1456: AND dfc.descriptive_flex_context_code = dfcu.descriptive_flex_context_code
1457: AND ((fc.application_id, fc.table_id) =
1458: (SELECT ft.application_id, ft.table_id
1459: FROM fnd_tables ft
1460: WHERE ft.application_id = df.table_application_id
1461: AND ft.table_name = df.application_table_name))
1462: AND fc.column_name = dfcu.application_column_name
1463: AND fc.flexfield_usage_code = 'D'
1642: AND ifst.id_flex_code = ifsg.id_flex_code
1643: AND ifst.id_flex_num = ifsg.id_flex_num
1644: AND ((fc.application_id, fc.table_id) =
1645: (SELECT ft.application_id, ft.table_id
1646: FROM fnd_tables ft
1647: WHERE ft.application_id = idf.table_application_id
1648: AND ft.table_name = idf.application_table_name))
1649: AND fc.column_name = ifsg.application_column_name
1650: AND fc.flexfield_usage_code = 'K'
2255: AND dfc.descriptive_flexfield_name = dfcu.descriptive_flexfield_name
2256: AND dfc.descriptive_flex_context_code = dfcu.descriptive_flex_context_code
2257: AND ((fc.application_id, fc.table_id) =
2258: (SELECT ft.application_id, ft.table_id
2259: FROM fnd_tables ft
2260: WHERE ft.application_id = df.table_application_id
2261: AND ft.table_name = df.application_table_name))
2262: AND fc.column_name = dfcu.application_column_name
2263: AND fc.flexfield_usage_code = 'D'
2288: AND ifst.id_flex_code = ifsg.id_flex_code
2289: AND ifst.id_flex_num = ifsg.id_flex_num
2290: AND ((fc.application_id, fc.table_id) =
2291: (SELECT ft.application_id, ft.table_id
2292: FROM fnd_tables ft
2293: WHERE ft.application_id = idf.table_application_id
2294: AND ft.table_name = idf.application_table_name))
2295: AND fc.column_name = ifsg.application_column_name
2296: AND fc.flexfield_usage_code = 'K'