VIEW: APPS.OKC_REL_OBJECTS_V

Source

View Text - Preformatted

SELECT rel.id REL_ID,rel.chr_id REL_CHR_ID,rel.cle_id REL_CLE_ID,rel.jtot_object1_code REL_JTOT_OBJECT1_CODE,jtf.name JTF_NAME,rel.object1_id1 REL_OBJECT1_ID1, rel.rty_code REL_RTY_CODE, fnd.meaning FND_MEANING, okc_util.get_name_from_jtfv(rel.jtot_object1_code,object1_id1,object1_id2) DOCUMENT_NUMBER,rel.creation_date CREATION_DATE FROM OKC_K_REL_OBJS_V REL,FND_LOOKUPS FND,JTF_OBJECTS_VL JTF WHERE jtf.object_code = rel.jtot_object1_code and fnd.lookup_code = rel.rty_code and fnd.lookup_type = 'OKC_REL_OBJ'

View Text - HTML Formatted

SELECT REL.ID REL_ID
, REL.CHR_ID REL_CHR_ID
, REL.CLE_ID REL_CLE_ID
, REL.JTOT_OBJECT1_CODE REL_JTOT_OBJECT1_CODE
, JTF.NAME JTF_NAME
, REL.OBJECT1_ID1 REL_OBJECT1_ID1
, REL.RTY_CODE REL_RTY_CODE
, FND.MEANING FND_MEANING
, OKC_UTIL.GET_NAME_FROM_JTFV(REL.JTOT_OBJECT1_CODE
, OBJECT1_ID1
, OBJECT1_ID2) DOCUMENT_NUMBER
, REL.CREATION_DATE CREATION_DATE
FROM OKC_K_REL_OBJS_V REL
, FND_LOOKUPS FND
, JTF_OBJECTS_VL JTF
WHERE JTF.OBJECT_CODE = REL.JTOT_OBJECT1_CODE
AND FND.LOOKUP_CODE = REL.RTY_CODE
AND FND.LOOKUP_TYPE = 'OKC_REL_OBJ'