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.FEM_DIM_MEMBER_LOADER_PKG dependencies on FEM_DIM_ATTR_VERSIONS_B

Line 1144: FROM fem_dim_attr_versions_b

1140: -- for each attribute of the dimension being processed
1141: FOR attr IN c_attr_vers (x_dimension_id) LOOP
1142: SELECT count(*)
1143: INTO v_default_version_count
1144: FROM fem_dim_attr_versions_b
1145: WHERE attribute_id = attr.attribute_id
1146: AND default_version_flag='Y';
1147:
1148: IF (v_default_version_count > 1) THEN

Line 3300: ,fem_dim_attr_versions_B V

3296: SELECT A.number_assign_value
3297: INTO t_periods_in_year(i)
3298: FROM fem_time_grp_types_attr A
3299: ,fem_dim_attributes_b DA
3300: ,fem_dim_attr_versions_B V
3301: ,fem_dimension_grps_b DG
3302: WHERE A.time_group_type_code = DG.time_group_type_code
3303: AND DG.dimension_group_id = t_dimension_group_id(i)
3304: AND A.attribute_id = DA.attribute_id

Line 3787: ' fem_dim_attr_Versions_b VE,'||

3783: 'select count(*)'||
3784: ' from fem_cal_periods_attr CS, fem_cal_periods_attr CE,'||
3785: ' fem_cal_periods_b C,'||
3786: ' fem_dim_attributes_b AE,'||
3787: ' fem_dim_attr_Versions_b VE,'||
3788: ' fem_cal_periods_attr CP,'||
3789: ' fem_dim_attributes_b AP,'||
3790: ' fem_dim_attr_versions_b VP'||
3791: ' where CS.cal_period_id = C.cal_period_id'||

Line 3790: ' fem_dim_attr_versions_b VP'||

3786: ' fem_dim_attributes_b AE,'||
3787: ' fem_dim_attr_Versions_b VE,'||
3788: ' fem_cal_periods_attr CP,'||
3789: ' fem_dim_attributes_b AP,'||
3790: ' fem_dim_attr_versions_b VP'||
3791: ' where CS.cal_period_id = C.cal_period_id'||
3792: ' and C.cal_period_id = CP.cal_period_id'||
3793: ' and C.enabled_flag = ''Y'''||
3794: ' and CP.attribute_id = AP.attribute_id'||

Line 3838: ' fem_dim_attr_Versions_b VE,'||

3834: 'select count(*)'||
3835: ' from fem_cal_periods_attr CS, fem_cal_periods_attr CE,'||
3836: ' fem_cal_periods_b C,'||
3837: ' fem_dim_attributes_b AE,'||
3838: ' fem_dim_attr_Versions_b VE,'||
3839: ' fem_cal_periods_attr CP,'||
3840: ' fem_dim_attributes_b AP,'||
3841: ' fem_dim_attr_versions_b VP'||
3842: ' where CS.cal_period_id = C.cal_period_id'||

Line 3841: ' fem_dim_attr_versions_b VP'||

3837: ' fem_dim_attributes_b AE,'||
3838: ' fem_dim_attr_Versions_b VE,'||
3839: ' fem_cal_periods_attr CP,'||
3840: ' fem_dim_attributes_b AP,'||
3841: ' fem_dim_attr_versions_b VP'||
3842: ' where CS.cal_period_id = C.cal_period_id'||
3843: ' and C.cal_period_id = CP.cal_period_id'||
3844: ' and C.enabled_flag = ''Y'''||
3845: ' and CP.attribute_id = AP.attribute_id'||

Line 3889: ' fem_dim_attr_versions_b VP'||

3885: ' from fem_cal_periods_attr CS,'||
3886: ' fem_cal_periods_b C,'||
3887: ' fem_cal_periods_attr CP,'||
3888: ' fem_dim_attributes_b AP,'||
3889: ' fem_dim_attr_versions_b VP'||
3890: ' where CS.cal_period_id = C.cal_period_id'||
3891: ' and C.cal_period_id = CP.cal_period_id'||
3892: ' and C.enabled_flag = ''Y'''||
3893: ' and CP.attribute_id = AP.attribute_id'||

Line 6642: ',fem_dim_attr_versions_b V1'||

6638: -- the same cal_period_id because the load is not changing
6639: -- anything
6640: x_adj_period_stmt := 'select count(*)'||
6641: ' from fem_cal_periods_attr A1, fem_dim_attributes_b DA1'||
6642: ',fem_dim_attr_versions_b V1'||
6643: ',fem_cal_periods_attr A2, fem_dim_attributes_b DA2'||
6644: ',fem_dim_attr_Versions_b V2'||
6645: ' where to_char(A1.cal_period_id) = :b_mbr_dc'||
6646: ' and A1.attribute_id = DA1.attribute_id'||

Line 6644: ',fem_dim_attr_Versions_b V2'||

6640: x_adj_period_stmt := 'select count(*)'||
6641: ' from fem_cal_periods_attr A1, fem_dim_attributes_b DA1'||
6642: ',fem_dim_attr_versions_b V1'||
6643: ',fem_cal_periods_attr A2, fem_dim_attributes_b DA2'||
6644: ',fem_dim_attr_Versions_b V2'||
6645: ' where to_char(A1.cal_period_id) = :b_mbr_dc'||
6646: ' and A1.attribute_id = DA1.attribute_id'||
6647: ' and DA1.attribute_varchar_label = ''ADJ_PERIOD_FLAG'''||
6648: ' and DA1.dimension_id = 1'||

Line 6669: ',fem_dim_attr_versions_b V1'||

6665: /*************************************************
6666: bug#5060746 comment out to use bind variables
6667: x_adj_period_stmt := 'select count(*)'||
6668: ' from fem_cal_periods_attr A1, fem_dim_attributes_b DA1'||
6669: ',fem_dim_attr_versions_b V1'||
6670: ',fem_cal_periods_attr A2, fem_dim_attributes_b DA2'||
6671: ',fem_dim_attr_Versions_b V2'||
6672: ' where to_char(A1.cal_period_id) = '''||ta_member_dc(j)||''''||
6673: ' and A1.attribute_id = DA1.attribute_id'||

Line 6671: ',fem_dim_attr_Versions_b V2'||

6667: x_adj_period_stmt := 'select count(*)'||
6668: ' from fem_cal_periods_attr A1, fem_dim_attributes_b DA1'||
6669: ',fem_dim_attr_versions_b V1'||
6670: ',fem_cal_periods_attr A2, fem_dim_attributes_b DA2'||
6671: ',fem_dim_attr_Versions_b V2'||
6672: ' where to_char(A1.cal_period_id) = '''||ta_member_dc(j)||''''||
6673: ' and A1.attribute_id = DA1.attribute_id'||
6674: ' and DA1.attribute_varchar_label = ''ADJ_PERIOD_FLAG'''||
6675: ' and DA1.dimension_id = 1'||

Line 6715: ' fem_dim_attr_Versions_b VE,'||

6711: ' from fem_cal_periods_attr CS, fem_cal_periods_attr CE,'||
6712: ' fem_cal_periods_b C,'||
6713: ' fem_dimension_grps_b D,'||
6714: ' fem_dim_attributes_b AE,'||
6715: ' fem_dim_attr_Versions_b VE,'||
6716: ' fem_cal_periods_attr CP,'||
6717: ' fem_dim_attributes_b AP,'||
6718: ' fem_dim_attr_versions_b VP'||
6719: ' where CS.cal_period_id = C.cal_period_id'||

Line 6718: ' fem_dim_attr_versions_b VP'||

6714: ' fem_dim_attributes_b AE,'||
6715: ' fem_dim_attr_Versions_b VE,'||
6716: ' fem_cal_periods_attr CP,'||
6717: ' fem_dim_attributes_b AP,'||
6718: ' fem_dim_attr_versions_b VP'||
6719: ' where CS.cal_period_id = C.cal_period_id'||
6720: ' and to_char(C.cal_period_id) <> :b_mbr_dc'||
6721: ' and C.cal_period_id = CP.cal_period_id'||
6722: ' and C.enabled_flag = ''Y'''||

Line 6760: ' fem_dim_attr_Versions_b VE,'||

6756: ' from fem_cal_periods_attr CS, fem_cal_periods_attr CE,'||
6757: ' fem_cal_periods_b C,'||
6758: ' fem_dimension_grps_b D,'||
6759: ' fem_dim_attributes_b AE,'||
6760: ' fem_dim_attr_Versions_b VE,'||
6761: ' fem_cal_periods_attr CP,'||
6762: ' fem_dim_attributes_b AP,'||
6763: ' fem_dim_attr_versions_b VP'||
6764: ' where CS.cal_period_id = C.cal_period_id'||

Line 6763: ' fem_dim_attr_versions_b VP'||

6759: ' fem_dim_attributes_b AE,'||
6760: ' fem_dim_attr_Versions_b VE,'||
6761: ' fem_cal_periods_attr CP,'||
6762: ' fem_dim_attributes_b AP,'||
6763: ' fem_dim_attr_versions_b VP'||
6764: ' where CS.cal_period_id = C.cal_period_id'||
6765: ' and to_char(C.cal_period_id) <>'''||ta_member_dc(j)||''''||
6766: ' and C.cal_period_id = CP.cal_period_id'||
6767: ' and C.enabled_flag = ''Y'''||

Line 6834: ',fem_dim_attr_versions_b VP'||

6830: ',fem_cal_periods_b C'||
6831: ',fem_dimension_grps_b D'||
6832: ',fem_cal_periods_attr CP'||
6833: ',fem_dim_attributes_b AP'||
6834: ',fem_dim_attr_versions_b VP'||
6835: ' where CS.cal_period_id = C.cal_period_id'||
6836: ' and to_char(C.cal_period_id) <>'''||ta_member_dc(j)||''''||
6837: ' and C.cal_period_id = CP.cal_period_id'||
6838: ' and C.enabled_flag = ''Y'''||

Line 9051: FROM fem_dim_attr_versions_b

9047: WHERE attribute_varchar_label = 'CAL_PERIOD_START_DATE';
9048:
9049: SELECT version_id
9050: INTO v_version_id
9051: FROM fem_dim_attr_versions_b
9052: WHERE attribute_id = v_attribute_id
9053: AND default_version_flag = 'Y';
9054:
9055: END IF;

Line 9677: ',fem_dim_attr_versions_b V1'||

9673: x_attr_select_stmt :=
9674: 'SELECT T2.base_rowid'||
9675: ' ,''INVALID_LVL_SPEC_ATTR_LABEL'' '||
9676: ' FROM fem_dim_attributes_b A1'||
9677: ',fem_dim_attr_versions_b V1'||
9678: ',fem_dimensions_b B1'||
9679: ',(SELECT B.rowid base_rowid'||
9680: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
9681: ', B.cal_period_number CAL_PERIOD_NUMBER'||

Line 9728: ',fem_dim_attr_versions_b V1'||

9724: x_attr_select_stmt :=
9725: 'SELECT T2.base_rowid'||
9726: ' ,''INVALID_LVL_SPEC_ATTR_LABEL'' '||
9727: ' FROM fem_dim_attributes_b A1'||
9728: ',fem_dim_attr_versions_b V1'||
9729: ',fem_dimensions_b B1'||
9730: ',(SELECT B.rowid base_rowid'||
9731: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
9732: ', B.value_set_display_code'||

Line 9772: ',fem_dim_attr_versions_b V1'||

9768: x_attr_select_stmt :=
9769: 'SELECT T2.base_rowid'||
9770: ' ,''INVALID_LVL_SPEC_ATTR_LABEL'' '||
9771: ' FROM fem_dim_attributes_b A1'||
9772: ',fem_dim_attr_versions_b V1'||
9773: ',fem_dimensions_b B1'||
9774: ',(SELECT B.rowid base_rowid'||
9775: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
9776: ', B.version_display_code'||

Line 9862: | fem_dim_attr_versions_b table and restrict on min(version_id)

9858: | assigned specifically to any groups. But if the
9859: | attribute_required_flag='Y', then we don't check.
9860: |
9861: | Also - modified all of the queries to join with the
9862: | fem_dim_attr_versions_b table and restrict on min(version_id)
9863: | Previously, this was only occuring for specific_member='Y'.
9864: | This needs to occur for every attribute query since
9865: | the pre_validation_attr procedure already exists to mark
9866: | rows with invalid version_display_code.

Line 10028: ',fem_dim_attr_versions_b V1'||

10024: ', T2.CALPATTR_DIMGRP_DISPLAY_CODE'||
10025: ', T2.CALPATTR_END_DATE'||
10026: ', T2.CALPATTR_PERIOD_NUM'||
10027: ' FROM fem_dim_attributes_b A1'||
10028: ',fem_dim_attr_versions_b V1'||
10029: ',fem_dimensions_b B1'||
10030: ',(SELECT B.rowid base_rowid'||
10031: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10032: ', D.dimension_group_id'||

Line 10057: ' AND V1.version_id IN (SELECT min(version_id) FROM fem_dim_attr_versions_b V3'||

10053: ' AND T2.member_code '||v_outer_join||' = :b_member_display_code'||
10054: ' AND B1.dimension_id = A1.dimension_id'||
10055: ' AND B1.dimension_varchar_label = '''||p_dimension_varchar_label||''''||
10056: ' AND T2.version_display_code = V1.version_display_code'||
10057: ' AND V1.version_id IN (SELECT min(version_id) FROM fem_dim_attr_versions_b V3'||
10058: ' WHERE V3.default_version_flag = ''Y'''||
10059: ' AND V3.aw_snapshot_flag = ''N'''||
10060: ' AND V3.attribute_id = A1.attribute_id)'||
10061: ' AND A1.attribute_id = V1.attribute_id'||

Line 10100: ',fem_dim_attr_versions_b V1'||

10096: ' ,T2.CALPATTR_DIMGRP_DISPLAY_CODE'||
10097: ' ,T2.CALPATTR_END_DATE'||
10098: ' ,T2.CALPATTR_PERIOD_NUM'||
10099: ' FROM fem_dim_attributes_b A1'||
10100: ',fem_dim_attr_versions_b V1'||
10101: ',fem_dimensions_b B1'||
10102: ',(SELECT B.rowid base_rowid'||
10103: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10104: ', B.cal_period_number CAL_PERIOD_NUMBER'||

Line 10183: ',fem_dim_attr_versions_b V1'||

10179: ' ,T2.CALPATTR_DIMGRP_DISPLAY_CODE'||
10180: ' ,T2.CALPATTR_END_DATE'||
10181: ' ,T2.CALPATTR_PERIOD_NUM'||
10182: ' FROM fem_dim_attributes_b A1'||
10183: ',fem_dim_attr_versions_b V1'||
10184: ',fem_dimensions_b B1'||
10185: ',(SELECT B.rowid base_rowid'||
10186: ', B.attribute_varchar_label,B.'||v_member_code||' MEMBER_CODE'||
10187: ', B.value_set_display_code'||

Line 10205: ' AND V1.version_id IN (SELECT min(version_id) FROM fem_dim_attr_versions_b V3'||

10201: ' AND T2.member_code '||v_outer_join||' = :b_member_display_code'||
10202: ' AND B1.dimension_id = A1.dimension_id'||
10203: ' AND B1.dimension_varchar_label = '''||p_dimension_varchar_label||''''||
10204: ' AND T2.version_display_code = V1.version_display_code'||
10205: ' AND V1.version_id IN (SELECT min(version_id) FROM fem_dim_attr_versions_b V3'||
10206: ' WHERE V3.default_version_flag = ''Y'''||
10207: ' AND V3.aw_snapshot_flag = ''N'''||
10208: ' AND V3.attribute_id = A1.attribute_id)'||
10209: ' AND A1.attribute_id = V1.attribute_id'||

Line 10244: ',fem_dim_attr_versions_b V1'||

10240: ' ,T2.CALPATTR_DIMGRP_DISPLAY_CODE'||
10241: ' ,T2.CALPATTR_END_DATE'||
10242: ' ,T2.CALPATTR_PERIOD_NUM'||
10243: ' FROM fem_dim_attributes_b A1'||
10244: ',fem_dim_attr_versions_b V1'||
10245: ',fem_dimensions_b B1'||
10246: ',(SELECT B.rowid base_rowid'||
10247: ', B.attribute_varchar_label,B.'||v_member_code||' MEMBER_CODE'||
10248: ', B.version_display_code'||

Line 10266: ' AND V1.version_id IN (SELECT min(version_id) FROM fem_dim_attr_versions_b V3'||

10262: ' AND T2.member_code '||v_outer_join||' = :b_member_display_code'||
10263: ' AND B1.dimension_id = A1.dimension_id'||
10264: ' AND B1.dimension_varchar_label = '''||p_dimension_varchar_label||''''||
10265: ' AND T2.version_display_code = V1.version_display_code'||
10266: ' AND V1.version_id IN (SELECT min(version_id) FROM fem_dim_attr_versions_b V3'||
10267: ' WHERE V3.default_version_flag = ''Y'''||
10268: ' AND V3.aw_snapshot_flag = ''N'''||
10269: ' AND V3.attribute_id = A1.attribute_id)'||
10270: ' AND A1.attribute_id = V1.attribute_id'||

Line 10311: ',fem_dim_attr_versions_b V1'||

10307: ' ,T2.CALPATTR_DIMGRP_DISPLAY_CODE'||
10308: ' ,T2.CALPATTR_END_DATE'||
10309: ' ,T2.CALPATTR_PERIOD_NUM'||
10310: ' FROM fem_dim_attributes_b A1'||
10311: ',fem_dim_attr_versions_b V1'||
10312: ',fem_dimensions_b B1'||
10313: ',(SELECT B.rowid base_rowid'||
10314: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10315: ', B.value_set_display_code'||

Line 10385: ',fem_dim_attr_versions_b V1'||

10381: ' ,T2.CALPATTR_DIMGRP_DISPLAY_CODE'||
10382: ' ,T2.CALPATTR_END_DATE'||
10383: ' ,T2.CALPATTR_PERIOD_NUM'||
10384: ' FROM fem_dim_attributes_b A1'||
10385: ',fem_dim_attr_versions_b V1'||
10386: ',fem_dimensions_b B1'||
10387: ',(SELECT B.rowid base_rowid'||
10388: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10389: ', B.value_set_display_code'||

Line 10453: ',fem_dim_attr_versions_b V1'||

10449: ' ,T2.CALPATTR_DIMGRP_DISPLAY_CODE'||
10450: ' ,T2.CALPATTR_END_DATE'||
10451: ' ,T2.CALPATTR_PERIOD_NUM'||
10452: ' FROM fem_dim_attributes_b A1'||
10453: ',fem_dim_attr_versions_b V1'||
10454: ',fem_dimensions_b B1'||
10455: ',(SELECT B.rowid base_rowid'||
10456: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10457: ', B.version_display_code'||

Line 10524: ',fem_dim_attr_versions_b V1'||

10520: ' ,T2.CALPATTR_DIMGRP_DISPLAY_CODE'||
10521: ' ,T2.CALPATTR_END_DATE'||
10522: ' ,T2.CALPATTR_PERIOD_NUM'||
10523: ' FROM fem_dim_attributes_b A1'||
10524: ',fem_dim_attr_versions_b V1'||
10525: ',fem_dimensions_b B1'||
10526: ',(SELECT B.rowid base_rowid'||
10527: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10528: ', B.version_display_code'||

Line 10592: ',fem_dim_attr_versions_b V1'||

10588: ' ,T2.CALPATTR_DIMGRP_DISPLAY_CODE'||
10589: ' ,T2.CALPATTR_END_DATE'||
10590: ' ,T2.CALPATTR_PERIOD_NUM'||
10591: ' FROM fem_dim_attributes_b A1'||
10592: ',fem_dim_attr_versions_b V1'||
10593: ',fem_dimensions_b B1'||
10594: ',(SELECT B.rowid base_rowid'||
10595: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10596: ', B.version_display_code'||

Line 10653: ',fem_dim_attr_versions_b V1'||

10649: ' ,T2.CALPATTR_DIMGRP_DISPLAY_CODE'||
10650: ' ,T2.CALPATTR_END_DATE'||
10651: ' ,T2.CALPATTR_PERIOD_NUM'||
10652: ' FROM fem_dim_attributes_b A1'||
10653: ',fem_dim_attr_versions_b V1'||
10654: ',fem_dimensions_b B1'||
10655: ',(SELECT B.rowid base_rowid'||
10656: ', B.attribute_varchar_label,'||v_member_code||' MEMBER_CODE'||
10657: ', B.version_display_code'||

Line 10811: ', FEM_DIM_ATTR_VERSIONS_B V'||

10807: 'SELECT B.rowid'||
10808: ',''INVALID_MEMBER'''||
10809: ' FROM '||p_source_attr_table||' B'||
10810: ', FEM_CALENDARS_VL C, FEM_DIMENSION_GRPS_B D'||
10811: ', FEM_DIM_ATTR_VERSIONS_B V'||
10812: ', FEM_DIM_ATTRIBUTES_B A'||
10813: ' WHERE B.calendar_display_code = C.calendar_display_code '||
10814: ' AND B.dimension_group_display_code = D.dimension_group_display_code'||
10815: ' AND B.STATUS'||p_exec_mode_clause||

Line 10861: ', FEM_DIM_ATTR_VERSIONS_B V'||

10857: x_bad_attr_select_stmt :=
10858: 'SELECT B.rowid'||
10859: ',''INVALID_MEMBER'''||
10860: ' FROM '||p_source_attr_table||' B'||
10861: ', FEM_DIM_ATTR_VERSIONS_B V'||
10862: ', FEM_DIM_ATTRIBUTES_B A'||
10863: ' WHERE B.STATUS'||p_exec_mode_clause||
10864: ' AND B.attribute_varchar_label = A.attribute_varchar_label'||
10865: ' AND A.dimension_id = '||p_dimension_id||

Line 10904: ',FEM_DIM_ATTR_VERSIONS_B V'||

10900: x_bad_attr_select_stmt :=
10901: 'SELECT B.rowid'||
10902: ',''INVALID_MEMBER'''||
10903: ' FROM '||p_source_attr_table||' B'||
10904: ',FEM_DIM_ATTR_VERSIONS_B V'||
10905: ',FEM_DIM_ATTRIBUTES_B A'||
10906: ' WHERE B.STATUS'||p_exec_mode_clause||
10907: v_dim_label_where_cond||
10908: ' AND B.attribute_varchar_label = A.attribute_varchar_label'||

Line 11696: ' AND NOT EXISTS (SELECT 0 FROM fem_dim_attr_versions_b V'||

11692: ',''INVALID_VERSION'''||
11693: ' FROM '||p_source_attr_table||' B'||
11694: ' WHERE B.status'||p_exec_mode_clause||
11695: v_dim_label_where_cond||
11696: ' AND NOT EXISTS (SELECT 0 FROM fem_dim_attr_versions_b V'||
11697: ' ,fem_dim_attributes_b D'||
11698: ' WHERE V.version_display_code = B.version_display_code'||
11699: ' AND V.attribute_id = D.attribute_id'||
11700: ' AND V.aw_snapshot_flag = ''N'''||

Line 11763: FROM fem_dim_attr_versions_b B, fem_dim_attributes_b A, fem_dimensions_b D

11759: p_version_display_code);
11760:
11761: SELECT B.version_id
11762: INTO x_version_id
11763: FROM fem_dim_attr_versions_b B, fem_dim_attributes_b A, fem_dimensions_b D
11764: WHERE B.version_display_code = p_version_display_code
11765: AND B.attribute_id = A.attribute_id
11766: AND A.attribute_varchar_label = p_attribute_varchar_label
11767: AND D.dimension_varchar_label = p_dimension_varchar_label