View: OKL_CS_CONT_SRCH_RESULTS_UV

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

View Text

SELECT CHR.ID CONTRACT_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, P.PARTY_NAME PARTY_NAME
, P.ORGANIZATION_NAME_PHONETIC ALTERNATE_NAME
, PROD.NAME PRODUCT_TYPE
, STAT.MEANING STATUS
, CHR.DESCRIPTION SHORT_DESCRIPTION
, NULL PRIVATE_LABEL
, CHR.START_DATE START_DATE
, CHR.END_DATE END_DATE
, CA.ACCOUNT_NUMBER ACCOUNT
, 'OKC_K_HEADER' OBJECT_CODE
, CHR.ORG_ID ORG_ID
, OU.NAME OPERATING_UNIT
FROM HR_OPERATING_UNITS OU
, HZ_CUST_ACCOUNTS CA
, HZ_PARTIES P
, OKC_K_HEADERS_V CHR
, OKL_K_HEADERS KHR
, OKL_PRODUCTS PROD
, OKC_STATUSES_V STAT
WHERE CHR.SCS_CODE = 'LEASE'
AND CA.CUST_ACCOUNT_ID = CHR.CUST_ACCT_ID
AND CA.PARTY_ID = P.PARTY_ID
AND KHR.ID = CHR.ID
AND KHR.PDT_ID = PROD.ID
AND CHR.STS_CODE = STAT.CODE
AND STAT.CODE != 'ABANDONED'
AND OU.ORGANIZATION_ID = CHR.ORG_ID

Columns