View: OKL_CS_LC_HEADER_UV

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

View Text

SELECT CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, PDT.NAME PRODUCT_NAME
, STST.MEANING CONTRACT_STATUS
, CHR.START_DATE START_DATE
, CHR.END_DATE END_DATE
, CHRT.DESCRIPTION DESCRIPTION
, CHR.CUST_PO_NUMBER
, HZP.PERSON_NAME_SUFFIX ||' '||HZP.PERSON_FIRST_NAME||' '||HZP.PERSON_MIDDLE_NAME||' '||HZP.PERSON_LAST_NAME CONTACT_PERSON
, HZP.PERSON_TITLE TITLE
, HZP.PARTY_NAME CUSTOMER
, HZP.ORGANIZATION_NAME_PHONETIC ORGANIZATION_NAME_PHONETIC
, HZP.ADDRESS1||' '||HZP.ADDRESS2||' '||HZP.ADDRESS3||HZP.ADDRESS4||'
, '||HZP.CITY||'
, '||HZP.COUNTRY||' '||HZP.POSTAL_CODE ADDRESS
, HCP.PHONE_COUNTRY_CODE PHONE_COUNTRY
, HCP.PHONE_AREA_CODE PHONE_AREA
, HCP.PHONE_NUMBER PHONE_NUMBER
, HCP.PHONE_EXTENSION PHONE_EXTENSION
, HCP.TELEX_NUMBER FAX_NUMBER
, HZP.EMAIL_ADDRESS EMAIL
, CHR.INV_ORGANIZATION_ID ORG_ID
, CHR.ID CONTRACT_ID
, CHR.CURRENCY_CODE CURRENCY_CODE
, HZP.PARTY_ID PARTY_ID
, HCA.CUST_ACCOUNT_ID CUST_ACCOUNT_ID
FROM OKC_K_HEADERS_TL CHRT
, OKC_K_HEADERS_B CHR
, OKL_K_HEADERS KHR
, OKC_STATUSES_TL STST
, OKL_PRODUCTS PDT
, HZ_CUST_ACCOUNTS HCA
, HZ_PARTIES HZP
, HZ_CONTACT_POINTS HCP
WHERE CHRT.ID = CHR.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND CHR.ID = KHR.ID
AND KHR.PDT_ID = PDT.ID(+)
AND CHR.STS_CODE = STST.CODE
AND STST.LANGUAGE = USERENV('LANG')
AND CHR.CUST_ACCT_ID = HCA.CUST_ACCOUNT_ID
AND HCA.PARTY_ID = HZP.PARTY_ID
AND HZP.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