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.CSP_RESOURCE_INV_LOC_V

Object Details

Object Name:	CSP_RESOURCE_INV_LOC_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CSP.CSP_RESOURCE_INV_LOC_V
Subobject Name:
Status:	VALID

View Type

A public view which may be useful for custom reporting or other data
requirements.

The view is used to view all the move orders and their statuses for a given Service Request and/or Task Id.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
RESOURCE_ID	NUMBER	(35)	Yes	Resource identifier
RESOURCE_TYPE	VARCHAR2	(30)	Yes	Resrouce type
SUBINVENTORY_CODE	VARCHAR2	(10)	Yes	Subinventory name
INV_LOC_TYPE	VARCHAR2	(30)	Yes	Condition type of subinventory
ORGANIZATION_ID	NUMBER	(35)	Yes	Organization identifier
EFFECTIVE_DATE_START	DATE			Effective from this date
EFFECTIVE_DATE_END	DATE			Effective through this date

Query Text

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


SELECT RESOURCE_ID
,      RESOURCE_TYPE
,      SUBINVENTORY_CODE
,      INV_LOC_TYPE
,      ORGANIZATION_ID
,      EFFECTIVE_DATE_START
,      EFFECTIVE_DATE_END
FROM APPS.CSP_RESOURCE_INV_LOC_V;

Dependencies

[top of page]

APPS.CSP_RESOURCE_INV_LOC_V references the following:

APPS: CSP_INV_LOC_ASSIGNMENTS; CSP_SEC_INVENTORIES

APPS.CSP_RESOURCE_INV_LOC_V is not referenced by any database object