1. Tables and Views for Sales and Fusion Service
  2. HZ_CONTACT_V

HZ_CONTACT_V

Details

  • Schema: FUSION

  • Object owner: HZ

  • Object type: VIEW

Columns

Name

PARTY_ID

PARTY_NUMBER

PARTY_NAME

Query

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'