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_SERVER1 dependencies on FND_FLEX_VALUES_VL

Line 2064: FROM fnd_flex_values_vl

2060:
2061: CURSOR IND_cursor(vsid IN NUMBER, val IN VARCHAR2) IS
2062: SELECT enabled_flag, start_date_active, end_date_active,
2063: summary_flag, compiled_value_attributes, description
2064: FROM fnd_flex_values_vl
2065: WHERE flex_value_set_id = vsid
2066: AND flex_value = val;
2067:
2068: CURSOR DEP_cursor(vsid IN NUMBER, val IN VARCHAR2, parnt IN VARCHAR2) IS

Line 2071: FROM fnd_flex_values_vl

2067:
2068: CURSOR DEP_cursor(vsid IN NUMBER, val IN VARCHAR2, parnt IN VARCHAR2) IS
2069: SELECT enabled_flag, start_date_active, end_date_active,
2070: summary_flag, compiled_value_attributes, description
2071: FROM fnd_flex_values_vl
2072: WHERE flex_value_set_id = vsid
2073: AND flex_value = val
2074: AND parent_flex_value_low = parnt;
2075:

Line 2082: FROM fnd_flex_values_vl

2078: p_is_value IN VARCHAR2) IS
2079: SELECT enabled_flag, start_date_active, end_date_active,
2080: summary_flag, compiled_value_attributes,
2081: flex_value, flex_value_meaning, description
2082: FROM fnd_flex_values_vl
2083: WHERE flex_value_set_id = vsid
2084: AND (((p_is_value = 'V') AND (flex_value_meaning = val)) OR
2085: ((p_is_value = 'I') AND (flex_value = val)));
2086:

Line 2094: FROM fnd_flex_values_vl

2090: p_is_value IN VARCHAR2) IS
2091: SELECT enabled_flag, start_date_active, end_date_active,
2092: summary_flag, compiled_value_attributes,
2093: flex_value, flex_value_meaning, description
2094: FROM fnd_flex_values_vl
2095: WHERE flex_value_set_id = vsid
2096: AND parent_flex_value_low = parnt
2097: AND (((p_is_value = 'V') AND (flex_value_meaning = val)) OR
2098: ((p_is_value = 'I') AND (flex_value = val)));

Line 2473: l_tbl_rec.application_table_name := 'FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL';

2469: l_tbl_rec tbl_cursor%ROWTYPE;
2470: l_sql_pieces sql_pieces_tab_type;
2471: BEGIN
2472: IF (p_vs_info.valtype IN ('I', 'D', 'X', 'Y')) THEN
2473: l_tbl_rec.application_table_name := 'FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL';
2474: l_tbl_rec.value_column_name := 'FND_FLEX_VALUES_VL.FLEX_VALUE';
2475: l_tbl_rec.value_column_type := 'C';
2476: l_tbl_rec.id_column_name := NULL;
2477: l_tbl_rec.id_column_type := NULL;

Line 2474: l_tbl_rec.value_column_name := 'FND_FLEX_VALUES_VL.FLEX_VALUE';

2470: l_sql_pieces sql_pieces_tab_type;
2471: BEGIN
2472: IF (p_vs_info.valtype IN ('I', 'D', 'X', 'Y')) THEN
2473: l_tbl_rec.application_table_name := 'FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL';
2474: l_tbl_rec.value_column_name := 'FND_FLEX_VALUES_VL.FLEX_VALUE';
2475: l_tbl_rec.value_column_type := 'C';
2476: l_tbl_rec.id_column_name := NULL;
2477: l_tbl_rec.id_column_type := NULL;
2478: l_tbl_rec.meaning_column_name := 'FND_FLEX_VALUES_VL.DESCRIPTION';

Line 2478: l_tbl_rec.meaning_column_name := 'FND_FLEX_VALUES_VL.DESCRIPTION';

2474: l_tbl_rec.value_column_name := 'FND_FLEX_VALUES_VL.FLEX_VALUE';
2475: l_tbl_rec.value_column_type := 'C';
2476: l_tbl_rec.id_column_name := NULL;
2477: l_tbl_rec.id_column_type := NULL;
2478: l_tbl_rec.meaning_column_name := 'FND_FLEX_VALUES_VL.DESCRIPTION';
2479: l_tbl_rec.meaning_column_type := 'C';
2480: l_tbl_rec.enabled_column_name := 'FND_FLEX_VALUES_VL.ENABLED_FLAG';
2481: l_tbl_rec.start_date_column_name := 'FND_FLEX_VALUES_VL.START_DATE_ACTIVE';
2482: l_tbl_rec.end_date_column_name := 'FND_FLEX_VALUES_VL.END_DATE_ACTIVE';

Line 2480: l_tbl_rec.enabled_column_name := 'FND_FLEX_VALUES_VL.ENABLED_FLAG';

2476: l_tbl_rec.id_column_name := NULL;
2477: l_tbl_rec.id_column_type := NULL;
2478: l_tbl_rec.meaning_column_name := 'FND_FLEX_VALUES_VL.DESCRIPTION';
2479: l_tbl_rec.meaning_column_type := 'C';
2480: l_tbl_rec.enabled_column_name := 'FND_FLEX_VALUES_VL.ENABLED_FLAG';
2481: l_tbl_rec.start_date_column_name := 'FND_FLEX_VALUES_VL.START_DATE_ACTIVE';
2482: l_tbl_rec.end_date_column_name := 'FND_FLEX_VALUES_VL.END_DATE_ACTIVE';
2483: l_tbl_rec.summary_column_name := 'FND_FLEX_VALUES_VL.SUMMARY_FLAG';
2484: l_tbl_rec.compiled_attribute_column_name := 'FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES';

Line 2481: l_tbl_rec.start_date_column_name := 'FND_FLEX_VALUES_VL.START_DATE_ACTIVE';

2477: l_tbl_rec.id_column_type := NULL;
2478: l_tbl_rec.meaning_column_name := 'FND_FLEX_VALUES_VL.DESCRIPTION';
2479: l_tbl_rec.meaning_column_type := 'C';
2480: l_tbl_rec.enabled_column_name := 'FND_FLEX_VALUES_VL.ENABLED_FLAG';
2481: l_tbl_rec.start_date_column_name := 'FND_FLEX_VALUES_VL.START_DATE_ACTIVE';
2482: l_tbl_rec.end_date_column_name := 'FND_FLEX_VALUES_VL.END_DATE_ACTIVE';
2483: l_tbl_rec.summary_column_name := 'FND_FLEX_VALUES_VL.SUMMARY_FLAG';
2484: l_tbl_rec.compiled_attribute_column_name := 'FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES';
2485: l_tbl_rec.additional_quickpick_columns := NULL;

Line 2482: l_tbl_rec.end_date_column_name := 'FND_FLEX_VALUES_VL.END_DATE_ACTIVE';

2478: l_tbl_rec.meaning_column_name := 'FND_FLEX_VALUES_VL.DESCRIPTION';
2479: l_tbl_rec.meaning_column_type := 'C';
2480: l_tbl_rec.enabled_column_name := 'FND_FLEX_VALUES_VL.ENABLED_FLAG';
2481: l_tbl_rec.start_date_column_name := 'FND_FLEX_VALUES_VL.START_DATE_ACTIVE';
2482: l_tbl_rec.end_date_column_name := 'FND_FLEX_VALUES_VL.END_DATE_ACTIVE';
2483: l_tbl_rec.summary_column_name := 'FND_FLEX_VALUES_VL.SUMMARY_FLAG';
2484: l_tbl_rec.compiled_attribute_column_name := 'FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES';
2485: l_tbl_rec.additional_quickpick_columns := NULL;
2486: l_tbl_rec.summary_allowed_flag := 'N';

Line 2483: l_tbl_rec.summary_column_name := 'FND_FLEX_VALUES_VL.SUMMARY_FLAG';

2479: l_tbl_rec.meaning_column_type := 'C';
2480: l_tbl_rec.enabled_column_name := 'FND_FLEX_VALUES_VL.ENABLED_FLAG';
2481: l_tbl_rec.start_date_column_name := 'FND_FLEX_VALUES_VL.START_DATE_ACTIVE';
2482: l_tbl_rec.end_date_column_name := 'FND_FLEX_VALUES_VL.END_DATE_ACTIVE';
2483: l_tbl_rec.summary_column_name := 'FND_FLEX_VALUES_VL.SUMMARY_FLAG';
2484: l_tbl_rec.compiled_attribute_column_name := 'FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES';
2485: l_tbl_rec.additional_quickpick_columns := NULL;
2486: l_tbl_rec.summary_allowed_flag := 'N';
2487:

Line 2484: l_tbl_rec.compiled_attribute_column_name := 'FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES';

2480: l_tbl_rec.enabled_column_name := 'FND_FLEX_VALUES_VL.ENABLED_FLAG';
2481: l_tbl_rec.start_date_column_name := 'FND_FLEX_VALUES_VL.START_DATE_ACTIVE';
2482: l_tbl_rec.end_date_column_name := 'FND_FLEX_VALUES_VL.END_DATE_ACTIVE';
2483: l_tbl_rec.summary_column_name := 'FND_FLEX_VALUES_VL.SUMMARY_FLAG';
2484: l_tbl_rec.compiled_attribute_column_name := 'FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES';
2485: l_tbl_rec.additional_quickpick_columns := NULL;
2486: l_tbl_rec.summary_allowed_flag := 'N';
2487:
2488: IF (p_parent_value IS NULL) THEN

Line 2489: l_tbl_rec.additional_where_clause := 'WHERE FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :$FLEX$.$VALUE_SET_ID$';

2485: l_tbl_rec.additional_quickpick_columns := NULL;
2486: l_tbl_rec.summary_allowed_flag := 'N';
2487:
2488: IF (p_parent_value IS NULL) THEN
2489: l_tbl_rec.additional_where_clause := 'WHERE FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :$FLEX$.$VALUE_SET_ID$';
2490: ELSE
2491: l_tbl_rec.additional_where_clause := 'WHERE FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :$FLEX$.$VALUE_SET_ID$' ||
2492: ' AND FND_FLEX_VALUES_VL.PARENT_FLEX_VALUE_LOW = :$FLEX$.$PARENT_VALUE$';
2493: END IF;

Line 2491: l_tbl_rec.additional_where_clause := 'WHERE FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :$FLEX$.$VALUE_SET_ID$' ||

2487:
2488: IF (p_parent_value IS NULL) THEN
2489: l_tbl_rec.additional_where_clause := 'WHERE FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :$FLEX$.$VALUE_SET_ID$';
2490: ELSE
2491: l_tbl_rec.additional_where_clause := 'WHERE FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :$FLEX$.$VALUE_SET_ID$' ||
2492: ' AND FND_FLEX_VALUES_VL.PARENT_FLEX_VALUE_LOW = :$FLEX$.$PARENT_VALUE$';
2493: END IF;
2494:
2495: ELSE

Line 2492: ' AND FND_FLEX_VALUES_VL.PARENT_FLEX_VALUE_LOW = :$FLEX$.$PARENT_VALUE$';

2488: IF (p_parent_value IS NULL) THEN
2489: l_tbl_rec.additional_where_clause := 'WHERE FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :$FLEX$.$VALUE_SET_ID$';
2490: ELSE
2491: l_tbl_rec.additional_where_clause := 'WHERE FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :$FLEX$.$VALUE_SET_ID$' ||
2492: ' AND FND_FLEX_VALUES_VL.PARENT_FLEX_VALUE_LOW = :$FLEX$.$PARENT_VALUE$';
2493: END IF;
2494:
2495: ELSE
2496: open TBL_cursor(p_vs_info.vsid);