Product: | OKL - Lease and Finance Management |
---|---|
Description: | |
Implementation/DBA Data: | APPS.OKL_NOTES_CONTEXTS_UV |
SELECT C.NOTE_CONTEXT_ID NOTE_CONTEXT_ID
, C.JTF_NOTE_ID JTF_NOTE_ID
, C.CREATION_DATE CREATION_DATE
, C.CREATED_BY CREATED_BY
, C.LAST_UPDATE_DATE LAST_UPDATE_DATE
, C.LAST_UPDATED_BY LAST_UPDATED_BY
, C.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, C.NOTE_CONTEXT_TYPE_ID OBJECT_ID
, C.NOTE_CONTEXT_TYPE OBJECT_CODE
, DECODE(C.NOTE_CONTEXT_TYPE
, 'PARTY'
, (SELECT A.MEANING
FROM AR_LOOKUPS A
, HZ_PARTIES P
WHERE P.PARTY_ID = C.NOTE_CONTEXT_TYPE_ID
AND A.LOOKUP_CODE = P.PARTY_TYPE
AND A.LOOKUP_TYPE = 'PARTY_TYPE'
AND A.ENABLED_FLAG = 'Y')
, OBJTL.NAME) OBJECT_CODE_NAME
, OKL_CS_LC_CONTRACT_PVT.NOTE_CONTEXT_INFO( OBJ.SELECT_ID
, OBJ.SELECT_NAME
, OBJ.SELECT_DETAILS
, OBJ.FROM_TABLE
, OBJ.WHERE_CLAUSE
, C.NOTE_CONTEXT_TYPE_ID) OBJECT_ID_NAME
, OBJ.SELECT_ID SELECT_ID
, OBJ.SELECT_NAME SELECT_NAME
, OBJ.SELECT_DETAILS SELECT_DETAILS
, OBJ.FROM_TABLE FROM_TABLE
, OBJ.WHERE_CLAUSE WHERE_CLAUSE
, OBJ.ORDER_BY_CLAUSE ORDER_BY_CLAUSE
, OBJTL.LOV_WINDOW_TITLE LOV_WINDOW_TITLE
, OBJTL.LOV_NAME_TITLE LOV_NAME_TITLE
, OBJTL.LOV_DETAILS_TITLE LOV_DETAILS_TITLE
FROM JTF_NOTE_CONTEXTS C
, JTF_OBJECTS_B OBJ
, JTF_OBJECTS_TL OBJTL
WHERE C.NOTE_CONTEXT_TYPE = OBJ.OBJECT_CODE
AND OBJ.OBJECT_CODE = OBJTL.OBJECT_CODE
AND OBJTL.LANGUAGE = USERENV('LANG')