VIEW: APPS.OKL_CS_CONT_SRCH_RESULTS_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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