View: OKL_CS_ALL_PARTIES_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_CS_ALL_PARTIES_UV

View Text

SELECT CHR.ID CONTRACT_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, PR.ROLE ROLE_NAME
, NVL(''
, 0) AMT_GUARANTEED
, P.PARTY_TYPE PTYPE
, P.PARTY_NAME COMPANY
, P.PARTY_NUMBER CUSTOMER_NUMBER
, P.EMAIL_ADDRESS EMAIL
, DECODE(HCP.PHONE_COUNTRY_CODE
, NULL
, NULL
, HCP.PHONE_COUNTRY_CODE||'-')||DECODE(HCP.PHONE_AREA_CODE
, NULL
, NULL
, HCP.PHONE_AREA_CODE||'-')||HCP.PHONE_NUMBER PHONE
, P.ADDRESS1 ADDRESS1
, P.ADDRESS2 ADDRESS2
, P.ADDRESS3 ADDRESS3
, P.ADDRESS4 ADDRESS4
, P.CITY CITY
, P.COUNTY COUNTY
, P.PROVINCE PROVINCE
, P.STATE STATE
, P.POSTAL_CODE POSTAL_CODE
, P.COUNTRY COUNTRY
FROM OKC_K_PARTY_ROLES_V PR
, HZ_PARTIES P
, OKC_K_HEADERS_B CHR
, HZ_CONTACT_POINTS HCP
WHERE CHR.ID = PR.CHR_ID
AND P.PARTY_ID = PR.OBJECT1_ID1
AND PR.JTOT_OBJECT1_CODE IN ( 'OKX_PARTY'
, 'OKX_OPERUNIT' )
AND PR.RLE_CODE <> 'GUARANTOR'
AND P.PARTY_ID = HCP.OWNER_TABLE_ID(+)
AND HCP.OWNER_TABLE_NAME(+) = 'HZ_PARTIES'
AND HCP.STATUS(+) = 'A'
AND HCP.PRIMARY_FLAG(+) = 'Y'
AND HCP.CONTACT_POINT_TYPE(+) = 'PHONE'

Columns