eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FND_FLEX_VAL_API dependencies on FND_COLUMNS

Line 214: FROM fnd_columns c, fnd_tables t

210:
211: BEGIN
212: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
213: column_name INTO hierarchy_level_column_name
214: FROM fnd_columns c, fnd_tables t
215: WHERE c.column_name = 'STRUCTURED_HIERARCHY_LEVEL'
216: AND t.table_name = application_table_name
217: AND t.application_id= table_application_id
218: AND t.table_id = c.table_id

Line 229: FROM fnd_columns c, fnd_tables t

225:
226: BEGIN
227: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
228: column_name INTO enabled_column_name
229: FROM fnd_columns c, fnd_tables t
230: WHERE c.column_name = 'ENABLED_FLAG'
231: AND c.column_type IN ('C', 'V')
232: AND t.table_name = application_table_name
233: AND t.application_id= table_application_id

Line 245: FROM fnd_columns c, fnd_tables t

241:
242: BEGIN
243: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
244: column_name INTO start_date_column_name
245: FROM fnd_columns c, fnd_tables t
246: WHERE c.column_name = 'START_DATE_ACTIVE'
247: AND t.table_name = application_table_name
248: AND t.application_id= table_application_id
249: AND t.table_id = c.table_id

Line 260: FROM fnd_columns c, fnd_tables t

256:
257: BEGIN
258: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
259: column_name INTO end_date_column_name
260: FROM fnd_columns c, fnd_tables t
261: WHERE c.column_name = 'END_DATE_ACTIVE'
262: AND t.table_name = application_table_name
263: AND t.application_id= table_application_id
264: AND t.table_id = c.table_id

Line 275: FROM fnd_columns c, fnd_tables t

271:
272: BEGIN
273: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
274: column_name INTO summary_column_name
275: FROM fnd_columns c, fnd_tables t
276: WHERE c.column_name = 'SUMMARY_FLAG'
277: AND t.table_name = application_table_name
278: AND t.application_id= table_application_id
279: AND t.table_id = c.table_id

Line 290: FROM fnd_columns c, fnd_tables t

286:
287: BEGIN
288: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
289: column_name INTO compiled_attribute_column_name
290: FROM fnd_columns c, fnd_tables t
291: WHERE c.column_name = 'COMPILED_VALUE_ATTRIBUTES'
292: AND t.table_name = application_table_name
293: AND t.application_id= table_application_id
294: AND t.table_id = c.table_id

Line 481: FROM fnd_tables t, fnd_lookup_values l, fnd_columns c

477: BEGIN
478: IF(column_name_in IS NOT NULL) THEN
479: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
480: NULL INTO dummy
481: FROM fnd_tables t, fnd_lookup_values l, fnd_columns c
482: WHERE t.application_id = table_application_id_in
483: AND t.table_name = application_table_name_in
484: AND c.application_id = t.application_id
485: AND c.column_name = column_name_in

Line 505: column_type_i fnd_columns.column_type%TYPE;

501: application_table_name_in IN VARCHAR2,
502: column_name_in IN VARCHAR2,
503: format_type_in IN VARCHAR2)
504: IS
505: column_type_i fnd_columns.column_type%TYPE;
506: dummy NUMBER;
507: BEGIN
508: BEGIN
509: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */

Line 512: FROM fnd_tables t, fnd_lookup_values l, fnd_columns c

508: BEGIN
509: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
510: column_type
511: INTO column_type_i
512: FROM fnd_tables t, fnd_lookup_values l, fnd_columns c
513: WHERE t.application_id = table_application_id_in
514: AND t.table_name = application_table_name_in
515: AND c.application_id = t.application_id
516: AND c.table_id = t.table_id

Line 1956: FROM fnd_columns c, fnd_tables t

1952: BEGIN
1953: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1954: width
1955: INTO width_i
1956: FROM fnd_columns c, fnd_tables t
1957: WHERE (t.application_id = table_r.table_application_id
1958: OR table_r.table_application_id IS NULL)
1959: AND t.table_id = c.table_id
1960: AND t.application_id = c.application_id

Line 1988: FROM fnd_columns c, fnd_tables t

1984: BEGIN
1985: SELECT /* $Header: AFFFVAIB.pls 120.29 2011/10/19 20:43:07 hgeorgi ship $ */
1986: width
1987: INTO width_i
1988: FROM fnd_columns c, fnd_tables t
1989: WHERE (t.application_id = table_r.table_application_id
1990: OR table_r.table_application_id IS NULL)
1991: AND t.table_id = c.table_id
1992: AND t.application_id = c.application_id

Line 2589: p_column_name IN fnd_columns.column_name%TYPE,

2585:
2586:
2587: FUNCTION is_column_used(p_application_id IN fnd_tables.application_id%TYPE,
2588: p_table_name IN fnd_tables.table_name%TYPE,
2589: p_column_name IN fnd_columns.column_name%TYPE,
2590: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2591: IS
2592: up_table_name fnd_tables.table_name%TYPE;
2593: up_column_name fnd_columns.column_name%TYPE;

Line 2593: up_column_name fnd_columns.column_name%TYPE;

2589: p_column_name IN fnd_columns.column_name%TYPE,
2590: x_message OUT NOCOPY VARCHAR2) RETURN BOOLEAN
2591: IS
2592: up_table_name fnd_tables.table_name%TYPE;
2593: up_column_name fnd_columns.column_name%TYPE;
2594: l_vset_name fnd_flex_value_sets.flex_value_set_name%TYPE;
2595: BEGIN
2596: up_table_name := Upper(p_table_name);
2597: up_column_name := Upper(p_column_name);

Line 3855: fnd_columns c, fnd_tables tb

3851: l_column_type, l_appl_col_size
3852: FROM
3853: fnd_flex_value_sets v,
3854: fnd_flex_validation_tables t,
3855: fnd_columns c, fnd_tables tb
3856: WHERE
3857: v.flex_value_set_id = p_value_set_id and
3858: v.flex_value_set_id = t.flex_value_set_id(+) and
3859: tb.application_id = 0 and

Line 4194: p_application_column_type IN fnd_columns.column_type%TYPE,

4190:
4191: END is_valueset_allowed;
4192:
4193: PROCEDURE check_base_table_column(
4194: p_application_column_type IN fnd_columns.column_type%TYPE,
4195: p_application_column_size IN fnd_columns.width%TYPE,
4196: p_id_column_type IN fnd_flex_validation_tables.id_column_type%TYPE,
4197: p_id_column_size IN fnd_flex_validation_tables.id_column_size%TYPE,
4198: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,

Line 4195: p_application_column_size IN fnd_columns.width%TYPE,

4191: END is_valueset_allowed;
4192:
4193: PROCEDURE check_base_table_column(
4194: p_application_column_type IN fnd_columns.column_type%TYPE,
4195: p_application_column_size IN fnd_columns.width%TYPE,
4196: p_id_column_type IN fnd_flex_validation_tables.id_column_type%TYPE,
4197: p_id_column_size IN fnd_flex_validation_tables.id_column_size%TYPE,
4198: p_validation_type IN fnd_flex_value_sets.validation_type%TYPE,
4199: p_format_type IN fnd_flex_value_sets.format_type%TYPE,

Line 4381: fnd_columns c, fnd_tables tb

4377: c.column_type, c.width
4378: INTO
4379: l_application_column_type, l_application_column_size
4380: FROM
4381: fnd_columns c, fnd_tables tb
4382: WHERE
4383: tb.application_id = 0 and
4384: tb.table_name = 'FND_SRS_MASTER' and
4385: tb.application_id = c.application_id and

Line 4395: fnd_columns c

4391: l_application_column_type, l_application_column_size
4392: FROM
4393: fnd_descriptive_flexs dff,
4394: fnd_tables tb,
4395: fnd_columns c
4396: WHERE
4397: c.application_id = tb.application_id and
4398: c.table_id = tb.table_id and
4399: c.application_id = dff.table_application_id and

Line 4564: fnd_columns c

4560: l_application_column_type, l_application_column_size, l_allow_id_valuesets
4561: FROM
4562: fnd_id_flexs kff,
4563: fnd_tables tb,
4564: fnd_columns c
4565: WHERE
4566: c.application_id = tb.application_id and
4567: c.table_id = tb.table_id and
4568: c.application_id = kff.table_application_id and