View: OKL_AM_K_PARTY_ROLES_UV

Product:	OKL - Lease and Finance Management
Description:
Implementation/DBA Data:	APPS.OKL_AM_K_PARTY_ROLES_UV

View Text

SELECT PR.ID ID
, PR.DNZ_CHR_ID DNZ_CHR_ID
, PR.RLE_CODE RLE_CODE
, PR.ROLE ROLE
, PR.JTOT_OBJECT1_CODE JTOT_OBJECT1_CODE
, PR.OBJECT1_ID1 OBJECT1_ID1
, PR.OBJECT1_ID2 OBJECT1_ID2
, JO.NAME JTOT_OBJECT1_NAME
, JO.DESCRIPTION JTOT_OBJECT1_DESCRIPTION
, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_NAME ( PR.JTOT_OBJECT1_CODE
, PR.OBJECT1_ID1
, PR.OBJECT1_ID2) PARTY_NAME
, OKL_AM_UTIL_PVT.GET_JTF_OBJECT_COLUMN ('PARTY_NUMBER'
, PR.JTOT_OBJECT1_CODE
, PR.OBJECT1_ID1
, PR.OBJECT1_ID2) PARTY_NUMBER
FROM OKC_K_PARTY_ROLES_V PR
, JTF_OBJECTS_VL JO
WHERE PR.CLE_ID IS NULL
AND PR.CHR_ID = PR.DNZ_CHR_ID
AND JO.OBJECT_CODE = PR.JTOT_OBJECT1_CODE

Columns