VIEW: APPS.OKL_CS_CONT_PARTY_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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