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_SR_PRODUCTS_MAINT_V

Object Details

Object Name:	CS_SR_PRODUCTS_MAINT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_SR_PRODUCTS_MAINT_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	Mandatory	Comments
PRINCIPAL_PARTY_NAME	VARCHAR2	(360)	Yes	Name of principal party
CUSTOMER_PRODUCT_ID	NUMBER		Yes	Unique identifier for a product in the installed base.
CUSTOMER_ID	NUMBER			Identifier of the customer account.
INVENTORY_ITEM_ID	NUMBER		Yes	Product identifier.
MOST_RECENT_FLAG	CHAR	(1)		Flags the most recent of a set of related (i.e., upgraded, etc.) customer products
CURRENT_SERIAL_NUMBER	VARCHAR2	(30)		Serial number of product shipped
TYPE_CODE	VARCHAR2	(30)		Product type
SYSTEM_ID	NUMBER			Identifies the system to which the product belongs
SYSTEM	VARCHAR2	(50)		Name of the System
ORIGINAL_ORDER_DATE	DATE			Order information. Order Date
ORIGINAL_ORDER_NUMBER	NUMBER			Order information. Order Number
INSTALL_SITE_USE_ID	NUMBER			Identifies the location where product is installed
PARENT_CP_ID	VARCHAR2	(0)		Parent customer product identifier
CUSTOMER_PRODUCT_STATUS_ID	NUMBER		Yes	Status identifier of a customer product
REFERENCE_NUMBER	VARCHAR2	(30)	Yes	Unique reference for a customer product
PURCHASE_ORDER_NUM	VARCHAR2	(50)		The purchase order number for this product.
CP_LOT_NUMBER	VARCHAR2	(80)		Customer product lot number
REVISION	VARCHAR2	(15)		Revision of product
PRODUCT_DESCRIPTION	VARCHAR2	(240)		Description of product
SERVICED_STATUS_FLAG	VARCHAR2	(30)	Yes	Flag indicating service status
ORIGINAL_LINE_NUMBER	NUMBER			Order Information. Line number.
SHIPPED_DATE	DATE			The ship date of the product.
QUANTITY	NUMBER		Yes	The quantity shipped.

Query Text

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


SELECT PRINCIPAL_PARTY_NAME
,      CUSTOMER_PRODUCT_ID
,      CUSTOMER_ID
,      INVENTORY_ITEM_ID
,      MOST_RECENT_FLAG
,      CURRENT_SERIAL_NUMBER
,      TYPE_CODE
,      SYSTEM_ID
,      SYSTEM
,      ORIGINAL_ORDER_DATE
,      ORIGINAL_ORDER_NUMBER
,      INSTALL_SITE_USE_ID
,      PARENT_CP_ID
,      CUSTOMER_PRODUCT_STATUS_ID
,      REFERENCE_NUMBER
,      PURCHASE_ORDER_NUM
,      CP_LOT_NUMBER
,      REVISION
,      PRODUCT_DESCRIPTION
,      SERVICED_STATUS_FLAG
,      ORIGINAL_LINE_NUMBER
,      SHIPPED_DATE
,      QUANTITY
FROM APPS.CS_SR_PRODUCTS_MAINT_V;

Dependencies

[top of page]

APPS.CS_SR_PRODUCTS_MAINT_V references the following:

APPS: ASO_I_OE_ORDER_HEADERS_V; ASO_I_OE_ORDER_LINES_V; CSICUMPI_PUB - show dependent code; CS_CP_REVISIONS; CS_CUSTOMER_PRODUCTS_ALL; CS_LOOKUPS; CS_STD - show dependent code; CS_SYSTEMS; FND_GLOBAL - show dependent code; HZ_CUST_ACCOUNTS; HZ_PARTIES; MTL_SYSTEM_ITEMS
PUBLIC: DUAL

APPS.CS_SR_PRODUCTS_MAINT_V is not referenced by any database object