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_DIM_ATTRIBUTES_B

Line 347: from fem_datasets_attr fdat, fem_dim_attributes_b fatt

343: -- dimension IDs for the given dataset
344: begin
345: select varchar_assign_value
346: into l_spec_dim_list
347: from fem_datasets_attr fdat, fem_dim_attributes_b fatt
348: where fdat.attribute_id = fatt.attribute_id
349: AND fatt.attribute_varchar_label = 'ZPB_DIMENSION_LIST'
350: AND fdat.dataset_code = l_dataset_id;
351:

Line 573: from FEM_DIM_ATTRIBUTES_B

569: from ZPB_BUSAREA_ATTRIBUTES A
570: where A.VERSION_ID = p_version_id
571: and A.ATTRIBUTE_ID not in
572: (select ATTRIBUTE_ID
573: from FEM_DIM_ATTRIBUTES_B
574: where PERSONAL_FLAG = 'N');
575:
576: cursor c_ledgers is
577: select A.LEDGER_ID

Line 784: l_curr_attr_id FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_ID%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;
788: l_value_set_id ZPB_BUSAREA_HIER_MEMBERS.VALUE_SET_ID%type;

Line 785: l_org_dim_id FEM_DIM_ATTRIBUTES_B.DIMENSION_ID%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;
788: l_value_set_id ZPB_BUSAREA_HIER_MEMBERS.VALUE_SET_ID%type;
789: l_logical_dim_id ZPB_BUSAREA_HIER_MEMBERS.LOGICAL_DIM_ID%type;

Line 821: FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_VALUE_COLUMN_NAME%type;

817: l_cursor epb_cur_type;
818: l_cursor2 epb_cur_type;
819:
820: l_attr_monetary_col
821: FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_VALUE_COLUMN_NAME%type;
822: l_attr_ex_acc_col
823: FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_VALUE_COLUMN_NAME%type;
824:
825: l_ext_acct_type VARCHAR2(30);

Line 823: FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_VALUE_COLUMN_NAME%type;

819:
820: l_attr_monetary_col
821: FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_VALUE_COLUMN_NAME%type;
822: l_attr_ex_acc_col
823: FEM_DIM_ATTRIBUTES_B.ATTRIBUTE_VALUE_COLUMN_NAME%type;
824:
825: l_ext_acct_type VARCHAR2(30);
826: l_monetary_stat VARCHAR2(30);
827: l_token VARCHAR2(4000) := null;

Line 1044: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,

1040: if (l_fdr_id = -99) then
1041: select count(distinct (C.DIM_ATTRIBUTE_NUMERIC_MEMBER))
1042: into l_count
1043: from ZPB_BUSAREA_LEDGERS B,
1044: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,
1045: FEM_DIM_ATTR_VERSIONS_B E
1046: where D.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'
1047: and D.ATTRIBUTE_ID = E.ATTRIBUTE_ID
1048: and E.DEFAULT_VERSION_FLAG = 'Y'

Line 1058: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,

1054: else
1055: select count(distinct (C.DIM_ATTRIBUTE_NUMERIC_MEMBER))
1056: into l_count
1057: from ZPB_BUSAREA_LEDGERS B,
1058: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,
1059: FEM_DIM_ATTR_VERSIONS_B E,
1060: fem_object_definition_b objdef,fem_object_catalog_b obj
1061: where D.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'
1062: and D.ATTRIBUTE_ID = E.ATTRIBUTE_ID

Line 1101: from FEM_DIM_ATTRIBUTES_B A,

1097: if (l_currency = 'Y') then
1098: begin
1099: select count(*)
1100: into l_count
1101: from FEM_DIM_ATTRIBUTES_B A,
1102: ZPB_BUSAREA_DIMENSIONS B
1103: where A.ATTRIBUTE_VARCHAR_LABEL = 'ZPB_ORG_CURRENCY'
1104: and A.DIMENSION_ID = B.DIMENSION_ID
1105: and B.VERSION_ID = p_version_id;

Line 1109: from FEM_DIM_ATTRIBUTES_B A,

1105: and B.VERSION_ID = p_version_id;
1106: if (l_count > 1) then
1107: select count(distinct B.DIMENSION_ID)
1108: into l_count
1109: from FEM_DIM_ATTRIBUTES_B A,
1110: ZPB_BUSAREA_DIMENSIONS B
1111: where A.ATTRIBUTE_VARCHAR_LABEL = 'ZPB_ORG_CURRENCY'
1112: and A.DIMENSION_ID = B.DIMENSION_ID
1113: and B.VERSION_ID = p_version_id;

Line 1121: from FEM_DIM_ATTRIBUTES_B A,

1117: else
1118: begin
1119: select A.ATTRIBUTE_ID, A.DIMENSION_ID, B.LOGICAL_DIM_ID
1120: into l_curr_attr_id, l_org_dim_id, l_org_logical_dim_id
1121: from FEM_DIM_ATTRIBUTES_B A,
1122: ZPB_BUSAREA_DIMENSIONS B,
1123: ZPB_BUSAREA_ATTRIBUTES C
1124: where ATTRIBUTE_VARCHAR_LABEL = 'ZPB_ORG_CURRENCY'
1125: and A.DIMENSION_ID = B.DIMENSION_ID

Line 1138: from FEM_DIM_ATTRIBUTES_B A,

1134: else
1135: begin
1136: select A.ATTRIBUTE_ID, A.DIMENSION_ID, B.LOGICAL_DIM_ID
1137: into l_curr_attr_id, l_org_dim_id, l_org_logical_dim_id
1138: from FEM_DIM_ATTRIBUTES_B A,
1139: ZPB_BUSAREA_DIMENSIONS B
1140: where ATTRIBUTE_VARCHAR_LABEL = 'ZPB_ORG_CURRENCY'
1141: and A.DIMENSION_ID = B.DIMENSION_ID
1142: and B.VERSION_ID = p_version_id;

Line 1171: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,

1167:
1168: select distinct (C.DIM_ATTRIBUTE_NUMERIC_MEMBER)
1169: into l_vs_combo_id
1170: from ZPB_BUSAREA_LEDGERS B,
1171: FEM_LEDGERS_ATTR C, FEM_DIM_ATTRIBUTES_B D,
1172: FEM_DIM_ATTR_VERSIONS_B E
1173: where D.ATTRIBUTE_VARCHAR_LABEL = 'GLOBAL_VS_COMBO'
1174: and D.ATTRIBUTE_ID = E.ATTRIBUTE_ID
1175: and E.DEFAULT_VERSION_FLAG = 'Y'

Line 1188: FEM_DIM_ATTRIBUTES_B B

1184: --
1185: select count(*)
1186: into l_count
1187: from ZPB_BUSAREA_DIMENSIONS A,
1188: FEM_DIM_ATTRIBUTES_B B
1189: where A.DIMENSION_ID = B.DIMENSION_ID
1190: and B.ATTRIBUTE_VARCHAR_LABEL = 'EXTENDED_ACCOUNT_TYPE'
1191: and A.EPB_LINE_DIMENSION = 'Y'
1192: and A.VERSION_ID = p_version_id;

Line 1639: ' from FEM_DIM_ATTRIBUTES_B A,' ||

1635: ' AND D.GROUP_SEQUENCE_ENFORCED_CODE <> ''NO_GROUPS''';
1636: end if;
1637: l_command := l_command ||
1638: ' MINUS select B.'||l_col||
1639: ' from FEM_DIM_ATTRIBUTES_B A,' ||
1640: ' '||l_dim_table||' B,' ||
1641: ' '||l_attr_table||' C,' ||
1642: ' FEM_DIM_ATTR_GRPS D,' ||
1643: ' FEM_DIM_ATTR_VERSIONS_B E,';

Line 1742: ' from FEM_DIM_ATTRIBUTES_B A,' ||

1738: ' AND D.GROUP_SEQUENCE_ENFORCED_CODE = ''NO_GROUPS''';
1739: end if;
1740: l_command := l_command ||
1741: ' MINUS select B.'||l_col||
1742: ' from FEM_DIM_ATTRIBUTES_B A,' ||
1743: ' '||l_dim_table||' B,' ||
1744: ' '||l_attr_table||' C,' ||
1745: ' FEM_DIM_ATTR_VERSIONS_B E,';
1746: if (l_no_hierarchies = 'Y') then