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.POS_PRODUCT_SERVICE_UTL_PKG dependencies on FND_FLEX_VALUES_VL

Line 439: l_description fnd_flex_values_vl.description%TYPE;

435: ) RETURN VARCHAR2
436: IS
437: l_id_or_value fnd_flex_validation_tables.id_column_name%TYPE;
438: l_cur cursor_ref_type;
439: l_description fnd_flex_values_vl.description%TYPE;
440: l_description2 fnd_flex_values_vl.description%TYPE;
441: l_index NUMBER;
442: l_string varchar2(1000);
443: BEGIN

Line 440: l_description2 fnd_flex_values_vl.description%TYPE;

436: IS
437: l_id_or_value fnd_flex_validation_tables.id_column_name%TYPE;
438: l_cur cursor_ref_type;
439: l_description fnd_flex_values_vl.description%TYPE;
440: l_description2 fnd_flex_values_vl.description%TYPE;
441: l_index NUMBER;
442: l_string varchar2(1000);
443: BEGIN
444: IF g_product_segments(p_product_segment_index).validation_type = 'F' THEN -- table

Line 488: 'select description from fnd_flex_values_vl ' ||

484: using p_segment_value;
485: ELSIF g_product_segments(p_product_segment_index).validation_type IN ('I') THEN
486: -- validation type is independent
487: g_description_queries(p_product_segment_index) :=
488: 'select description from fnd_flex_values_vl ' ||
489: 'where flex_value_set_id = :1 and flex_value = :2 ';
490: OPEN l_cur FOR g_description_queries(p_product_segment_index)
491: using g_product_segments(p_product_segment_index).value_set_id, p_segment_value;
492: ELSIF g_product_segments(p_product_segment_index).validation_type IN ('D') THEN

Line 495: 'select description from fnd_flex_values_vl ' ||

491: using g_product_segments(p_product_segment_index).value_set_id, p_segment_value;
492: ELSIF g_product_segments(p_product_segment_index).validation_type IN ('D') THEN
493: -- validation type is dependent
494: g_description_queries(p_product_segment_index) :=
495: 'select description from fnd_flex_values_vl ' ||
496: ' where flex_value_set_id = :1 and flex_value = :2 and parent_flex_value_low = :3';
497: OPEN l_cur FOR g_description_queries(p_product_segment_index)
498: using g_product_segments(p_product_segment_index).value_set_id,
499: p_segment_value, p_parent_segment_value;

Line 1066: FROM fnd_flex_values_vl ffvl,

1062: /*Bug 9043064 (FP 9011350) Added a condition to pick the categories only that are viewable by supplier.*/
1063: l_tbl_sql := 'SELECT ffvl.flex_value,
1064: ffvl.description,
1065: ffvl.flex_value_id
1066: FROM fnd_flex_values_vl ffvl,
1067: mtl_categories_b mcb,
1068: mtl_category_set_valid_cats mcsvc
1069: WHERE ffvl.flex_value_set_id = '|| p_curr_seg_val_id ||
1070: ' AND mcb.category_id = mcsvc.category_id

Line 1124: from fnd_flex_values_vl ffvl,

1120: /*Bug 9043064 (FP 9011350) Added a condition to pick the categories only that are viewable by supplier.*/
1121:
1122: l_sql := 'select ffvl.flex_value,
1123: ffvl.flex_value_id
1124: from fnd_flex_values_vl ffvl,
1125: mtl_categories_b mcb,
1126: mtl_category_set_valid_cats mcsvc
1127: where ffvl.flex_value_set_id = ' || p_parent_seg_val_id || ' AND
1128: mcb.category_id = mcsvc.category_id

Line 1147: FROM fnd_flex_values_vl ffvl2,

1143: /*Bug 9043064 (FP 9011350) Added a condition to pick the categories only that are viewable by supplier.*/
1144: l_tbl_sql := 'SELECT ffvl2.flex_value,
1145: ffvl2.description,
1146: ffvl2.flex_value_id
1147: FROM fnd_flex_values_vl ffvl2,
1148: mtl_categories_b mcb1,
1149: mtl_category_set_valid_cats mcsvc1
1150: WHERE ffvl2.flex_value_set_id = ' || p_curr_seg_val_id || ' and
1151: mcb1.category_id = mcsvc1.category_id AND

Line 1949: FROM fnd_flex_values_vl

1945: l_curr_val product_service_ocv_rec;
1946:
1947: CURSOR l_flex_i_cursor(p_value_set_id NUMBER) IS
1948: SELECT flex_value, description
1949: FROM fnd_flex_values_vl
1950: WHERE flex_value_set_id = p_value_set_id;
1951:
1952: CURSOR l_flex_d_cursor(p_value_set_id NUMBER, p_parent_val VARCHAR2) IS
1953: SELECT flex_value, description

Line 1954: FROM fnd_flex_values_vl

1950: WHERE flex_value_set_id = p_value_set_id;
1951:
1952: CURSOR l_flex_d_cursor(p_value_set_id NUMBER, p_parent_val VARCHAR2) IS
1953: SELECT flex_value, description
1954: FROM fnd_flex_values_vl
1955: WHERE flex_value_set_id = p_value_set_id
1956: AND parent_flex_value_low = p_parent_val;
1957:
1958: BEGIN