HWM_ALLOCATION_LN_ATRBS_DTL_X

Details

• Schema: FUSION

• Object owner: HWM

• Object type: VIEW

Columns

Name
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 DATA_LEVEL

Query

SQL_Statement

SELECT 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 ,lat.DATA_LEVEL 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