View: OKL_CS_LESSOR_UV

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

View Text

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

Columns