VIEW: APPS.AST_NOTES_CONTEXTS_V

Source

View Text - Preformatted

SELECT c.note_context_id ,c.jtf_note_id ,c.creation_date ,c.created_by ,c.last_update_date ,c.last_updated_by ,c.last_update_login ,c.note_context_type_id ,c.note_context_type ,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) ,ast_note_package.note_context_info( obj.select_id, obj.select_name, null, obj.from_table, obj.where_clause, c.note_context_type_id) ,ast_note_package.note_context_info( obj.select_id, null, obj.select_details, obj.from_table, obj.where_clause, c.note_context_type_id) ,obj.select_id ,obj.select_name ,obj.select_details ,obj.from_table ,obj.where_clause ,obj.order_by_clause ,objtl.lov_window_title ,objtl.lov_name_title ,objtl.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
, C.JTF_NOTE_ID
, C.CREATION_DATE
, C.CREATED_BY
, C.LAST_UPDATE_DATE
, C.LAST_UPDATED_BY
, C.LAST_UPDATE_LOGIN
, C.NOTE_CONTEXT_TYPE_ID
, C.NOTE_CONTEXT_TYPE
, 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)
, AST_NOTE_PACKAGE.NOTE_CONTEXT_INFO( OBJ.SELECT_ID
, OBJ.SELECT_NAME
, NULL
, OBJ.FROM_TABLE
, OBJ.WHERE_CLAUSE
, C.NOTE_CONTEXT_TYPE_ID)
, AST_NOTE_PACKAGE.NOTE_CONTEXT_INFO( OBJ.SELECT_ID
, NULL
, OBJ.SELECT_DETAILS
, OBJ.FROM_TABLE
, OBJ.WHERE_CLAUSE
, C.NOTE_CONTEXT_TYPE_ID)
, OBJ.SELECT_ID
, OBJ.SELECT_NAME
, OBJ.SELECT_DETAILS
, OBJ.FROM_TABLE
, OBJ.WHERE_CLAUSE
, OBJ.ORDER_BY_CLAUSE
, OBJTL.LOV_WINDOW_TITLE
, OBJTL.LOV_NAME_TITLE
, OBJTL.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')