DBA Data[Home] [Help]

APPS.FND_FLEX_XML_PUBLISHER_APIS dependencies on FND_TABLES

Line 2447: FROM fnd_columns,fnd_tables,fnd_id_flexs

2443: l_format_mask VARCHAR2(30);
2444: BEGIN
2445: SELECT fnd_columns.column_type
2446: INTO l_datatype
2447: FROM fnd_columns,fnd_tables,fnd_id_flexs
2448: WHERE fnd_columns.column_name = p_column_name
2449: AND fnd_columns.table_id = fnd_tables.table_id
2450: AND fnd_columns.application_id = fnd_tables.application_id
2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name

Line 2449: AND fnd_columns.table_id = fnd_tables.table_id

2445: SELECT fnd_columns.column_type
2446: INTO l_datatype
2447: FROM fnd_columns,fnd_tables,fnd_id_flexs
2448: WHERE fnd_columns.column_name = p_column_name
2449: AND fnd_columns.table_id = fnd_tables.table_id
2450: AND fnd_columns.application_id = fnd_tables.application_id
2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name
2452: AND fnd_tables.application_id = fnd_id_flexs.table_application_id
2453: AND fnd_id_flexs.id_flex_code = l_kff_flx.id_flex_code

Line 2450: AND fnd_columns.application_id = fnd_tables.application_id

2446: INTO l_datatype
2447: FROM fnd_columns,fnd_tables,fnd_id_flexs
2448: WHERE fnd_columns.column_name = p_column_name
2449: AND fnd_columns.table_id = fnd_tables.table_id
2450: AND fnd_columns.application_id = fnd_tables.application_id
2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name
2452: AND fnd_tables.application_id = fnd_id_flexs.table_application_id
2453: AND fnd_id_flexs.id_flex_code = l_kff_flx.id_flex_code
2454: AND fnd_id_flexs.application_id = l_kff_flx.application_id;

Line 2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name

2447: FROM fnd_columns,fnd_tables,fnd_id_flexs
2448: WHERE fnd_columns.column_name = p_column_name
2449: AND fnd_columns.table_id = fnd_tables.table_id
2450: AND fnd_columns.application_id = fnd_tables.application_id
2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name
2452: AND fnd_tables.application_id = fnd_id_flexs.table_application_id
2453: AND fnd_id_flexs.id_flex_code = l_kff_flx.id_flex_code
2454: AND fnd_id_flexs.application_id = l_kff_flx.application_id;
2455:

Line 2452: AND fnd_tables.application_id = fnd_id_flexs.table_application_id

2448: WHERE fnd_columns.column_name = p_column_name
2449: AND fnd_columns.table_id = fnd_tables.table_id
2450: AND fnd_columns.application_id = fnd_tables.application_id
2451: AND fnd_tables.table_name = fnd_id_flexs.application_table_name
2452: AND fnd_tables.application_id = fnd_id_flexs.table_application_id
2453: AND fnd_id_flexs.id_flex_code = l_kff_flx.id_flex_code
2454: AND fnd_id_flexs.application_id = l_kff_flx.application_id;
2455:
2456: p_bind_variable.name := p_lexical_name || p_bind_variable_num;