HWM_ALLOCATION_LINES_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 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 ,lne.DATA_LEVEL 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