Product: | OKL - Lease and Finance Management |
---|---|
Description: | User interface view for party role pages |
Implementation/DBA Data: | APPS.OKL_LA_K_PARTY_ROLES_UV |
SELECT CPLB.ID ID
, CPLB.CHR_ID CHR_ID
, CPLB.CPL_ID CPL_ID
, CPLB.CLE_ID CLE_ID
, CPLB.RLE_CODE RLE_CODE
, CPLB.DNZ_CHR_ID DNZ_CHR_ID
, CPLB.OBJECT1_ID1 OBJECT1_ID1
, CPLB.OBJECT1_ID2 OBJECT1_ID2
, CPLB.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, FNDV.MEANING ROLE
, KPLB.ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, KPLB.ATTRIBUTE1 ATTRIBUTE1
, KPLB.ATTRIBUTE2 ATTRIBUTE2
, KPLB.ATTRIBUTE3 ATTRIBUTE3
, KPLB.ATTRIBUTE4 ATTRIBUTE4
, KPLB.ATTRIBUTE5 ATTRIBUTE5
, KPLB.ATTRIBUTE6 ATTRIBUTE6
, KPLB.ATTRIBUTE7 ATTRIBUTE7
, KPLB.ATTRIBUTE8 ATTRIBUTE8
, KPLB.ATTRIBUTE9 ATTRIBUTE9
, KPLB.ATTRIBUTE10 ATTRIBUTE10
, KPLB.ATTRIBUTE11 ATTRIBUTE11
, KPLB.ATTRIBUTE12 ATTRIBUTE12
, KPLB.ATTRIBUTE13 ATTRIBUTE13
, KPLB.ATTRIBUTE14 ATTRIBUTE14
, KPLB.ATTRIBUTE15 ATTRIBUTE15
, OKL_VP_JTF_PARTY_NAME_PUB.GET_PARTY_NAME(CPLB.RLE_CODE
, CHR.BUY_OR_SELL
, CPLB.OBJECT1_ID1
, CPLB.OBJECT1_ID2) PARTY_NAME
, CPLT.ALIAS ALIAS
, CPLT.COGNOMEN KNOWN_AS
FROM FND_LOOKUPS FNDV
, OKC_K_PARTY_ROLES_B CPLB
, OKC_K_PARTY_ROLES_TL CPLT
, OKL_K_PARTY_ROLES KPLB
, OKC_K_HEADERS_ALL_B CHR
WHERE CPLB.ID = CPLT.ID
AND CPLB.ID= KPLB.ID (+)
AND CHR.ID = CPLB.CHR_ID
AND CPLT.LANGUAGE = USERENV('LANG')
AND FNDV.LOOKUP_TYPE = 'OKC_ROLE'
AND CPLB.RLE_CODE = FNDV.LOOKUP_CODE