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 2078: FROM fnd_flex_values_vl

2074:
2075: CURSOR IND_cursor(vsid IN NUMBER, val IN VARCHAR2) IS
2076: SELECT enabled_flag, start_date_active, end_date_active,
2077: summary_flag, compiled_value_attributes, description
2078: FROM fnd_flex_values_vl
2079: WHERE flex_value_set_id = vsid
2080: AND flex_value = val;
2081:
2082: CURSOR DEP_cursor(vsid IN NUMBER, val IN VARCHAR2, parnt IN VARCHAR2) IS

Line 2085: FROM fnd_flex_values_vl

2081:
2082: CURSOR DEP_cursor(vsid IN NUMBER, val IN VARCHAR2, parnt IN VARCHAR2) IS
2083: SELECT enabled_flag, start_date_active, end_date_active,
2084: summary_flag, compiled_value_attributes, description
2085: FROM fnd_flex_values_vl
2086: WHERE flex_value_set_id = vsid
2087: AND flex_value = val
2088: AND parent_flex_value_low = parnt;
2089:

Line 2096: FROM fnd_flex_values_vl

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

Line 2108: FROM fnd_flex_values_vl

2104: p_is_value IN VARCHAR2) IS
2105: SELECT enabled_flag, start_date_active, end_date_active,
2106: summary_flag, compiled_value_attributes,
2107: flex_value, flex_value_meaning, description
2108: FROM fnd_flex_values_vl
2109: WHERE flex_value_set_id = vsid
2110: AND parent_flex_value_low = parnt
2111: AND (((p_is_value = 'V') AND (flex_value_meaning = val)) OR
2112: ((p_is_value = 'I') AND (flex_value = val)));

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

2488: l_tbl_rec tbl_cursor%ROWTYPE;
2489: l_sql_pieces sql_pieces_tab_type;
2490: BEGIN
2491: IF (p_vs_info.valtype IN ('I', 'D', 'X', 'Y')) THEN
2492: l_tbl_rec.application_table_name := 'FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL';
2493: l_tbl_rec.value_column_name := 'FND_FLEX_VALUES_VL.FLEX_VALUE';
2494: l_tbl_rec.value_column_type := 'C';
2495: l_tbl_rec.id_column_name := NULL;
2496: l_tbl_rec.id_column_type := NULL;

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

2489: l_sql_pieces sql_pieces_tab_type;
2490: BEGIN
2491: IF (p_vs_info.valtype IN ('I', 'D', 'X', 'Y')) THEN
2492: l_tbl_rec.application_table_name := 'FND_FLEX_VALUES_VL FND_FLEX_VALUES_VL';
2493: l_tbl_rec.value_column_name := 'FND_FLEX_VALUES_VL.FLEX_VALUE';
2494: l_tbl_rec.value_column_type := 'C';
2495: l_tbl_rec.id_column_name := NULL;
2496: l_tbl_rec.id_column_type := NULL;
2497: l_tbl_rec.meaning_column_name := 'FND_FLEX_VALUES_VL.DESCRIPTION';

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

2493: l_tbl_rec.value_column_name := 'FND_FLEX_VALUES_VL.FLEX_VALUE';
2494: l_tbl_rec.value_column_type := 'C';
2495: l_tbl_rec.id_column_name := NULL;
2496: l_tbl_rec.id_column_type := NULL;
2497: l_tbl_rec.meaning_column_name := 'FND_FLEX_VALUES_VL.DESCRIPTION';
2498: l_tbl_rec.meaning_column_type := 'C';
2499: l_tbl_rec.enabled_column_name := 'FND_FLEX_VALUES_VL.ENABLED_FLAG';
2500: l_tbl_rec.start_date_column_name := 'FND_FLEX_VALUES_VL.START_DATE_ACTIVE';
2501: l_tbl_rec.end_date_column_name := 'FND_FLEX_VALUES_VL.END_DATE_ACTIVE';

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

2495: l_tbl_rec.id_column_name := NULL;
2496: l_tbl_rec.id_column_type := NULL;
2497: l_tbl_rec.meaning_column_name := 'FND_FLEX_VALUES_VL.DESCRIPTION';
2498: l_tbl_rec.meaning_column_type := 'C';
2499: l_tbl_rec.enabled_column_name := 'FND_FLEX_VALUES_VL.ENABLED_FLAG';
2500: l_tbl_rec.start_date_column_name := 'FND_FLEX_VALUES_VL.START_DATE_ACTIVE';
2501: l_tbl_rec.end_date_column_name := 'FND_FLEX_VALUES_VL.END_DATE_ACTIVE';
2502: l_tbl_rec.summary_column_name := 'FND_FLEX_VALUES_VL.SUMMARY_FLAG';
2503: l_tbl_rec.compiled_attribute_column_name := 'FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES';

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

2496: l_tbl_rec.id_column_type := NULL;
2497: l_tbl_rec.meaning_column_name := 'FND_FLEX_VALUES_VL.DESCRIPTION';
2498: l_tbl_rec.meaning_column_type := 'C';
2499: l_tbl_rec.enabled_column_name := 'FND_FLEX_VALUES_VL.ENABLED_FLAG';
2500: l_tbl_rec.start_date_column_name := 'FND_FLEX_VALUES_VL.START_DATE_ACTIVE';
2501: l_tbl_rec.end_date_column_name := 'FND_FLEX_VALUES_VL.END_DATE_ACTIVE';
2502: l_tbl_rec.summary_column_name := 'FND_FLEX_VALUES_VL.SUMMARY_FLAG';
2503: l_tbl_rec.compiled_attribute_column_name := 'FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES';
2504: l_tbl_rec.additional_quickpick_columns := NULL;

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

2497: l_tbl_rec.meaning_column_name := 'FND_FLEX_VALUES_VL.DESCRIPTION';
2498: l_tbl_rec.meaning_column_type := 'C';
2499: l_tbl_rec.enabled_column_name := 'FND_FLEX_VALUES_VL.ENABLED_FLAG';
2500: l_tbl_rec.start_date_column_name := 'FND_FLEX_VALUES_VL.START_DATE_ACTIVE';
2501: l_tbl_rec.end_date_column_name := 'FND_FLEX_VALUES_VL.END_DATE_ACTIVE';
2502: l_tbl_rec.summary_column_name := 'FND_FLEX_VALUES_VL.SUMMARY_FLAG';
2503: l_tbl_rec.compiled_attribute_column_name := 'FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES';
2504: l_tbl_rec.additional_quickpick_columns := NULL;
2505: l_tbl_rec.summary_allowed_flag := 'N';

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

2498: l_tbl_rec.meaning_column_type := 'C';
2499: l_tbl_rec.enabled_column_name := 'FND_FLEX_VALUES_VL.ENABLED_FLAG';
2500: l_tbl_rec.start_date_column_name := 'FND_FLEX_VALUES_VL.START_DATE_ACTIVE';
2501: l_tbl_rec.end_date_column_name := 'FND_FLEX_VALUES_VL.END_DATE_ACTIVE';
2502: l_tbl_rec.summary_column_name := 'FND_FLEX_VALUES_VL.SUMMARY_FLAG';
2503: l_tbl_rec.compiled_attribute_column_name := 'FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES';
2504: l_tbl_rec.additional_quickpick_columns := NULL;
2505: l_tbl_rec.summary_allowed_flag := 'N';
2506:

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

2499: l_tbl_rec.enabled_column_name := 'FND_FLEX_VALUES_VL.ENABLED_FLAG';
2500: l_tbl_rec.start_date_column_name := 'FND_FLEX_VALUES_VL.START_DATE_ACTIVE';
2501: l_tbl_rec.end_date_column_name := 'FND_FLEX_VALUES_VL.END_DATE_ACTIVE';
2502: l_tbl_rec.summary_column_name := 'FND_FLEX_VALUES_VL.SUMMARY_FLAG';
2503: l_tbl_rec.compiled_attribute_column_name := 'FND_FLEX_VALUES_VL.COMPILED_VALUE_ATTRIBUTES';
2504: l_tbl_rec.additional_quickpick_columns := NULL;
2505: l_tbl_rec.summary_allowed_flag := 'N';
2506:
2507: IF (p_parent_value IS NULL) THEN

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

2504: l_tbl_rec.additional_quickpick_columns := NULL;
2505: l_tbl_rec.summary_allowed_flag := 'N';
2506:
2507: IF (p_parent_value IS NULL) THEN
2508: l_tbl_rec.additional_where_clause := 'WHERE FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :$FLEX$.$VALUE_SET_ID$';
2509: ELSE
2510: l_tbl_rec.additional_where_clause := 'WHERE FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :$FLEX$.$VALUE_SET_ID$' ||
2511: ' AND FND_FLEX_VALUES_VL.PARENT_FLEX_VALUE_LOW = :$FLEX$.$PARENT_VALUE$';
2512: END IF;

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

2506:
2507: IF (p_parent_value IS NULL) THEN
2508: l_tbl_rec.additional_where_clause := 'WHERE FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :$FLEX$.$VALUE_SET_ID$';
2509: ELSE
2510: l_tbl_rec.additional_where_clause := 'WHERE FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :$FLEX$.$VALUE_SET_ID$' ||
2511: ' AND FND_FLEX_VALUES_VL.PARENT_FLEX_VALUE_LOW = :$FLEX$.$PARENT_VALUE$';
2512: END IF;
2513:
2514: ELSE

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

2507: IF (p_parent_value IS NULL) THEN
2508: l_tbl_rec.additional_where_clause := 'WHERE FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :$FLEX$.$VALUE_SET_ID$';
2509: ELSE
2510: l_tbl_rec.additional_where_clause := 'WHERE FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID = :$FLEX$.$VALUE_SET_ID$' ||
2511: ' AND FND_FLEX_VALUES_VL.PARENT_FLEX_VALUE_LOW = :$FLEX$.$PARENT_VALUE$';
2512: END IF;
2513:
2514: ELSE
2515: open TBL_cursor(p_vs_info.vsid);