VIEW: APPS.OKL_CS_ALL_PARTIES_UV

Source

View Text - Preformatted

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 chr.id = pr.dnz_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'

View Text - HTML Formatted

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 CHR.ID = PR.DNZ_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'