[Home] [Help]
View: OKL_SEC_BUYBACK_CONTRACTS_UV
View Text
SELECT HZPB.PARTY_ID CUST_OBJECT1_ID1
, HZPB.PARTY_NAME LESSEE
, CHRB.ID DNZ_CHR_ID
, CHRB.CONTRACT_NUMBER
, CHRT.SHORT_DESCRIPTION
, KHRB.DEAL_TYPE BOOK_CLASS_CODE
, FNDB.MEANING BOOK_CLASS
, KHRB.PDT_ID PDT_ID
, PDTV.NAME PRODUCT
, CHRB.START_DATE START_DATE
, CHRB.END_DATE END_DATE
, CHRB.CURRENCY_CODE CURRENCY_CODE
, CHRB.ORG_ID
FROM OKC_K_HEADERS_B CHRB
, OKC_K_HEADERS_TL CHRT
, OKC_K_PARTY_ROLES_B CPLB
, HZ_PARTIES HZPB
, OKL_K_HEADERS KHRB
, OKL_PRODUCTS PDTV
, FND_LOOKUPS FNDB
WHERE CHRB.ID = CHRT.ID
AND CHRT.LANGUAGE = USERENV('LANG')
AND CHRB.ID = KHRB.ID
AND CPLB.DNZ_CHR_ID = CHRB.ID
AND CPLB.OBJECT1_ID1 = HZPB.PARTY_ID
AND CPLB.OBJECT1_ID2 = '#'
AND CPLB.RLE_CODE = 'LESSEE'
AND KHRB.PDT_ID = PDTV.ID
AND FNDB.LOOKUP_TYPE = 'OKL_BOOK_CLASS'
AND FNDB.LOOKUP_CODE = KHRB.DEAL_TYPE
AND EXISTS ( SELECT 1
FROM OKL_POOL_CONTENTS POCB
WHERE POCB.KHR_ID = CHRB.ID
AND POCB.STATUS_CODE = 'ACTIVE')
Columns
Name |
CUST_OBJECT1_ID1 |
LESSEE |
DNZ_CHR_ID |
CONTRACT_NUMBER |
SHORT_DESCRIPTION |
BOOK_CLASS_CODE |
BOOK_CLASS |
PDT_ID |
PRODUCT |
START_DATE |
END_DATE |
CURRENCY_CODE |
ORG_ID |