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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: CSM.CSF_M_SRTASKS_INQ#

Object Details

Object Name:	CSF_M_SRTASKS_INQ#
Object Type:	VIEW
Owner:	CSM
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
CLID$$CS	VARCHAR2	(30)
TASK_ASSIGNMENT_ID	NUMBER	(15)
INCIDENT_ID	NUMBER	(15)
INCIDENT_NUMBER	VARCHAR2	(64)
INSTALL_SITE_ID	NUMBER	(15)
CUSTOMER_PRODUCT_ID	NUMBER	(15)
SR_CUSTOMER_ID	NUMBER	(15)
PROBLEM_CODE	VARCHAR2	(50)
RESOLUTION_CODE	VARCHAR2	(50)
CUSTOMER_PO_NUMBER	VARCHAR2	(50)
SR_SUMMARY	VARCHAR2	(80)
SRTASK_ID	NUMBER
TASK_NUMBER	VARCHAR2	(30)
TASK_TYPE_ID	NUMBER
TASK_NAME	VARCHAR2	(80)
TASK_STATUS_ID	NUMBER
TASK_TYPE_NAME	VARCHAR2	(30)
SCHEDULED_START_DATE	DATE
SCHEDULED_END_DATE	DATE
ACTUAL_START_DATE	DATE
ACTUAL_END_DATE	DATE
TASK_ID	NUMBER
RESOURCE_ID	NUMBER
NAME	VARCHAR2	(30)
IMPORTANCE_LEVEL	NUMBER
INVENTORY_ITEM_ID	NUMBER	(15)
CURRENT_SERIAL_NUMBER	VARCHAR2	(30)
ORG_ID	NUMBER
INV_ORGANIZATION_ID	NUMBER
ITEM_NAME	VARCHAR2	(40)
ITEM_DESCRIPTION	VARCHAR2	(240)
BUSINESS_PROCESS_ID	NUMBER	(15)
SR_LAST_UPDATE_DATE	DATE		Yes
TA_LAST_UPDATE_DATE	DATE		Yes
DMLTYPE$$	VARCHAR2	(1)
SEQNO$$	NUMBER	(10)
TRANID$$	NUMBER	(10)
VERSION$$	NUMBER	(10)

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT CLID$$CS
,      TASK_ASSIGNMENT_ID
,      INCIDENT_ID
,      INCIDENT_NUMBER
,      INSTALL_SITE_ID
,      CUSTOMER_PRODUCT_ID
,      SR_CUSTOMER_ID
,      PROBLEM_CODE
,      RESOLUTION_CODE
,      CUSTOMER_PO_NUMBER
,      SR_SUMMARY
,      SRTASK_ID
,      TASK_NUMBER
,      TASK_TYPE_ID
,      TASK_NAME
,      TASK_STATUS_ID
,      TASK_TYPE_NAME
,      SCHEDULED_START_DATE
,      SCHEDULED_END_DATE
,      ACTUAL_START_DATE
,      ACTUAL_END_DATE
,      TASK_ID
,      RESOURCE_ID
,      NAME
,      IMPORTANCE_LEVEL
,      INVENTORY_ITEM_ID
,      CURRENT_SERIAL_NUMBER
,      ORG_ID
,      INV_ORGANIZATION_ID
,      ITEM_NAME
,      ITEM_DESCRIPTION
,      BUSINESS_PROCESS_ID
,      SR_LAST_UPDATE_DATE
,      TA_LAST_UPDATE_DATE
,      DMLTYPE$$
,      SEQNO$$
,      TRANID$$
,      VERSION$$
FROM CSM.CSF_M_SRTASKS_INQ#;

Dependencies

[top of page]

CSM.CSF_M_SRTASKS_INQ# references the following:

CSM: CSF_M_SRTASKS_INQ

CSM.CSF_M_SRTASKS_INQ# is referenced by following:

APPS: CSF_M_SRTASKS_INQ