HWM_ALLOCATION_SOURCES_HIST_D

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name

ALLOCATION_ID SOURCE_OUTPUT_SEQ_NUM ALLOCATION_RULE_PRIORITY ALLOCATION_TYPE RUN_SUMMATION_LEVEL TCAT_ID ALLOCATION_RULE_ID ALLOCATION_LINE_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE ALLOCATION_LINE_PRIORITY ALLOCATION_VALUE ENTERPRISE_ID ATRB_FLD_NAME_1 ATRB_VALUE_1 ATRB_FLD_ID_1 ATRB_DATA_TYPE_1 ATRB_FLD_NAME_2 ATRB_VALUE_2 ATRB_FLD_ID_2 ATRB_DATA_TYPE_2 ATRB_FLD_NAME_3 ATRB_VALUE_3 ATRB_FLD_ID_3 ATRB_DATA_TYPE_3 ATRB_FLD_NAME_4 ATRB_VALUE_4 ATRB_FLD_ID_4 ATRB_DATA_TYPE_4 ATRB_FLD_NAME_5 ATRB_VALUE_5 ATRB_FLD_ID_5 ATRB_DATA_TYPE_5 ATRB_FLD_NAME_6 ATRB_VALUE_6 ATRB_FLD_ID_6 ATRB_DATA_TYPE_6 ATRB_FLD_NAME_7 ATRB_VALUE_7 ATRB_FLD_ID_7 ATRB_DATA_TYPE_7 ATRB_FLD_NAME_8 ATRB_VALUE_8 ATRB_FLD_ID_8 ATRB_DATA_TYPE_8 ATRB_FLD_NAME_9 ATRB_VALUE_9 ATRB_FLD_ID_9 ATRB_DATA_TYPE_9 ATRB_FLD_NAME_10 ATRB_VALUE_10 ATRB_FLD_ID_10 ATRB_DATA_TYPE_10 ATRB_FLD_NAME_11 ATRB_VALUE_11 ATRB_FLD_ID_11 ATRB_DATA_TYPE_11 ATRB_FLD_NAME_12 ATRB_VALUE_12 ATRB_FLD_ID_12 ATRB_DATA_TYPE_12 ATRB_FLD_NAME_13 ATRB_VALUE_13 ATRB_FLD_ID_13 ATRB_DATA_TYPE_13 ATRB_FLD_NAME_14 ATRB_VALUE_14 ATRB_FLD_ID_14 ATRB_DATA_TYPE_14 ATRB_FLD_NAME_15 ATRB_VALUE_15 ATRB_FLD_ID_15 ATRB_DATA_TYPE_15 ATRB_FLD_NAME_16 ATRB_VALUE_16 ATRB_FLD_ID_16 ATRB_DATA_TYPE_16 ATRB_FLD_NAME_17 ATRB_VALUE_17 ATRB_FLD_ID_17 ATRB_DATA_TYPE_17 ATRB_FLD_NAME_18 ATRB_VALUE_18 ATRB_FLD_ID_18 ATRB_DATA_TYPE_18 ATRB_FLD_NAME_19 ATRB_VALUE_19 ATRB_FLD_ID_19 ATRB_DATA_TYPE_19 ATRB_FLD_NAME_20 ATRB_VALUE_20 ATRB_FLD_ID_20 ATRB_DATA_TYPE_20 ATRB_FLD_NAME_21 ATRB_VALUE_21 ATRB_FLD_ID_21 ATRB_DATA_TYPE_21 ATRB_FLD_NAME_22 ATRB_VALUE_22 ATRB_FLD_ID_22 ATRB_DATA_TYPE_22 ATRB_FLD_NAME_23 ATRB_VALUE_23 ATRB_FLD_ID_23 ATRB_DATA_TYPE_23 ATRB_FLD_NAME_24 ATRB_VALUE_24 ATRB_FLD_ID_24 ATRB_DATA_TYPE_24 ATRB_FLD_NAME_25 ATRB_VALUE_25 ATRB_FLD_ID_25 ATRB_DATA_TYPE_25 ATRB_FLD_NAME_26 ATRB_VALUE_26 ATRB_FLD_ID_26 ATRB_DATA_TYPE_26 ATRB_FLD_NAME_27 ATRB_VALUE_27 ATRB_FLD_ID_27 ATRB_DATA_TYPE_27 ATRB_FLD_NAME_28 ATRB_VALUE_28 ATRB_FLD_ID_28 ATRB_DATA_TYPE_28 ATRB_FLD_NAME_29 ATRB_VALUE_29 ATRB_FLD_ID_29 ATRB_DATA_TYPE_29 ATRB_FLD_NAME_30 ATRB_VALUE_30 ATRB_FLD_ID_30 ATRB_DATA_TYPE_30

Query

SQL_Statement

select ruleTB.ALLOCATION_ID, ('Source: '||ruleTB.ALLOCATION_RULE_PRIORITY ||' - Output: '|| lineTB.ALLOCATION_LINE_PRIORITY) SOURCE_OUTPUT_SEQ_NUM, ruleTB.ALLOCATION_RULE_PRIORITY, ruleTB.ALLOCATION_TYPE, ruleTB.RUN_SUMMATION_LEVEL, ruleTB.TCAT_ID, lineTB.ALLOCATION_RULE_ID , lineTB.ALLOCATION_LINE_ID , ruleTB.EFFECTIVE_START_DATE , ruleTB.EFFECTIVE_END_DATE , lineTB.ALLOCATION_LINE_PRIORITY , lineTB.ALLOCATION_VALUE, ruleTB.ENTERPRISE_ID, lineAttrTB.ATRB_FLD_NAME_1, lineAttrTB.ATRB_VALUE_1, lineAttrTB.ATRB_FLD_ID_1, lineAttrTB.ATRB_DATA_TYPE_1, lineAttrTB.ATRB_FLD_NAME_2, lineAttrTB.ATRB_VALUE_2, lineAttrTB.ATRB_FLD_ID_2, lineAttrTB.ATRB_DATA_TYPE_2, lineAttrTB.ATRB_FLD_NAME_3, lineAttrTB.ATRB_VALUE_3, lineAttrTB.ATRB_FLD_ID_3, lineAttrTB.ATRB_DATA_TYPE_3, lineAttrTB.ATRB_FLD_NAME_4, lineAttrTB.ATRB_VALUE_4, lineAttrTB.ATRB_FLD_ID_4, lineAttrTB.ATRB_DATA_TYPE_4, lineAttrTB.ATRB_FLD_NAME_5, lineAttrTB.ATRB_VALUE_5, lineAttrTB.ATRB_FLD_ID_5, lineAttrTB.ATRB_DATA_TYPE_5, lineAttrTB.ATRB_FLD_NAME_6, lineAttrTB.ATRB_VALUE_6, lineAttrTB.ATRB_FLD_ID_6, lineAttrTB.ATRB_DATA_TYPE_6, lineAttrTB.ATRB_FLD_NAME_7, lineAttrTB.ATRB_VALUE_7, lineAttrTB.ATRB_FLD_ID_7, lineAttrTB.ATRB_DATA_TYPE_7, lineAttrTB.ATRB_FLD_NAME_8, lineAttrTB.ATRB_VALUE_8, lineAttrTB.ATRB_FLD_ID_8, lineAttrTB.ATRB_DATA_TYPE_8, lineAttrTB.ATRB_FLD_NAME_9, lineAttrTB.ATRB_VALUE_9, lineAttrTB.ATRB_FLD_ID_9, lineAttrTB.ATRB_DATA_TYPE_9, lineAttrTB.ATRB_FLD_NAME_10, lineAttrTB.ATRB_VALUE_10, lineAttrTB.ATRB_FLD_ID_10, lineAttrTB.ATRB_DATA_TYPE_10, lineAttrTB.ATRB_FLD_NAME_11, lineAttrTB.ATRB_VALUE_11, lineAttrTB.ATRB_FLD_ID_11, lineAttrTB.ATRB_DATA_TYPE_11, lineAttrTB.ATRB_FLD_NAME_12, lineAttrTB.ATRB_VALUE_12, lineAttrTB.ATRB_FLD_ID_12, lineAttrTB.ATRB_DATA_TYPE_12, lineAttrTB.ATRB_FLD_NAME_13, lineAttrTB.ATRB_VALUE_13, lineAttrTB.ATRB_FLD_ID_13, lineAttrTB.ATRB_DATA_TYPE_13, lineAttrTB.ATRB_FLD_NAME_14, lineAttrTB.ATRB_VALUE_14, lineAttrTB.ATRB_FLD_ID_14, lineAttrTB.ATRB_DATA_TYPE_14, lineAttrTB.ATRB_FLD_NAME_15, lineAttrTB.ATRB_VALUE_15, lineAttrTB.ATRB_FLD_ID_15, lineAttrTB.ATRB_DATA_TYPE_15, lineAttrTB.ATRB_FLD_NAME_16, lineAttrTB.ATRB_VALUE_16, lineAttrTB.ATRB_FLD_ID_16, lineAttrTB.ATRB_DATA_TYPE_16, lineAttrTB.ATRB_FLD_NAME_17, lineAttrTB.ATRB_VALUE_17, lineAttrTB.ATRB_FLD_ID_17, lineAttrTB.ATRB_DATA_TYPE_17, lineAttrTB.ATRB_FLD_NAME_18, lineAttrTB.ATRB_VALUE_18, lineAttrTB.ATRB_FLD_ID_18, lineAttrTB.ATRB_DATA_TYPE_18, lineAttrTB.ATRB_FLD_NAME_19, lineAttrTB.ATRB_VALUE_19, lineAttrTB.ATRB_FLD_ID_19, lineAttrTB.ATRB_DATA_TYPE_19, lineAttrTB.ATRB_FLD_NAME_20, lineAttrTB.ATRB_VALUE_20, lineAttrTB.ATRB_FLD_ID_20, lineAttrTB.ATRB_DATA_TYPE_20, lineAttrTB.ATRB_FLD_NAME_21, lineAttrTB.ATRB_VALUE_21, lineAttrTB.ATRB_FLD_ID_21, lineAttrTB.ATRB_DATA_TYPE_21, lineAttrTB.ATRB_FLD_NAME_22, lineAttrTB.ATRB_VALUE_22, lineAttrTB.ATRB_FLD_ID_22, lineAttrTB.ATRB_DATA_TYPE_22, lineAttrTB.ATRB_FLD_NAME_23, lineAttrTB.ATRB_VALUE_23, lineAttrTB.ATRB_FLD_ID_23, lineAttrTB.ATRB_DATA_TYPE_23, lineAttrTB.ATRB_FLD_NAME_24, lineAttrTB.ATRB_VALUE_24, lineAttrTB.ATRB_FLD_ID_24, lineAttrTB.ATRB_DATA_TYPE_24, lineAttrTB.ATRB_FLD_NAME_25, lineAttrTB.ATRB_VALUE_25, lineAttrTB.ATRB_FLD_ID_25, lineAttrTB.ATRB_DATA_TYPE_25, lineAttrTB.ATRB_FLD_NAME_26, lineAttrTB.ATRB_VALUE_26, lineAttrTB.ATRB_FLD_ID_26, lineAttrTB.ATRB_DATA_TYPE_26, lineAttrTB.ATRB_FLD_NAME_27, lineAttrTB.ATRB_VALUE_27, lineAttrTB.ATRB_FLD_ID_27, lineAttrTB.ATRB_DATA_TYPE_27, lineAttrTB.ATRB_FLD_NAME_28, lineAttrTB.ATRB_VALUE_28, lineAttrTB.ATRB_FLD_ID_28, lineAttrTB.ATRB_DATA_TYPE_28, lineAttrTB.ATRB_FLD_NAME_29, lineAttrTB.ATRB_VALUE_29, lineAttrTB.ATRB_FLD_ID_29, lineAttrTB.ATRB_DATA_TYPE_29, lineAttrTB.ATRB_FLD_NAME_30, lineAttrTB.ATRB_VALUE_30, lineAttrTB.ATRB_FLD_ID_30, lineAttrTB.ATRB_DATA_TYPE_30 from HWM_ALLOCATION_RULES_F ruleTB left join HWM_ALLOCATION_lines_f lineTB on ruleTB.ALLOCATION_RULE_ID = lineTB.ALLOCATION_RULE_ID AND ruleTB.EFFECTIVE_START_DATE = lineTB.EFFECTIVE_START_DATE AND ruleTB.EFFECTIVE_END_DATE = lineTB.EFFECTIVE_END_DATE AND ruleTB.ENTERPRISE_ID = lineTB.ENTERPRISE_ID left join ( select ALLOCATION_RULE_ID,ALLOCATION_LINE_ID,EFFECTIVE_START_DATE,EFFECTIVE_END_DATE, MAX(DECODE ( UI_ATRB_SEQUENCE , 1, ATRB_FLD_NAME)) ATRB_FLD_NAME_1, MAX(DECODE ( UI_ATRB_SEQUENCE , 1, ATRB_VALUE)) ATRB_VALUE_1, MAX(DECODE ( UI_ATRB_SEQUENCE , 1, TM_ATRB_FLD_ID)) ATRB_FLD_ID_1, MAX(DECODE ( UI_ATRB_SEQUENCE , 1, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_1, MAX(DECODE ( UI_ATRB_SEQUENCE , 2, ATRB_FLD_NAME)) ATRB_FLD_NAME_2, MAX(DECODE ( UI_ATRB_SEQUENCE , 2, ATRB_VALUE)) ATRB_VALUE_2, MAX(DECODE ( UI_ATRB_SEQUENCE , 2, TM_ATRB_FLD_ID)) ATRB_FLD_ID_2, MAX(DECODE ( UI_ATRB_SEQUENCE , 2, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_2, MAX(DECODE ( UI_ATRB_SEQUENCE , 3, ATRB_FLD_NAME)) ATRB_FLD_NAME_3, MAX(DECODE ( UI_ATRB_SEQUENCE , 3, ATRB_VALUE)) ATRB_VALUE_3, MAX(DECODE ( UI_ATRB_SEQUENCE , 3, TM_ATRB_FLD_ID)) ATRB_FLD_ID_3, MAX(DECODE ( UI_ATRB_SEQUENCE , 3, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_3, MAX(DECODE ( UI_ATRB_SEQUENCE , 4, ATRB_FLD_NAME)) ATRB_FLD_NAME_4, MAX(DECODE ( UI_ATRB_SEQUENCE , 4, ATRB_VALUE)) ATRB_VALUE_4, MAX(DECODE ( UI_ATRB_SEQUENCE , 4, TM_ATRB_FLD_ID)) ATRB_FLD_ID_4, MAX(DECODE ( UI_ATRB_SEQUENCE , 4, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_4, MAX(DECODE ( UI_ATRB_SEQUENCE , 5, ATRB_FLD_NAME)) ATRB_FLD_NAME_5, MAX(DECODE ( UI_ATRB_SEQUENCE , 5, ATRB_VALUE)) ATRB_VALUE_5, MAX(DECODE ( UI_ATRB_SEQUENCE , 5, TM_ATRB_FLD_ID)) ATRB_FLD_ID_5, MAX(DECODE ( UI_ATRB_SEQUENCE , 5, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_5, MAX(DECODE ( UI_ATRB_SEQUENCE , 6, ATRB_FLD_NAME)) ATRB_FLD_NAME_6, MAX(DECODE ( UI_ATRB_SEQUENCE , 6, ATRB_VALUE)) ATRB_VALUE_6, MAX(DECODE ( UI_ATRB_SEQUENCE , 6, TM_ATRB_FLD_ID)) ATRB_FLD_ID_6, MAX(DECODE ( UI_ATRB_SEQUENCE , 6, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_6, MAX(DECODE ( UI_ATRB_SEQUENCE , 7, ATRB_FLD_NAME)) ATRB_FLD_NAME_7, MAX(DECODE ( UI_ATRB_SEQUENCE , 7, ATRB_VALUE)) ATRB_VALUE_7, MAX(DECODE ( UI_ATRB_SEQUENCE , 7, TM_ATRB_FLD_ID)) ATRB_FLD_ID_7, MAX(DECODE ( UI_ATRB_SEQUENCE , 7, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_7, MAX(DECODE ( UI_ATRB_SEQUENCE , 8, ATRB_FLD_NAME)) ATRB_FLD_NAME_8, MAX(DECODE ( UI_ATRB_SEQUENCE , 8, ATRB_VALUE)) ATRB_VALUE_8, MAX(DECODE ( UI_ATRB_SEQUENCE , 8, TM_ATRB_FLD_ID)) ATRB_FLD_ID_8, MAX(DECODE ( UI_ATRB_SEQUENCE , 8, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_8, MAX(DECODE ( UI_ATRB_SEQUENCE , 9, ATRB_FLD_NAME)) ATRB_FLD_NAME_9, MAX(DECODE ( UI_ATRB_SEQUENCE , 9, ATRB_VALUE)) ATRB_VALUE_9, MAX(DECODE ( UI_ATRB_SEQUENCE , 9, TM_ATRB_FLD_ID)) ATRB_FLD_ID_9, MAX(DECODE ( UI_ATRB_SEQUENCE , 9, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_9, MAX(DECODE ( UI_ATRB_SEQUENCE , 10, ATRB_FLD_NAME)) ATRB_FLD_NAME_10, MAX(DECODE ( UI_ATRB_SEQUENCE , 10, ATRB_VALUE)) ATRB_VALUE_10, MAX(DECODE ( UI_ATRB_SEQUENCE , 10, TM_ATRB_FLD_ID)) ATRB_FLD_ID_10, MAX(DECODE ( UI_ATRB_SEQUENCE , 10, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_10, MAX(DECODE ( UI_ATRB_SEQUENCE , 11, ATRB_FLD_NAME)) ATRB_FLD_NAME_11, MAX(DECODE ( UI_ATRB_SEQUENCE , 11, ATRB_VALUE)) ATRB_VALUE_11, MAX(DECODE ( UI_ATRB_SEQUENCE , 11, TM_ATRB_FLD_ID)) ATRB_FLD_ID_11, MAX(DECODE ( UI_ATRB_SEQUENCE , 11, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_11, MAX(DECODE ( UI_ATRB_SEQUENCE , 12, ATRB_FLD_NAME)) ATRB_FLD_NAME_12, MAX(DECODE ( UI_ATRB_SEQUENCE , 12, ATRB_VALUE)) ATRB_VALUE_12, MAX(DECODE ( UI_ATRB_SEQUENCE , 12, TM_ATRB_FLD_ID)) ATRB_FLD_ID_12, MAX(DECODE ( UI_ATRB_SEQUENCE , 12, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_12, MAX(DECODE ( UI_ATRB_SEQUENCE , 13, ATRB_FLD_NAME)) ATRB_FLD_NAME_13, MAX(DECODE ( UI_ATRB_SEQUENCE , 13, ATRB_VALUE)) ATRB_VALUE_13, MAX(DECODE ( UI_ATRB_SEQUENCE , 13, TM_ATRB_FLD_ID)) ATRB_FLD_ID_13, MAX(DECODE ( UI_ATRB_SEQUENCE , 13, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_13, MAX(DECODE ( UI_ATRB_SEQUENCE , 14, ATRB_FLD_NAME)) ATRB_FLD_NAME_14, MAX(DECODE ( UI_ATRB_SEQUENCE , 14, ATRB_VALUE)) ATRB_VALUE_14, MAX(DECODE ( UI_ATRB_SEQUENCE , 14, TM_ATRB_FLD_ID)) ATRB_FLD_ID_14, MAX(DECODE ( UI_ATRB_SEQUENCE , 14, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_14, MAX(DECODE ( UI_ATRB_SEQUENCE , 15, ATRB_FLD_NAME)) ATRB_FLD_NAME_15, MAX(DECODE ( UI_ATRB_SEQUENCE , 15, ATRB_VALUE)) ATRB_VALUE_15, MAX(DECODE ( UI_ATRB_SEQUENCE , 15, TM_ATRB_FLD_ID)) ATRB_FLD_ID_15, MAX(DECODE ( UI_ATRB_SEQUENCE , 15, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_15, MAX(DECODE ( UI_ATRB_SEQUENCE , 16, ATRB_FLD_NAME)) ATRB_FLD_NAME_16, MAX(DECODE ( UI_ATRB_SEQUENCE , 16, ATRB_VALUE)) ATRB_VALUE_16, MAX(DECODE ( UI_ATRB_SEQUENCE , 16, TM_ATRB_FLD_ID)) ATRB_FLD_ID_16, MAX(DECODE ( UI_ATRB_SEQUENCE , 16, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_16, MAX(DECODE ( UI_ATRB_SEQUENCE , 17, ATRB_FLD_NAME)) ATRB_FLD_NAME_17, MAX(DECODE ( UI_ATRB_SEQUENCE , 17, ATRB_VALUE)) ATRB_VALUE_17, MAX(DECODE ( UI_ATRB_SEQUENCE , 17, TM_ATRB_FLD_ID)) ATRB_FLD_ID_17, MAX(DECODE ( UI_ATRB_SEQUENCE , 17, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_17, MAX(DECODE ( UI_ATRB_SEQUENCE , 18, ATRB_FLD_NAME)) ATRB_FLD_NAME_18, MAX(DECODE ( UI_ATRB_SEQUENCE , 18, ATRB_VALUE)) ATRB_VALUE_18, MAX(DECODE ( UI_ATRB_SEQUENCE , 18, TM_ATRB_FLD_ID)) ATRB_FLD_ID_18, MAX(DECODE ( UI_ATRB_SEQUENCE , 18, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_18, MAX(DECODE ( UI_ATRB_SEQUENCE , 19, ATRB_FLD_NAME)) ATRB_FLD_NAME_19, MAX(DECODE ( UI_ATRB_SEQUENCE , 19, ATRB_VALUE)) ATRB_VALUE_19, MAX(DECODE ( UI_ATRB_SEQUENCE , 19, TM_ATRB_FLD_ID)) ATRB_FLD_ID_19, MAX(DECODE ( UI_ATRB_SEQUENCE , 19, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_19, MAX(DECODE ( UI_ATRB_SEQUENCE , 20, ATRB_FLD_NAME)) ATRB_FLD_NAME_20, MAX(DECODE ( UI_ATRB_SEQUENCE , 20, ATRB_VALUE)) ATRB_VALUE_20, MAX(DECODE ( UI_ATRB_SEQUENCE , 20, TM_ATRB_FLD_ID)) ATRB_FLD_ID_20, MAX(DECODE ( UI_ATRB_SEQUENCE , 20, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_20, MAX(DECODE ( UI_ATRB_SEQUENCE , 21, ATRB_FLD_NAME)) ATRB_FLD_NAME_21, MAX(DECODE ( UI_ATRB_SEQUENCE , 21, ATRB_VALUE)) ATRB_VALUE_21, MAX(DECODE ( UI_ATRB_SEQUENCE , 21, TM_ATRB_FLD_ID)) ATRB_FLD_ID_21, MAX(DECODE ( UI_ATRB_SEQUENCE , 21, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_21, MAX(DECODE ( UI_ATRB_SEQUENCE , 22, ATRB_FLD_NAME)) ATRB_FLD_NAME_22, MAX(DECODE ( UI_ATRB_SEQUENCE , 22, ATRB_VALUE)) ATRB_VALUE_22, MAX(DECODE ( UI_ATRB_SEQUENCE , 22, TM_ATRB_FLD_ID)) ATRB_FLD_ID_22, MAX(DECODE ( UI_ATRB_SEQUENCE , 22, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_22, MAX(DECODE ( UI_ATRB_SEQUENCE , 23, ATRB_FLD_NAME)) ATRB_FLD_NAME_23, MAX(DECODE ( UI_ATRB_SEQUENCE , 23, ATRB_VALUE)) ATRB_VALUE_23, MAX(DECODE ( UI_ATRB_SEQUENCE , 23, TM_ATRB_FLD_ID)) ATRB_FLD_ID_23, MAX(DECODE ( UI_ATRB_SEQUENCE , 23, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_23, MAX(DECODE ( UI_ATRB_SEQUENCE , 24, ATRB_FLD_NAME)) ATRB_FLD_NAME_24, MAX(DECODE ( UI_ATRB_SEQUENCE , 24, ATRB_VALUE)) ATRB_VALUE_24, MAX(DECODE ( UI_ATRB_SEQUENCE , 24, TM_ATRB_FLD_ID)) ATRB_FLD_ID_24, MAX(DECODE ( UI_ATRB_SEQUENCE , 24, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_24, MAX(DECODE ( UI_ATRB_SEQUENCE , 25, ATRB_FLD_NAME)) ATRB_FLD_NAME_25, MAX(DECODE ( UI_ATRB_SEQUENCE , 25, ATRB_VALUE)) ATRB_VALUE_25, MAX(DECODE ( UI_ATRB_SEQUENCE , 25, TM_ATRB_FLD_ID)) ATRB_FLD_ID_25, MAX(DECODE ( UI_ATRB_SEQUENCE , 25, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_25, MAX(DECODE ( UI_ATRB_SEQUENCE , 26, ATRB_FLD_NAME)) ATRB_FLD_NAME_26, MAX(DECODE ( UI_ATRB_SEQUENCE , 26, ATRB_VALUE)) ATRB_VALUE_26, MAX(DECODE ( UI_ATRB_SEQUENCE , 26, TM_ATRB_FLD_ID)) ATRB_FLD_ID_26, MAX(DECODE ( UI_ATRB_SEQUENCE , 26, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_26, MAX(DECODE ( UI_ATRB_SEQUENCE , 27, ATRB_FLD_NAME)) ATRB_FLD_NAME_27, MAX(DECODE ( UI_ATRB_SEQUENCE , 27, ATRB_VALUE)) ATRB_VALUE_27, MAX(DECODE ( UI_ATRB_SEQUENCE , 27, TM_ATRB_FLD_ID)) ATRB_FLD_ID_27, MAX(DECODE ( UI_ATRB_SEQUENCE , 27, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_27, MAX(DECODE ( UI_ATRB_SEQUENCE , 28, ATRB_FLD_NAME)) ATRB_FLD_NAME_28, MAX(DECODE ( UI_ATRB_SEQUENCE , 28, ATRB_VALUE)) ATRB_VALUE_28, MAX(DECODE ( UI_ATRB_SEQUENCE , 28, TM_ATRB_FLD_ID)) ATRB_FLD_ID_28, MAX(DECODE ( UI_ATRB_SEQUENCE , 28, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_28, MAX(DECODE ( UI_ATRB_SEQUENCE , 29, ATRB_FLD_NAME)) ATRB_FLD_NAME_29, MAX(DECODE ( UI_ATRB_SEQUENCE , 29, ATRB_VALUE)) ATRB_VALUE_29, MAX(DECODE ( UI_ATRB_SEQUENCE , 29, TM_ATRB_FLD_ID)) ATRB_FLD_ID_29, MAX(DECODE ( UI_ATRB_SEQUENCE , 29, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_29, MAX(DECODE ( UI_ATRB_SEQUENCE , 30, ATRB_FLD_NAME)) ATRB_FLD_NAME_30, MAX(DECODE ( UI_ATRB_SEQUENCE , 30, ATRB_VALUE)) ATRB_VALUE_30, MAX(DECODE ( UI_ATRB_SEQUENCE , 30, TM_ATRB_FLD_ID)) ATRB_FLD_ID_30, MAX(DECODE ( UI_ATRB_SEQUENCE , 30, ATRB_DATA_TYPE)) ATRB_DATA_TYPE_30, ENTERPRISE_ID from ( select ALLOCATION_RULE_ID,ALLOCATION_LINE_ID,EFFECTIVE_START_DATE,UI_ATRB_SEQUENCE,EFFECTIVE_END_DATE, ATRB_FLD_NAME, TM_ATRB_FLD_ID, ATRB_DATA_TYPE, (CASE ATRB_DATA_TYPE WHEN 'NUMBER' THEN to_char(ATRB_VALUE_NUMBER) WHEN 'DATE' THEN to_char(ATRB_VALUE_TIMESTAMP,'yyyy-MM-dd') WHEN 'TIMESTAMP' THEN to_char(ATRB_VALUE_TIMESTAMP,'HH24:mi') ELSE ATRB_VALUE_TEXT END) as ATRB_VALUE, ENTERPRISE_ID from HWM_ALLOCATION_LN_ATRBS_F) tmplineAttr group by ALLOCATION_RULE_ID,ALLOCATION_LINE_ID,EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,ENTERPRISE_ID order by ALLOCATION_RULE_ID,ALLOCATION_LINE_ID,EFFECTIVE_START_DATE,EFFECTIVE_END_DATE,ENTERPRISE_ID ) lineAttrTB on lineTB.ALLOCATION_RULE_ID = lineAttrTB.ALLOCATION_RULE_ID AND lineTB.ALLOCATION_LINE_ID = lineAttrTB.ALLOCATION_LINE_ID AND lineTB.EFFECTIVE_START_DATE = lineAttrTB.EFFECTIVE_START_DATE AND lineTB.EFFECTIVE_END_DATE = lineAttrTB.EFFECTIVE_END_DATE AND lineTB.ENTERPRISE_ID = lineAttrTB.ENTERPRISE_ID