POZ_SUPP_RELATIONSHIP_VL

Details

• Schema: FUSION

• Object owner: POZ

• Object type: VIEW

Columns

Name
PARTY_ID PARTY_USAGE_CODE PARTY_USAGE_TYPE PARTY_USAGE_NAME DESCRIPTION STATUS_FLAG EFFECTIVE_START_DATE EFFECTIVE_END_DATE

Query

SQL_Statement

SELECT P.PARTY_ID, USAGES.PARTY_USAGE_CODE, USAGES.PARTY_USAGE_TYPE, USAGES.PARTY_USAGE_NAME, USAGES.DESCRIPTION, ASSI.STATUS_FLAG, ASSI.EFFECTIVE_START_DATE, ASSI.EFFECTIVE_END_DATE FROM HZ_PARTIES P, HZ_PARTY_USG_ASSIGNMENTS ASSI, HZ_PARTY_USAGES_VL USAGES WHERE P.PARTY_ID = ASSI.PARTY_ID AND ASSI.PARTY_USAGE_CODE = USAGES.PARTY_USAGE_CODE (+) AND ASSI.STATUS_FLAG='A' AND SYSDATE >= ASSI.EFFECTIVE_START_DATE AND SYSDATE <= ASSI.EFFECTIVE_END_DATE