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.

[Home] [Help]

View: FND_SVC_COMP_REQUESTS_H_V

Product:	FND - Application Object Library
Description:	FND_SVC_COMP_REQUESTS_H_V
Implementation/DBA Data:	APPS.FND_SVC_COMP_REQUESTS_H_V

View Text

SELECT CRH.COMPLETION_DATE
, CRH.COMPONENT_ID
, CRH.COMPONENT_NAME
, CRH.COMPONENT_STATUS
, CRH.COMPONENT_TYPE
, CRH.CONTAINER_NAME
, CRH.CONTAINER_TYPE
, CRH.CREATED_BY
, CRH.EVENT_NAME
, CRH.EVENT_PARAMS
, CRH.OBJECT_VERSION_NUMBER
, CRH.REQUEST_HISTORY_ID
, CRH.REQUEST_STATUS
, CRH.REQUESTED_BY_USER
FROM FND_SVC_COMP_REQUESTS_H CRH

Columns

Name
COMPLETION_DATE
COMPONENT_ID
COMPONENT_NAME
COMPONENT_STATUS
COMPONENT_TYPE
CONTAINER_NAME
CONTAINER_TYPE
CREATED_BY
EVENT_NAME
EVENT_PARAMS
OBJECT_VERSION_NUMBER
REQUEST_HISTORY_ID
REQUEST_STATUS
REQUESTED_BY_USER