View: CS_SR_FULFIL_STATUS_V

Product:	CS - Service
Description:	For a particular Source Object and Source Object Id, this View is used to retrieve the status of a submitted fulfillment request.
Implementation/DBA Data:	APPS.CS_SR_FULFIL_STATUS_V

View Text

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 = 690
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'

Columns