[Home] [Help]
View: OKL_CS_PROCESS_TMPLTS_UV
View Text
SELECT PTMV.ID ID
, PTMV.ORG_ID ORG_ID
, PTMV.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, PTMV.PTM_CODE PTM_CODE
, PTMV.JTF_AMV_ITEM_ID JTF_AMV_ITEM_ID
, PTMV.EMAIL_SUBJECT_LINE EMAIL_SUBJECT_LINE
, PTMV.START_DATE START_DATE
, PTMV.END_DATE END_DATE
, FND.MEANING PROCESS
, AMV.ITEM_NAME TEMPLATE
, OKL_UTIL.GET_REC_STATUS(PTMV.START_DATE
, PTMV.END_DATE) STATUS
, UPPER(FND.MEANING) UPPER_PROCESS
, UPPER(AMV.ITEM_NAME) UPPER_TEMPLATE
FROM OKL_PROCESS_TMPLTS_V PTMV
, JTF_AMV_ITEMS_VL AMV
, FND_LOOKUPS FND
WHERE FND.LOOKUP_TYPE = 'OKL_PROCESSES'
AND PTMV.PTM_CODE = FND.LOOKUP_CODE
AND PTMV.JTF_AMV_ITEM_ID = AMV.ITEM_ID
Columns
Name |
ID |
ORG_ID |
OBJECT_VERSION_NUMBER |
PTM_CODE |
JTF_AMV_ITEM_ID |
EMAIL_SUBJECT_LINE |
START_DATE |
END_DATE |
PROCESS |
TEMPLATE |
STATUS |
UPPER_PROCESS |
UPPER_TEMPLATE |