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: APPS.CS_BRM_3D_SERVICE_REQUEST_V

Object Details

Object Name:	CS_BRM_3D_SERVICE_REQUEST_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_BRM_3D_SERVICE_REQUEST_V
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
RECORD_STATUS	VARCHAR2	(8)	The value is hardcoded. It is 'HISTORIC'.
OBJECT_TYPE	CHAR	(27)	This value is hard coded and the is the name of the view. It is 'CS_BRM_3D_SERVICE_REQUEST_V'.
OBJECT_ID	NUMBER	(15)	This is the same as the Service Request ID (Incident_ID). This is used for internal purposes only.
INCIDENT_ID	NUMBER	(15)	The internal number that uniquely represents a service request. This value is not transparent to the users.
CREATED_BY	NUMBER	(15)	Standard who field, indicates the ID of the person who created the record.
CREATION_DATE	DATE		Standard who field, indicates the date on which the record was created.
LAST_UPDATE_BY	NUMBER	(15)	Standard who field, indicates the ID of the person who last updated the record.
LAST_UPDATE_DATE	DATE		Standard who field, indicates the date on which the record was last updated.
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard who field, indicates the login that was used to update the record.
INCIDENT_STATUS_ID	NUMBER	(15)	The internal ID for the current status of the service request. This is not transparent to the user.
INCIDENT_STATUS_NAME	VARCHAR2	(90)	The current status of the service request.
INCIDENT_TYPE_ID	NUMBER	(15)	The internal ID of the service request type . This is not transparent to the user.
INCIDENT_TYPE_NAME	VARCHAR2	(90)	The type of the service request as defined in the table CS_INCIDENT_TYPES_B.
INCIDENT_URGENCY_ID	NUMBER	(15)	The internal ID for the urgency of the service request. This is not transparent to the user.
INCIDENT_URGENCY_NAME	VARCHAR2	(90)	The urgency of the service request.
INCIDENT_SEVERITY_ID	NUMBER	(15)	The internal ID for the severity of the service request. This is not transparent to the user.
INCIDENT_SEVERITY_NAME	VARCHAR2	(90)	The severity of the service request.
INCIDENT_OWNER_ID	NUMBER	(15)	The internal ID of the owner for this service request. this is not transparent to the users.
INCIDENT_OWNER_NAME	VARCHAR2	(240)	The name of the owner for this service request.
INCIDENT_DATE	DATE		This is the date on which the service request was created. This value need not always be the same as the value in the field creation_date.
EXPECTED_RESOLUTION_DATE	DATE		The date on which the Service request is expected to be resolved. This date depends what kind of warranty and service the customer has taken.
OBLIGATION_DATE	DATE		The date on which the agent is obliged to close the Service request . This date depends what kind of warranty and service the customer has taken.
CLOSE_DATE	DATE		The actual date on which the service request was closed.
SITE_ID	NUMBER		The customer address ID from where the service request has been logged. This value is not transparent to the user.
CUSTOMER_ID	NUMBER	(15)	The customer ID who has logged the service request. This value is not transparent to the user.
COMPANY_NAME	VARCHAR2	(360)	The company name who has logged the service request.
ACCOUNT_NUMBER	VARCHAR2	(30)	The account number of the customer who has logged the service request. This value is transparent to the user.
CUSTOMER_PRODUCT_ID	NUMBER	(15)	The internal number of the product against which the service request has been logged. This value is not transparent to the user.
PRODUCT_NAME	VARCHAR2	(40)	The name of the product against which the service request has been logged.
PRODUCT_DESCRIPITION	VARCHAR2	(240)	A short description of the product against which the service request has been logged.

Query Text

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


SELECT RECORD_STATUS
,      OBJECT_TYPE
,      OBJECT_ID
,      INCIDENT_ID
,      CREATED_BY
,      CREATION_DATE
,      LAST_UPDATE_BY
,      LAST_UPDATE_DATE
,      LAST_UPDATE_LOGIN
,      INCIDENT_STATUS_ID
,      INCIDENT_STATUS_NAME
,      INCIDENT_TYPE_ID
,      INCIDENT_TYPE_NAME
,      INCIDENT_URGENCY_ID
,      INCIDENT_URGENCY_NAME
,      INCIDENT_SEVERITY_ID
,      INCIDENT_SEVERITY_NAME
,      INCIDENT_OWNER_ID
,      INCIDENT_OWNER_NAME
,      INCIDENT_DATE
,      EXPECTED_RESOLUTION_DATE
,      OBLIGATION_DATE
,      CLOSE_DATE
,      SITE_ID
,      CUSTOMER_ID
,      COMPANY_NAME
,      ACCOUNT_NUMBER
,      CUSTOMER_PRODUCT_ID
,      PRODUCT_NAME
,      PRODUCT_DESCRIPITION
FROM APPS.CS_BRM_3D_SERVICE_REQUEST_V;

Dependencies

[top of page]

APPS.CS_BRM_3D_SERVICE_REQUEST_V references the following:

APPS: CS_INCIDENTS_ALL_B; CS_INCIDENTS_AUDIT_B; CS_INCIDENTS_B_SEC; CS_INCIDENT_SEVERITIES_TL; CS_INCIDENT_STATUSES_TL; CS_INCIDENT_TYPES_TL; CS_INCIDENT_URGENCIES_TL; HR_GENERAL - show dependent code; HR_PERSON_NAME - show dependent code; HR_SECURITY - show dependent code; HZ_CUST_ACCOUNTS; HZ_PARTIES; JTF_RS_RESOURCE_EXTNS; MTL_SYSTEM_ITEMS_VL; PER_PEOPLE_F

APPS.CS_BRM_3D_SERVICE_REQUEST_V is not referenced by any database object