View: OKC_REL_OBJECTS_V

Product:	OKC - Contracts Core
Description:
Implementation/DBA Data:	APPS.OKC_REL_OBJECTS_V

View Text

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'

Columns