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

Line 412: FROM fnd_flex_values_vl v, fnd_flex_value_norm_hierarchy h,

408: 'select a.flex_value_set_id,a.parent_flex_value, c.description parent_desc,'||
409: 'a.flex_value,a.description,a.summary_flag from
410: ( SELECT v.flex_value_set_id, h.parent_flex_value,
411: v.flex_value, v.description, v.summary_flag
412: FROM fnd_flex_values_vl v, fnd_flex_value_norm_hierarchy h,
413: fnd_flex_value_sets s, '||g_value_set_temp_table||' vst
414: WHERE vst.value_set_id = v.flex_value_set_id
415: AND h.flex_value_set_id = v.flex_value_set_id
416: AND s.flex_value_set_id = v.flex_value_set_id

Line 481: ' from fnd_flex_values_vl where flex_value_set_id in '||

477: end if;
478:
479: l_stmt:= 'create table '|| g_value_temp_table ||' storage (initial 5M next 1M pctincrease 0) '|| l_paral_clause ||
480: ' as select distinct flex_value_set_id,flex_value,description,summary_flag, ENABLED_FLAG '||
481: ' from fnd_flex_values_vl where flex_value_set_id in '||
482: '(select value_set_id from edw_flex_seg_mappings_v@' ||
483: G_TARGET_LINK ||
484: ' where dimension_short_name = '''|| g_dimension_name||''') '||
485: 'UNION '||

Line 565: p_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE

561: -- replaced by bulk_push_orphans
562: function push_orphans(
563: p_temp_table_name VARCHAR2,
564: p_set_of_books edw_local_set_of_books%ROWTYPE,
565: p_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE
566: ) return number as
567:
568: l_log_timstamp Date:=Null;
569: l_stmt varchar2(1000);

Line 799: p_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE

795: -- replaced by bulk_push_parent_child_pair
796: function push_parent_child_pair(
797: p_temp_table_name VARCHAR2,
798: p_set_of_books edw_local_set_of_books%ROWTYPE,
799: p_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE
800: ) return number as
801:
802: l_log_timstamp Date:=Null;
803: l_stmt varchar2(1000);

Line 1147: l_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE;

1143: p_dimension_no INTEGER;
1144: -- -------------------------------------------
1145: -- Put any additional developer variables here
1146: -- -------------------------------------------
1147: l_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE;
1148: l_parent_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE;
1149: l_child_edw_set_of_books_id number;
1150: l_parent_value FND_FLEX_VALUE_CHILDREN_V.flex_value%TYPE;
1151: l_parent_desc FND_FLEX_VALUES_VL.description%TYPE;

Line 1148: l_parent_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE;

1144: -- -------------------------------------------
1145: -- Put any additional developer variables here
1146: -- -------------------------------------------
1147: l_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE;
1148: l_parent_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE;
1149: l_child_edw_set_of_books_id number;
1150: l_parent_value FND_FLEX_VALUE_CHILDREN_V.flex_value%TYPE;
1151: l_parent_desc FND_FLEX_VALUES_VL.description%TYPE;
1152: l_set_of_books edw_local_set_of_books%ROWTYPE;

Line 1151: l_parent_desc FND_FLEX_VALUES_VL.description%TYPE;

1147: l_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE;
1148: l_parent_value_set_id FND_FLEX_VALUES_VL.FLEX_VALUE_SET_ID%TYPE;
1149: l_child_edw_set_of_books_id number;
1150: l_parent_value FND_FLEX_VALUE_CHILDREN_V.flex_value%TYPE;
1151: l_parent_desc FND_FLEX_VALUES_VL.description%TYPE;
1152: l_set_of_books edw_local_set_of_books%ROWTYPE;
1153: l_parent_set_of_books edw_local_set_of_books%ROWTYPE;
1154: l_edw_equi_sob edw_local_set_of_books%ROWTYPE;
1155: l_consolidation_id edw_local_cons_set_of_books.consolidation_id%TYPE;

Line 1183: parent_flex_value FND_FLEX_VALUES_VL.flex_value%TYPE,

1179: cur_edw_equi_sob t_edw_equi_sob;
1180:
1181:
1182: TYPE t_fnd_flex_value_pair_rec IS RECORD(
1183: parent_flex_value FND_FLEX_VALUES_VL.flex_value%TYPE,
1184: parent_desc FND_FLEX_VALUES_VL.description%TYPE,
1185: child_flex_value FND_FLEX_VALUES_VL.flex_value%TYPE,
1186: child_desc FND_FLEX_VALUES_VL.description%TYPE
1187: );

Line 1184: parent_desc FND_FLEX_VALUES_VL.description%TYPE,

1180:
1181:
1182: TYPE t_fnd_flex_value_pair_rec IS RECORD(
1183: parent_flex_value FND_FLEX_VALUES_VL.flex_value%TYPE,
1184: parent_desc FND_FLEX_VALUES_VL.description%TYPE,
1185: child_flex_value FND_FLEX_VALUES_VL.flex_value%TYPE,
1186: child_desc FND_FLEX_VALUES_VL.description%TYPE
1187: );
1188:

Line 1185: child_flex_value FND_FLEX_VALUES_VL.flex_value%TYPE,

1181:
1182: TYPE t_fnd_flex_value_pair_rec IS RECORD(
1183: parent_flex_value FND_FLEX_VALUES_VL.flex_value%TYPE,
1184: parent_desc FND_FLEX_VALUES_VL.description%TYPE,
1185: child_flex_value FND_FLEX_VALUES_VL.flex_value%TYPE,
1186: child_desc FND_FLEX_VALUES_VL.description%TYPE
1187: );
1188:
1189: l_fnd_flex_value_pair t_fnd_flex_value_pair_rec;

Line 1186: child_desc FND_FLEX_VALUES_VL.description%TYPE

1182: TYPE t_fnd_flex_value_pair_rec IS RECORD(
1183: parent_flex_value FND_FLEX_VALUES_VL.flex_value%TYPE,
1184: parent_desc FND_FLEX_VALUES_VL.description%TYPE,
1185: child_flex_value FND_FLEX_VALUES_VL.flex_value%TYPE,
1186: child_desc FND_FLEX_VALUES_VL.description%TYPE
1187: );
1188:
1189: l_fnd_flex_value_pair t_fnd_flex_value_pair_rec;
1190:

Line 1195: value FND_FLEX_VALUES_VL.flex_value%TYPE,

1191: CUR_FND_FLEX_VALUE_PAIR curType;
1192: cur_desc curType;
1193:
1194: TYPE t_flex_value_desc_rec IS RECORD(
1195: value FND_FLEX_VALUES_VL.flex_value%TYPE,
1196: description FND_FLEX_VALUES_VL.description%TYPE,
1197: parent_flag varchar2(1));
1198: l_flex_value_desc t_flex_value_desc_rec;
1199:

Line 1196: description FND_FLEX_VALUES_VL.description%TYPE,

1192: cur_desc curType;
1193:
1194: TYPE t_flex_value_desc_rec IS RECORD(
1195: value FND_FLEX_VALUES_VL.flex_value%TYPE,
1196: description FND_FLEX_VALUES_VL.description%TYPE,
1197: parent_flag varchar2(1));
1198: l_flex_value_desc t_flex_value_desc_rec;
1199:
1200: TYPE t_flex_value_orp_rec IS RECORD(

Line 1201: value FND_FLEX_VALUES_VL.flex_value%TYPE,

1197: parent_flag varchar2(1));
1198: l_flex_value_desc t_flex_value_desc_rec;
1199:
1200: TYPE t_flex_value_orp_rec IS RECORD(
1201: value FND_FLEX_VALUES_VL.flex_value%TYPE,
1202: description FND_FLEX_VALUES_VL.description%TYPE);
1203:
1204: l_flex_value_orp t_flex_value_orp_rec;
1205:

Line 1202: description FND_FLEX_VALUES_VL.description%TYPE);

1198: l_flex_value_desc t_flex_value_desc_rec;
1199:
1200: TYPE t_flex_value_orp_rec IS RECORD(
1201: value FND_FLEX_VALUES_VL.flex_value%TYPE,
1202: description FND_FLEX_VALUES_VL.description%TYPE);
1203:
1204: l_flex_value_orp t_flex_value_orp_rec;
1205:
1206: cur_flex_value_orp curType;