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: CSP_RS_RESOURCES_V

Product:	CSP - Spares Management
Description:	View of resources with ship to addresses and subinventories assigned
Implementation/DBA Data:	APPS.CSP_RS_RESOURCES_V

View Text

SELECT RCR.RS_CUST_RELATION_ID
, RCR.RESOURCE_TYPE
, JOV.NAME
, RCR.RESOURCE_ID
, CSP_PICK_UTILS.GET_OBJECT_NAME(RCR.RESOURCE_TYPE
, RCR.RESOURCE_ID)
, RCR.CUSTOMER_ID
, RCR.CREATED_BY
, RCR.CREATION_DATE
, RCR.LAST_UPDATED_BY
, RCR.LAST_UPDATE_DATE
, RCR.LAST_UPDATE_LOGIN
, RCR.ATTRIBUTE_CATEGORY
, RCR.ATTRIBUTE1
, RCR.ATTRIBUTE2
, RCR.ATTRIBUTE3
, RCR.ATTRIBUTE4
, RCR.ATTRIBUTE5
, RCR.ATTRIBUTE6
, RCR.ATTRIBUTE7
, RCR.ATTRIBUTE8
, RCR.ATTRIBUTE9
, RCR.ATTRIBUTE10
, RCR.ATTRIBUTE11
, RCR.ATTRIBUTE12
, RCR.ATTRIBUTE13
, RCR.ATTRIBUTE14
, RCR.ATTRIBUTE15
FROM CSP_RS_CUST_RELATIONS RCR
, JTF_OBJECTS_VL JOV
WHERE RCR.RESOURCE_TYPE = JOV.OBJECT_CODE

Columns

Name
RS_CUST_RELATION_ID
RESOURCE_TYPE
RESOURCE_TYPE_MEANING
RESOURCE_ID
RESOURCE_NAME
CUSTOMER_ID
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
ATTRIBUTE_CATEGORY
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15