DBA Data[Home] [Help]

APPS.FND_FLEX_XML_PUBLISHER_APIS dependencies on FND_TABLES

Line 2450: FROM fnd_columns,fnd_tables,fnd_id_flexs

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

Line 2452: AND fnd_columns.table_id = fnd_tables.table_id

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

Line 2453: AND fnd_columns.application_id = fnd_tables.application_id

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

Line 2454: AND fnd_tables.table_name = fnd_id_flexs.application_table_name

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

Line 2455: AND fnd_tables.application_id = fnd_id_flexs.table_application_id

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