VIEW: APPS.OKL_AM_K_PARTY_ROLES_UV

Source

View Text - Preformatted

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

View Text - HTML Formatted

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