VIEW: APPS.OKL_CS_LESSOR_UV

Source

View Text - Preformatted

SELECT chr.id contract_id, chr.contract_number contract_number, pr.role role_name, nvl('',0) amt_guaranteed, OKX_OPERUNIT.ORGANIZATION_TYPE ptype, OKX_OPERUNIT.name Company, OKX_OPERUNIT.party_number Customer_number, nvl('','') email, loc.Telephone_number_1 phone, loc.address_line_1 address1, loc.address_line_2 address2, loc.address_line_3 address3, nvl('','') address4, loc.town_or_city city, nvl('','') county, nvl('','') province, loc.region_1 state, loc.postal_code postal_code, loc.country country FROM OKC_K_PARTY_ROLES_V PR,OKC_K_HEADERS_B CHR,HR_ALL_ORGANIZATION_UNITS OU,OKX_ORGANIZATION_DEFS_V OKX_OPERUNIT,HR_LOCATIONS LOC WHERE OKX_OPERUNIT.ORGANIZATION_TYPE = 'OPERATING_UNIT' AND OKX_OPERUNIT.INFORMATION_TYPE = 'Operating Unit Information' AND chr.id = pr.chr_id AND pr.jtot_object1_code = 'OKX_OPERUNIT' AND OKX_OPERUNIT.id1=pr.object1_id1 AND OKX_OPERUNIT.id2=pr.object1_id2 AND OU.ORGANIZATION_ID=OKX_OPERUNIT.ID1 AND LOC.LOCATION_ID(+) = OU.LOCATION_ID

View Text - HTML Formatted

SELECT CHR.ID CONTRACT_ID
, CHR.CONTRACT_NUMBER CONTRACT_NUMBER
, PR.ROLE ROLE_NAME
, NVL(''
, 0) AMT_GUARANTEED
, OKX_OPERUNIT.ORGANIZATION_TYPE PTYPE
, OKX_OPERUNIT.NAME COMPANY
, OKX_OPERUNIT.PARTY_NUMBER CUSTOMER_NUMBER
, NVL(''
, '') EMAIL
, LOC.TELEPHONE_NUMBER_1 PHONE
, LOC.ADDRESS_LINE_1 ADDRESS1
, LOC.ADDRESS_LINE_2 ADDRESS2
, LOC.ADDRESS_LINE_3 ADDRESS3
, NVL(''
, '') ADDRESS4
, LOC.TOWN_OR_CITY CITY
, NVL(''
, '') COUNTY
, NVL(''
, '') PROVINCE
, LOC.REGION_1 STATE
, LOC.POSTAL_CODE POSTAL_CODE
, LOC.COUNTRY COUNTRY
FROM OKC_K_PARTY_ROLES_V PR
, OKC_K_HEADERS_B CHR
, HR_ALL_ORGANIZATION_UNITS OU
, OKX_ORGANIZATION_DEFS_V OKX_OPERUNIT
, HR_LOCATIONS LOC
WHERE OKX_OPERUNIT.ORGANIZATION_TYPE = 'OPERATING_UNIT'
AND OKX_OPERUNIT.INFORMATION_TYPE = 'OPERATING UNIT INFORMATION'
AND CHR.ID = PR.CHR_ID
AND PR.JTOT_OBJECT1_CODE = 'OKX_OPERUNIT'
AND OKX_OPERUNIT.ID1=PR.OBJECT1_ID1
AND OKX_OPERUNIT.ID2=PR.OBJECT1_ID2
AND OU.ORGANIZATION_ID=OKX_OPERUNIT.ID1
AND LOC.LOCATION_ID(+) = OU.LOCATION_ID