VIEW: APPS.OKL_LA_K_PARTY_ROLES_UV

Source

View Text - Preformatted

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 ,CPLB.ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1 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

View Text - HTML Formatted

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
, CPLB.ORIG_SYSTEM_ID1 ORIG_SYSTEM_ID1
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