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.ZPB_BUSAREA_VAL dependencies on FEM_XDIM_DIMENSIONS

Line 367: from fem_tab_column_prop fem_tab, fem_xdim_dimensions fem_xdims, fem_dimensions_b fem_dims

363: -- the currency dimension,
364: -- and any other dimensions in your list already
365: l_command :=
366: 'select distinct(fem_xdims.dimension_id)
367: from fem_tab_column_prop fem_tab, fem_xdim_dimensions fem_xdims, fem_dimensions_b fem_dims
368: where fem_xdims.member_col = fem_tab.column_name
369: AND (fem_tab.table_name = '''||each.TABLE_NAME||''')
370: AND (fem_tab.column_property_code) = ''PROCESSING_KEY''
371: AND fem_dims.DIMENSION_ID = fem_xdims.DIMENSION_ID

Line 505: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;

501: is
502: l_proc_name CONSTANT VARCHAR2(33) := G_PKG_NAME||'.val_against_epf';
503:
504:
505: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
506: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
507: l_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
508: l_vset_required FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
509:

Line 506: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;

502: l_proc_name CONSTANT VARCHAR2(33) := G_PKG_NAME||'.val_against_epf';
503:
504:
505: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
506: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
507: l_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
508: l_vset_required FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
509:
510: l_hierarchy ZPB_BUSAREA_HIER_MEMBERS.HIERARCHY_ID%type;

Line 507: l_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;

503:
504:
505: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
506: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
507: l_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
508: l_vset_required FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
509:
510: l_hierarchy ZPB_BUSAREA_HIER_MEMBERS.HIERARCHY_ID%type;
511: l_member_id ZPB_BUSAREA_HIER_MEMBERS.MEMBER_ID%type;

Line 508: l_vset_required FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

504:
505: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
506: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
507: l_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
508: l_vset_required FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
509:
510: l_hierarchy ZPB_BUSAREA_HIER_MEMBERS.HIERARCHY_ID%type;
511: l_member_id ZPB_BUSAREA_HIER_MEMBERS.MEMBER_ID%type;
512: l_value_set_id ZPB_BUSAREA_HIER_MEMBERS.VALUE_SET_ID%type;

Line 597: from ZPB_BUSAREA_DIMENSIONS A, FEM_XDIM_DIMENSIONS B

593:
594: cursor c_dimensions is
595: select A.DIMENSION_ID, B.HIER_EDITOR_MANAGED_FLAG,
596: A.LOGICAL_DIM_ID
597: from ZPB_BUSAREA_DIMENSIONS A, FEM_XDIM_DIMENSIONS B
598: where A.VERSION_ID = p_version_id
599: and A.DIMENSION_ID = B.DIMENSION_ID;
600:
601: begin

Line 696: from FEM_XDIM_DIMENSIONS A,

692: A.HIERARCHY_TABLE_NAME,
693: A.MEMBER_COL,
694: A.VALUE_SET_REQUIRED_FLAG
695: into l_dim_table, l_hier_table, l_col, l_vset_required
696: from FEM_XDIM_DIMENSIONS A,
697: ZPB_BUSAREA_DIMENSIONS B
698: where B.DIMENSION_ID = each.DIMENSION_ID
699: and B.VERSION_ID = p_version_id
700: and B.LOGICAL_DIM_ID = each.LOGICAL_DIM_ID

Line 778: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;

774: PROCEDURE VAL_DEFINITION (p_version_id IN NUMBER)
775: is
776: l_proc_name CONSTANT VARCHAR2(32) := G_PKG_NAME||'.val_definition';
777:
778: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
779: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
780: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
781: l_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
782: l_vset_required FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

Line 779: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;

775: is
776: l_proc_name CONSTANT VARCHAR2(32) := G_PKG_NAME||'.val_definition';
777:
778: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
779: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
780: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
781: l_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
782: l_vset_required FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
783: l_dim_type FEM_XDIM_DIMENSIONS.DIMENSION_TYPE_CODE%type;

Line 780: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;

776: l_proc_name CONSTANT VARCHAR2(32) := G_PKG_NAME||'.val_definition';
777:
778: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
779: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
780: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
781: l_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
782: l_vset_required FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
783: l_dim_type FEM_XDIM_DIMENSIONS.DIMENSION_TYPE_CODE%type;
784: l_curr_attr_id FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_ID%type;

Line 781: l_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;

777:
778: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
779: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
780: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
781: l_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
782: l_vset_required FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
783: l_dim_type FEM_XDIM_DIMENSIONS.DIMENSION_TYPE_CODE%type;
784: l_curr_attr_id FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_ID%type;
785: l_org_dim_id FEM_DIM_ATTRIBUTES_B.DIMENSION_ID%type;

Line 782: l_vset_required FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;

778: l_dim_table FEM_XDIM_DIMENSIONS.MEMBER_B_TABLE_NAME%type;
779: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
780: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
781: l_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
782: l_vset_required FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
783: l_dim_type FEM_XDIM_DIMENSIONS.DIMENSION_TYPE_CODE%type;
784: l_curr_attr_id FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_ID%type;
785: l_org_dim_id FEM_DIM_ATTRIBUTES_B.DIMENSION_ID%type;
786:

Line 783: l_dim_type FEM_XDIM_DIMENSIONS.DIMENSION_TYPE_CODE%type;

779: l_hier_table FEM_XDIM_DIMENSIONS.HIERARCHY_TABLE_NAME%type;
780: l_attr_table FEM_XDIM_DIMENSIONS.ATTRIBUTE_TABLE_NAME%type;
781: l_col FEM_XDIM_DIMENSIONS.MEMBER_COL%type;
782: l_vset_required FEM_XDIM_DIMENSIONS.VALUE_SET_REQUIRED_FLAG%type;
783: l_dim_type FEM_XDIM_DIMENSIONS.DIMENSION_TYPE_CODE%type;
784: l_curr_attr_id FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_ID%type;
785: l_org_dim_id FEM_DIM_ATTRIBUTES_B.DIMENSION_ID%type;
786:
787: l_hierarchy ZPB_BUSAREA_HIER_MEMBERS.HIERARCHY_ID%type;

Line 847: FEM_XDIM_DIMENSIONS X

843: X.MEMBER_COL
844: from ZPB_BUSAREA_DIMENSIONS A,
845: FEM_FUNC_DIM_SETS_VL FDR,
846: FEM_DIMENSIONS_VL B,
847: FEM_XDIM_DIMENSIONS X
848: where A.VERSION_ID = p_version_id
849: and FDR.FUNC_DIM_SET_ID (+) = A.FUNC_DIM_SET_ID
850: and A.DIMENSION_ID = B.DIMENSION_ID
851: AND X.DIMENSION_ID = A.DIMENSION_ID;

Line 980: from ZPB_BUSAREA_DIMENSIONS A, FEM_XDIM_DIMENSIONS B

976: -- Validate # of ledgers, dimensions, etc
977: -------------------------------------------------------------------------
978: select count(*)
979: into l_count
980: from ZPB_BUSAREA_DIMENSIONS A, FEM_XDIM_DIMENSIONS B
981: where A.VERSION_ID = p_version_id
982: and A.DIMENSION_ID = B.DIMENSION_ID
983: and B.DIMENSION_TYPE_CODE = 'TIME';
984: if (l_count = 0) then

Line 1003: FEM_XDIM_DIMENSIONS B

999: if (l_currency = 'Y') then
1000: select count(*)
1001: into l_count
1002: from ZPB_BUSAREA_DIMENSIONS A,
1003: FEM_XDIM_DIMENSIONS B
1004: where A.VERSION_ID = p_version_id
1005: and A.DIMENSION_ID = B.DIMENSION_ID
1006: and B.MEMBER_B_TABLE_NAME = 'FEM_CURRENCIES_VL';
1007: if (l_count = 0) then

Line 1234: from FEM_XDIM_DIMENSIONS A,

1230: A.VALUE_SET_REQUIRED_FLAG,
1231: A.DIMENSION_TYPE_CODE
1232: into l_dim_table, l_hier_table, l_attr_table,
1233: l_col, l_vset_required, l_dim_type
1234: from FEM_XDIM_DIMENSIONS A,
1235: ZPB_BUSAREA_DIMENSIONS B
1236: where B.DIMENSION_ID = each.DIMENSION_ID
1237: AND B.LOGICAL_DIM_ID = each.LOGICAL_DIM_ID
1238: AND B.VERSION_ID = p_version_id