View: OKL_CS_CONT_PARTY_UV

Product:	OKL - Leasing and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_CONT_PARTY_UV

View Text

SELECT DISTINCT CHR.ID CONTRACT_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, CHR.START_DATE START_DATE
, CHR.END_DATE END_DATE
, STAT.MEANING STATUS
, CHR.DESCRIPTION DESCRIPTION
, P.PARTY_ID PARTY_ID
, P.PARTY_TYPE PARTY_TYPE
, P.STATUS PARTY_STATUS
, P.PARTY_NUMBER PARTY_NUMBER
, P.ADDRESS1 ADDRESS1
, P.ADDRESS2 ADDRESS2
, P.PARTY_NAME PARTY_NAME
, P.STATE STATE
, P.CITY CITY
, P.PROVINCE PROVINCE
, P.POSTAL_CODE POSTAL_CODE
, P.COUNTY COUNTY
, P.COUNTRY COUNTRY
, CP.PHONE_COUNTRY_CODE PHONE_COUNTRY_CODE
, CP.PHONE_AREA_CODE PHONE_AREA_CODE
, CP.PHONE_NUMBER PHONE_NUMBER
, CA.ACCOUNT_NUMBER ACCOUNT
, CHR.ORG_ID ORG_ID
, OU.NAME OPERATING_UNIT
FROM HR_OPERATING_UNITS OU
, HZ_CONTACT_POINTS CP
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES P
, OKC_K_HEADERS_V CHR
, OKC_STATUSES_V STAT
WHERE CHR.SCS_CODE = 'LEASE'
AND CHR.STS_CODE = STAT.CODE
AND STAT.CODE <> 'ABANDONED'
AND CHR.CUST_ACCT_ID =CA.CUST_ACCOUNT_ID
AND CA.PARTY_ID = P.PARTY_ID
AND P.PARTY_ID = CP.OWNER_TABLE_ID(+)
AND CP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND CP.PRIMARY_FLAG(+) = 'Y'
AND CP.CONTACT_POINT_TYPE(+) = 'PHONE'
AND OU.ORGANIZATION_ID = CHR.ORG_ID

Columns