HWM_ALLOCATION_LEVELS_X

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name

DATA_LEVEL ALLOCATION_ID EFFECTIVE_START_DATE EFFECTIVE_END_DATE OBJECT_VERSION_NUMBER ENTERPRISE_ID ALLOCATION_NAME DESCRIPTION ALLOCATION_RULE_ID ALLOCATION_RULE_PRIORITY TCAT_ID ALLOCATION_TYPE RUN_SUMMATION_LEVEL ALLOCATION_LINE_ID ALLOCATION_LINE_PRIORITY ALLOCATION_VALUE ALLOCATION_LN_ATRB_ID TM_ATRB_FLD_ID ATRB_FLD_NAME ATRB_DATA_TYPE ATRB_VALUE_TEXT ATRB_VALUE_NUMBER ATRB_VALUE_TIMESTAMP ATRB_VALUE_DATE

Query

SQL_Statement

SELECT hdr.DATA_LEVEL ,hdr.ALLOCATION_ID ,hdr.EFFECTIVE_START_DATE ,hdr.EFFECTIVE_END_DATE ,hdr.OBJECT_VERSION_NUMBER ,hdr.ENTERPRISE_ID ,hdr.ALLOCATION_NAME ,hdr.DESCRIPTION ,null as ALLOCATION_RULE_ID ,null as ALLOCATION_RULE_PRIORITY ,null as TCAT_ID ,null as ALLOCATION_TYPE ,null as RUN_SUMMATION_LEVEL ,null as ALLOCATION_LINE_ID ,null as ALLOCATION_LINE_PRIORITY ,null as ALLOCATION_VALUE ,null as ALLOCATION_LN_ATRB_ID ,null as TM_ATRB_FLD_ID ,null as ATRB_FLD_NAME ,null as ATRB_DATA_TYPE ,null as ATRB_VALUE_TEXT ,null as ATRB_VALUE_NUMBER ,null as ATRB_VALUE_TIMESTAMP ,null as ATRB_VALUE_DATE FROM HWM_ALLOCATIONS_HDR_vl hdr union SELECT rul.DATA_LEVEL ,hdr.ALLOCATION_ID ,hdr.EFFECTIVE_START_DATE ,hdr.EFFECTIVE_END_DATE ,hdr.OBJECT_VERSION_NUMBER ,hdr.ENTERPRISE_ID ,hdr.ALLOCATION_NAME ,hdr.DESCRIPTION ,rul.ALLOCATION_RULE_ID ,rul.ALLOCATION_RULE_PRIORITY ,rul.TCAT_ID ,rul.ALLOCATION_TYPE ,rul.RUN_SUMMATION_LEVEL ,null as ALLOCATION_LINE_ID ,null as ALLOCATION_LINE_PRIORITY ,null as ALLOCATION_VALUE ,null as ALLOCATION_LN_ATRB_ID ,null as TM_ATRB_FLD_ID ,null as ATRB_FLD_NAME ,null as ATRB_DATA_TYPE ,null as ATRB_VALUE_TEXT ,null as ATRB_VALUE_NUMBER ,null as ATRB_VALUE_TIMESTAMP ,null as ATRB_VALUE_DATE FROM HWM_ALLOCATIONS_HDR_vl hdr, HWM_ALLOCATION_RULES_F rul WHERE hdr.ALLOCATION_ID = rul.ALLOCATION_ID and hdr.EFFECTIVE_START_DATE = rul.EFFECTIVE_START_DATE and hdr.EFFECTIVE_END_DATE = rul.EFFECTIVE_END_DATE union SELECT lne.DATA_LEVEL ,hdr.ALLOCATION_ID ,hdr.EFFECTIVE_START_DATE ,hdr.EFFECTIVE_END_DATE ,hdr.OBJECT_VERSION_NUMBER ,hdr.ENTERPRISE_ID ,hdr.ALLOCATION_NAME ,hdr.DESCRIPTION ,rul.ALLOCATION_RULE_ID ,rul.ALLOCATION_RULE_PRIORITY ,rul.TCAT_ID ,rul.ALLOCATION_TYPE ,rul.RUN_SUMMATION_LEVEL ,lne.ALLOCATION_LINE_ID ,lne.ALLOCATION_LINE_PRIORITY ,lne.ALLOCATION_VALUE ,null as ALLOCATION_LN_ATRB_ID ,null as TM_ATRB_FLD_ID ,null as ATRB_FLD_NAME ,null as ATRB_DATA_TYPE ,null as ATRB_VALUE_TEXT ,null as ATRB_VALUE_NUMBER ,null as ATRB_VALUE_TIMESTAMP ,null as ATRB_VALUE_DATE FROM HWM_ALLOCATIONS_HDR_vl hdr, HWM_ALLOCATION_RULES_F rul, HWM_ALLOCATION_LINES_F lne WHERE hdr.ALLOCATION_ID = rul.ALLOCATION_ID and hdr.EFFECTIVE_START_DATE = rul.EFFECTIVE_START_DATE and hdr.EFFECTIVE_END_DATE = rul.EFFECTIVE_END_DATE and rul.ALLOCATION_RULE_ID = lne.ALLOCATION_RULE_ID and hdr.EFFECTIVE_START_DATE = lne.EFFECTIVE_START_DATE and hdr.EFFECTIVE_END_DATE = lne.EFFECTIVE_END_DATE union SELECT lat.DATA_LEVEL ,hdr.ALLOCATION_ID ,hdr.EFFECTIVE_START_DATE ,hdr.EFFECTIVE_END_DATE ,hdr.OBJECT_VERSION_NUMBER ,hdr.ENTERPRISE_ID ,hdr.ALLOCATION_NAME ,hdr.DESCRIPTION ,rul.ALLOCATION_RULE_ID ,rul.ALLOCATION_RULE_PRIORITY ,rul.TCAT_ID ,rul.ALLOCATION_TYPE ,rul.RUN_SUMMATION_LEVEL ,lne.ALLOCATION_LINE_ID ,lne.ALLOCATION_LINE_PRIORITY ,lne.ALLOCATION_VALUE ,lat.ALLOCATION_LN_ATRB_ID ,lat.TM_ATRB_FLD_ID ,lat.ATRB_FLD_NAME ,lat.ATRB_DATA_TYPE ,lat.ATRB_VALUE_TEXT ,lat.ATRB_VALUE_NUMBER ,lat.ATRB_VALUE_TIMESTAMP ,null as ATRB_VALUE_DATE FROM HWM_ALLOCATIONS_HDR_vl hdr, HWM_ALLOCATION_RULES_F rul, HWM_ALLOCATION_LINES_F lne, HWM_ALLOCATION_LN_ATRBS_F lat WHERE hdr.ALLOCATION_ID = rul.ALLOCATION_ID and hdr.EFFECTIVE_START_DATE = rul.EFFECTIVE_START_DATE and hdr.EFFECTIVE_END_DATE = rul.EFFECTIVE_END_DATE and rul.ALLOCATION_RULE_ID = lne.ALLOCATION_RULE_ID and hdr.EFFECTIVE_START_DATE = lne.EFFECTIVE_START_DATE and hdr.EFFECTIVE_END_DATE = lne.EFFECTIVE_END_DATE and lne.ALLOCATION_LINE_ID = lat.ALLOCATION_LINE_ID and hdr.EFFECTIVE_START_DATE = lat.EFFECTIVE_START_DATE and hdr.EFFECTIVE_END_DATE = lat.EFFECTIVE_END_DATE