機械翻訳について

POZ_SUPP_RELATIONSHIP_VL

詳細

• スキーマ: FUSION

• オブジェクト所有者: POZ

• オブジェクト・タイプ: VIEW

列

名前
PARTY_ID PARTY_USAGE_CODE PARTY_USAGE_TYPE PARTY_USAGE_NAME DESCRIPTION STATUS_FLAG EFFECTIVE_START_DATE EFFECTIVE_END_DATE

問合せ

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