VIEW: APPS.OKL_NOTES_CONTEXTS_UV

Source

View Text - Preformatted

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')

View Text - HTML Formatted

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')