View: OKL_POOL_CONTRACTS_UV

Product:	OKL - Lease and Finance Management
Description:	Securitization - Pool Contracts UI view
Implementation/DBA Data:	APPS.OKL_POOL_CONTRACTS_UV

View Text

SELECT CHRB.ID DNZ_CHR_ID
, CHRB.CONTRACT_NUMBER CONTRACT_NUMBER
, KHRB.PRE_TAX_YIELD PRE_TAX_YIELD
, KHRB.DEAL_TYPE BOOK_CLASSIFICATION
, KHRB.PDT_ID PDT_ID
, KHRB.ASSIGNABLE_YN ASSIGNABLE_YN
, CHRB.STS_CODE STS_CODE
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.AUTHORING_ORG_ID OPERATING_UNIT
, CHRB.CURRENCY_CODE CURRENCY_CODE
, CHRB.AUTHORING_ORG_ID AUTHORING_ORG_ID
, RULB.RULE_INFORMATION1 TAX_OWNER
FROM OKC_K_HEADERS_B CHRB
, OKL_K_HEADERS KHRB
, OKC_RULE_GROUPS_B RGPB
, OKC_RULES_B RULB
WHERE CHRB.ID = KHRB.ID
AND CHRB.ID = RGPB.DNZ_CHR_ID
AND CHRB.ID = RULB.DNZ_CHR_ID
AND RGPB.ID = RULB.RGP_ID
AND RULB.RULE_INFORMATION_CATEGORY= 'LATOWN'

Columns