[Home] [Help]
677: p_context varchar2) is
678: SELECT DFCU.application_column_name c_def_text,
679: replace(replace(replace (ltrim(rtrim(upper(DFCU.end_user_column_name))),
680: ' ','_'),'.',''),'-','_') c_db_name
681: FROM fnd_descr_flex_column_usages DFCU
682: WHERE DFCU.descriptive_flexfield_name = p_descr_flex
683: AND DFCU.application_id IN (800, 801, 804, 805, 808, 8301)
684: AND DFCU.descriptive_flex_context_code = p_context
685: AND DFCU.enabled_flag = 'Y';
6557: as '%'
6558: --
6559: The database items created use the name as defined in the column
6560: 'end_user_column_name' from the foundation table
6561: 'fnd_descr_flex_column_usages'. For a given descriptive flexfield there
6562: could be several database items.
6563: --
6564: NOTES
6565: Since there is no desciptive flex id to identify an individual row in
6646: title of the descriptive flex and the context.
6647: --
6648: The database items created use the name as defined in the column
6649: 'end_user_column_name' from the foundation table
6650: 'fnd_descr_flex_column_usages'. For a given descriptive flexfield there
6651: could be several database items.
6652: --
6653: This same procedure is called by different reports:
6654: --
7022: in are the payment type id.
7023: --
7024: The database items created use the name as defined in the column
7025: 'end_user_column_name' from the foundation table
7026: 'fnd_descr_flex_column_usages'. For a given descriptive flexfield there
7027: could be several database items.
7028: NOTES
7029: Since there is no desciptive flex id to identify an individual row in
7030: the ff_user_entities table, the title of the descriptive flex is used
7089: the DFF with the payment type name as prefix.
7090: --
7091: The database items created use the name as defined in the column
7092: 'end_user_column_name' from the foundation table
7093: 'fnd_descr_flex_column_usages'. For a given descriptive flexfield there
7094: could be several database items.
7095: DB Item Format :
7096: NOTES
7097: Since there is no desciptive flex id to identify an individual row in