eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.CS_SR_FULFIL_STATUS_V

Source

View Text - Preformatted


SELECT interact.doc_ref source_code,interact.doc_id source_id, interact.doc_source_object_name request_id, fnd.meaning request_status, ful_req.outcome_desc description, ful_req.submit_dt_tm submit_date from fnd_lookup_values fnd, jtf_ih_activities_v interact, jtf_fm_request_history ful_req WHERE interact.doc_source_object_name = to_char(ful_req.hist_req_id) and ful_req.outcome_code = fnd.lookup_code and LANGUAGE = userenv('LANG') and fnd.VIEW_APPLICATION_ID = 0 and fnd.SECURITY_GROUP_ID =fnd_global.lookup_security_group(FND.LOOKUP_TYPE, FND.VIEW_APPLICATION_ID) and fnd.lookup_type = 'JTF_FM_REQUEST_OUTCOME_CODE'

View Text - HTML Formatted

SELECT INTERACT.DOC_REF SOURCE_CODE
, INTERACT.DOC_ID SOURCE_ID
, INTERACT.DOC_SOURCE_OBJECT_NAME REQUEST_ID
, FND.MEANING REQUEST_STATUS
, FUL_REQ.OUTCOME_DESC DESCRIPTION
, FUL_REQ.SUBMIT_DT_TM SUBMIT_DATE
FROM FND_LOOKUP_VALUES FND
, JTF_IH_ACTIVITIES_V INTERACT
, JTF_FM_REQUEST_HISTORY FUL_REQ
WHERE INTERACT.DOC_SOURCE_OBJECT_NAME = TO_CHAR(FUL_REQ.HIST_REQ_ID)
AND FUL_REQ.OUTCOME_CODE = FND.LOOKUP_CODE
AND LANGUAGE = USERENV('LANG')
AND FND.VIEW_APPLICATION_ID = 0
AND FND.SECURITY_GROUP_ID =FND_GLOBAL.LOOKUP_SECURITY_GROUP(FND.LOOKUP_TYPE
, FND.VIEW_APPLICATION_ID)
AND FND.LOOKUP_TYPE = 'JTF_FM_REQUEST_OUTCOME_CODE'