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.FII_FIN_CAT_MAINTAIN_PKG dependencies on FII_DIM_NORM_HIERARCHY

Line 348: from FII_DIM_NORM_HIERARCHY

344:
345: -- Bug 4152798. Removed literal
346: Cursor all_local_value_sets IS
347: select distinct child_flex_value_set_id
348: from FII_DIM_NORM_HIERARCHY
349: where parent_flex_value_set_id = G_MASTER_VALUE_SET_ID
350: and parent_flex_value_set_id <> child_flex_value_set_id
351: and child_flex_value_set_id IN
352: (select map.flex_value_set_id1

Line 369: --First, copy table FII_DIM_NORM_HIERARCHY

365: IF (FIIDIM_Debug) THEN
366: FII_MESSAGE.Func_Ent ('FII_FIN_CAT_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
367: END IF;
368:
369: --First, copy table FII_DIM_NORM_HIERARCHY
370: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';
371:
372: Insert into FII_DIM_NORM_HIER_GT (
373: PARENT_FLEX_VALUE_SET_ID,

Line 370: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';

366: FII_MESSAGE.Func_Ent ('FII_FIN_CAT_MAINTAIN_PKG.Get_NORM_HIERARCHY_TMP');
367: END IF;
368:
369: --First, copy table FII_DIM_NORM_HIERARCHY
370: g_phase := 'Copy FII_DIM_NORM_HIERARCHY for parent-child valuesets relation';
371:
372: Insert into FII_DIM_NORM_HIER_GT (
373: PARENT_FLEX_VALUE_SET_ID,
374: PARENT_FLEX_VALUE,

Line 386: From FII_DIM_NORM_HIERARCHY

382: RANGE_ATTRIBUTE,
383: CHILD_FLEX_VALUE_SET_ID,
384: CHILD_FLEX_VALUE_LOW,
385: CHILD_FLEX_VALUE_HIGH
386: From FII_DIM_NORM_HIERARCHY
387: Where PARENT_FLEX_VALUE_SET_ID = G_MASTER_VALUE_SET_ID
388: And PARENT_FLEX_VALUE_SET_ID <> CHILD_FLEX_VALUE_SET_ID
389: And CHILD_FLEX_VALUE_SET_ID IN
390: (select map.flex_value_set_id1