Product: | AST - TeleSales |
---|---|
Description: | |
Implementation/DBA Data: | APPS.AST_NOTES_CONTEXTS_V |
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')