機械翻訳について

HZ_CONTACT_V

詳細

• スキーマ: FUSION

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

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

列

名前
PARTY_ID PARTY_NUMBER PARTY_NAME

問合せ

SQL_Statement
SELECT HP.PARTY_ID ,HP.PARTY_NUMBER,HP.PARTY_NAME FROM HZ_PARTIES HP, HZ_PARTY_USG_ASSIGNMENTS PUA WHERE HP.PARTY_ID = PUA.PARTY_ID AND PUA.PARTY_USAGE_CODE='ORG_CONTACT' AND TRUNC(SYSDATE) BETWEEN TRUNC(PUA.EFFECTIVE_START_DATE) AND TRUNC(PUA.EFFECTIVE_END_DATE) AND PUA.STATUS_FLAG = 'A' AND PUA.OWNER_TABLE_ID IS NOT NULL AND PUA.OWNER_TABLE_NAME = 'HZ_RELATIONSHIPS'