[Home] [Help]
View: OKL_POOL_CUSTOMERS_UV
Product: | OKL - Lease and Finance Management |
Description: | Securitization - Pool Customers UI view |
Implementation/DBA Data: |
APPS.OKL_POOL_CUSTOMERS_UV
|
View Text
SELECT CPLB.DNZ_CHR_ID DNZ_CHR_ID
, HZPB.PARTY_ID CUST_OBJECT1_ID1
, HZPB.PARTY_NAME LESSEE
, HZPB.SIC_CODE SIC_CODE
FROM OKC_K_PARTY_ROLES_B CPLB
, HZ_PARTIES HZPB
WHERE CPLB.OBJECT1_ID1 = HZPB.PARTY_ID
AND CPLB.OBJECT1_ID2 = '#'
AND CPLB.RLE_CODE = 'LESSEE'
Columns
Name |
DNZ_CHR_ID |
CUST_OBJECT1_ID1 |
LESSEE |
SIC_CODE |