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_ATTRIBUTES_B

Line 23: FEM_DIM_ATTRIBUTES_B to

19: Fixed GET_ATTR_VERSION so that version_id
20: select returns only versions for that
21: attribute and dimension label combo
22: Rob Flippo 29-Dec-2003 Fixed read_only_flag select from
23: FEM_DIM_ATTRIBUTES_B to
24: assignment_is_read_only;
25: Also fixed case where new member has
26: TL row but with status <>'LOAD' - now
27: such members get status update

Line 188: USER_ASSIGN_ALLOWED_FLAG in FEM_DIM_ATTRIBUTES_B.

184: caused by a dimension group other than the one
185: that is being loaded.
186: Rob Flippo 15-MAR-05 Bug#4226011
187: - new entity attributes require new col
188: USER_ASSIGN_ALLOWED_FLAG in FEM_DIM_ATTRIBUTES_B.
189: Modify all attribute queries to exclude attributes
190: where user_assign_allowed_flag = 'N'; Also add
191: update in Pre_Valid_attr to mark rows where the
192: attribute_varchar_label is

Line 1057: FROM fem_dim_attributes_b

1053: v_obj_def_display_name VARCHAR2(150); -- translatable name for the load operation
1054:
1055: CURSOR c_attr_vers (p_dimension_id NUMBER) IS
1056: SELECT attribute_id, attribute_varchar_label
1057: FROM fem_dim_attributes_b
1058: WHERE dimension_id = p_dimension_id;
1059:
1060: BEGIN
1061:

Line 3299: ,fem_dim_attributes_b DA

3295: BEGIN
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)

Line 3402: FROM fem_dim_attributes_b

3398:
3399: -- Count the number of required attribute rows
3400: SELECT count(*)
3401: INTO v_req_attribute_count
3402: FROM fem_dim_attributes_b
3403: WHERE dimension_id = p_dimension_id
3404: AND attribute_required_flag = 'Y'
3405: AND nvl(user_assign_allowed_flag,'Y') NOT IN ('N');
3406:

Line 3786: ' fem_dim_attributes_b AE,'||

3782: x_overlap_sql_stmt :=
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'||

Line 3789: ' fem_dim_attributes_b AP,'||

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'||
3792: ' and C.cal_period_id = CP.cal_period_id'||
3793: ' and C.enabled_flag = ''Y'''||

Line 3837: ' fem_dim_attributes_b AE,'||

3833: x_overlap_sql_stmt :=
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'||

Line 3840: ' fem_dim_attributes_b AP,'||

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'||
3843: ' and C.cal_period_id = CP.cal_period_id'||
3844: ' and C.enabled_flag = ''Y'''||

Line 3888: ' fem_dim_attributes_b AP,'||

3884: 'select count(*)'||
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'''||

Line 6641: ' from fem_cal_periods_attr A1, fem_dim_attributes_b DA1'||

6637: -- we exlude situations where the start_date is identical for
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'||

Line 6643: ',fem_cal_periods_attr A2, fem_dim_attributes_b DA2'||

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'||
6647: ' and DA1.attribute_varchar_label = ''ADJ_PERIOD_FLAG'''||

Line 6668: ' from fem_cal_periods_attr A1, fem_dim_attributes_b DA1'||

6664:
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)||''''||

Line 6670: ',fem_cal_periods_attr A2, fem_dim_attributes_b DA2'||

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'||
6674: ' and DA1.attribute_varchar_label = ''ADJ_PERIOD_FLAG'''||

Line 6714: ' fem_dim_attributes_b AE,'||

6710: 'select count(*)'||
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'||

Line 6717: ' fem_dim_attributes_b AP,'||

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'||
6720: ' and to_char(C.cal_period_id) <> :b_mbr_dc'||
6721: ' and C.cal_period_id = CP.cal_period_id'||

Line 6759: ' fem_dim_attributes_b AE,'||

6755: 'select count(*)'||
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'||

Line 6762: ' fem_dim_attributes_b AP,'||

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'||
6765: ' and to_char(C.cal_period_id) <>'''||ta_member_dc(j)||''''||
6766: ' and C.cal_period_id = CP.cal_period_id'||

Line 6833: ',fem_dim_attributes_b AP'||

6829: ' from fem_cal_periods_attr CS'||
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'||

Line 9046: FROM fem_dim_attributes_b

9042:
9043: -- identify the attribute_id and default version for the START_DATE attribute
9044: SELECT attribute_id
9045: INTO v_attribute_id
9046: FROM fem_dim_attributes_b
9047: WHERE attribute_varchar_label = 'CAL_PERIOD_START_DATE';
9048:
9049: SELECT version_id
9050: INTO v_version_id

Line 9676: ' FROM fem_dim_attributes_b A1'||

9672:
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'||

Line 9727: ' FROM fem_dim_attributes_b A1'||

9723:
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'||

Line 9771: ' FROM fem_dim_attributes_b A1'||

9767:
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'||

Line 9827: | FEM_DIM_ATTRIBUTES_B

Line 10027: ' FROM fem_dim_attributes_b A1'||

10023: ', T2.CALPATTR_CAL_DISPLAY_CODE'||
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'||

Line 10099: ' FROM fem_dim_attributes_b A1'||

10095: ' ,T2.CALPATTR_CAL_DISPLAY_CODE'||
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'||

Line 10182: ' FROM fem_dim_attributes_b A1'||

10178: ' ,T2.CALPATTR_CAL_DISPLAY_CODE'||
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'||

Line 10243: ' FROM fem_dim_attributes_b A1'||

10239: ' ,T2.CALPATTR_CAL_DISPLAY_CODE'||
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'||

Line 10310: ' FROM fem_dim_attributes_b A1'||

10306: ' ,T2.CALPATTR_CAL_DISPLAY_CODE'||
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'||

Line 10384: ' FROM fem_dim_attributes_b A1'||

10380: ' ,T2.CALPATTR_CAL_DISPLAY_CODE'||
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'||

Line 10452: ' FROM fem_dim_attributes_b A1'||

10448: ' ,T2.CALPATTR_CAL_DISPLAY_CODE'||
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'||

Line 10523: ' FROM fem_dim_attributes_b A1'||

10519: ' ,T2.CALPATTR_CAL_DISPLAY_CODE'||
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'||

Line 10591: ' FROM fem_dim_attributes_b A1'||

10587: ' ,T2.CALPATTR_CAL_DISPLAY_CODE'||
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'||

Line 10652: ' FROM fem_dim_attributes_b A1'||

10648: ' ,T2.CALPATTR_CAL_DISPLAY_CODE'||
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'||

Line 10755: | to all queries against the fem_dim_attributes_b table

10751: | or bad value_set continue to be processed
10752: | so that their attr records can get updated
10753: | with an invalid_member status
10754: | Rob Flippo 15-MAR-05 Bug#4226011 add user_assign_allowed_flag not in ('N')
10755: | to all queries against the fem_dim_attributes_b table
10756: +===========================================================================*/
10757:
10758: procedure build_bad_attr_select_stmt (p_dimension_varchar_label IN VARCHAR2
10759: ,p_dimension_id IN NUMBER

Line 10812: ', FEM_DIM_ATTRIBUTES_B A'||

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||
10816: ' AND B.attribute_varchar_label = A.attribute_varchar_label'||

Line 10862: ', FEM_DIM_ATTRIBUTES_B A'||

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||
10866: ' AND nvl(A.user_assign_allowed_flag,''Y'') not in (''N'')'||

Line 10905: ',FEM_DIM_ATTRIBUTES_B A'||

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'||
10909: ' AND A.dimension_id = '||p_dimension_id||

Line 11346: FROM fem_dimensions_b B1, fem_dim_attributes_b A1, fem_dimensions_b B2

11342:
11343:
11344: SELECT B2.dimension_varchar_label
11345: INTO v_attr_dimension_varchar_label
11346: FROM fem_dimensions_b B1, fem_dim_attributes_b A1, fem_dimensions_b B2
11347: WHERE B1.dimension_id = A1.dimension_id
11348: AND A1.attribute_varchar_label = p_attribute_varchar_label
11349: AND B1.dimension_varchar_label = p_dimension_varchar_label
11350: AND B2.dimension_id = A1.attribute_dimension_id;

Line 11697: ' ,fem_dim_attributes_b D'||

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'''||
11701: ' AND D.attribute_varchar_label = B.attribute_varchar_label)'||

Line 11702: ' AND EXISTS (SELECT 0 FROM fem_dim_attributes_b A'||

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'''||
11701: ' AND D.attribute_varchar_label = B.attribute_varchar_label)'||
11702: ' AND EXISTS (SELECT 0 FROM fem_dim_attributes_b A'||
11703: ' WHERE A.attribute_varchar_label = B.attribute_varchar_label'||
11704: ' AND nvl(A.user_assign_allowed_flag,''Y'') not in (''N''))'||
11705: ' AND {{data_slice}} ';
11706:

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

Line 12240: ' FROM fem_dim_attributes_b'||

12236: v_tl_where_cond := null;
12237: IF p_operation_mode = 'NEW_MEMBERS' THEN
12238: v_attr_where_cond := ' AND attribute_varchar_label IN '||
12239: ' (SELECT attribute_varchar_label'||
12240: ' FROM fem_dim_attributes_b'||
12241: ' WHERE dimension_id=1'||
12242: ' AND attribute_required_flag = ''Y'')';
12243: ELSE
12244: v_attr_where_cond := ' AND attribute_varchar_label IN '||

Line 12246: ' FROM fem_dim_attributes_b A, fem_calp_attr_interim_t I'||

12242: ' AND attribute_required_flag = ''Y'')';
12243: ELSE
12244: v_attr_where_cond := ' AND attribute_varchar_label IN '||
12245: ' (SELECT attribute_varchar_label'||
12246: ' FROM fem_dim_attributes_b A, fem_calp_attr_interim_t I'||
12247: ' WHERE A.dimension_id=1'||
12248: ' AND A.attribute_id = I.attribute_id'||
12249: ' AND I.cal_period_id = :cal_period_id'||
12250: ' AND overlap_flag = ''N'')';

Line 12393: ' attribute_varchar_label FROM fem_dim_attributes_b A'||

12389:
12390: x_update_status_stmt := 'UPDATE '||p_source_attr_table||' B'||
12391: ' SET status = ''INVALID_ATTRIBUTE_LABEL'' '||
12392: ' WHERE attribute_varchar_label NOT IN (SELECT '||
12393: ' attribute_varchar_label FROM fem_dim_attributes_b A'||
12394: ' ,fem_dimensions_b D '||
12395: ' WHERE D.dimension_varchar_label = '''||p_dimension_varchar_label||''''||
12396: ' AND D.dimension_id = A.dimension_id)'||
12397: ' AND B.status '||p_exec_mode_clause||

Line 12456: ' attribute_varchar_label FROM fem_dim_attributes_b A'||

12452:
12453: x_update_status_stmt := 'UPDATE '||p_source_attr_table||' B'||
12454: ' SET status = ''ATTR_LABEL_NOT_USER_ASSIGN'' '||
12455: ' WHERE attribute_varchar_label IN (SELECT '||
12456: ' attribute_varchar_label FROM fem_dim_attributes_b A'||
12457: ' ,fem_dimensions_b D '||
12458: ' WHERE D.dimension_varchar_label = '''||p_dimension_varchar_label||''''||
12459: ' AND nvl(A.user_assign_allowed_flag,''Y'') = ''N'''||
12460: ' AND D.dimension_id = A.dimension_id)'||

Line 13198: ',fem_dim_attributes_b A'||

13194: ', I.calendar_display_code'||
13195: ', I.dimension_group_display_code'||
13196: ' FROM fem_calp_attr_interim_t AI'||
13197: ',fem_calp_interim_t I'||
13198: ',fem_dim_attributes_b A'||
13199: ' WHERE AI.cal_period_id = I.cal_period_id'||
13200: ' AND AI.attribute_id = A.attribute_id'||
13201: ' AND A.attribute_varchar_label = ''CAL_PERIOD_START_DATE'''||
13202: ' AND I.adjustment_period_flag = ''N''';

Line 15395: fem_dim_attributes_b attr,

15391: BEGIN
15392: SELECT prod.dim_attribute_varchar_member AS uom_code
15393: INTO t_uom_code(j)
15394: FROM fem_products_attr prod,
15395: fem_dim_attributes_b attr,
15396: fem_dim_attr_versions_vl ver
15397: WHERE prod.product_id = t_product_id(j)
15398: AND prod.attribute_id = attr.attribute_id
15399: AND prod.version_id = ver.version_id