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_NEW_PRODUCTS_MAINT_V

Object Details

Object Name:	CS_SR_NEW_PRODUCTS_MAINT_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_SR_NEW_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
INSTANCE_ID	NUMBER		Yes	Unique identifier for a product in the installed base.
PARTY_ACCOUNT_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
SERIAL_NUMBER	VARCHAR2	(30)		Serial number of product shipped
INSTANCE_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
LOCATION_ID	NUMBER			Identifies the location where product is installed
INSTANCE_STATUS_ID	NUMBER		Yes	Status identifier of a customer product
INSTANCE_NUMBER	VARCHAR2	(30)	Yes	Unique reference for a customer product
PURCHASE_ORDER_NUMBER	VARCHAR2	(50)		The purchase order number for this product.
LOT_NUMBER	VARCHAR2	(80)		Customer product lot number
INVENTORY_REVISION	VARCHAR2	(3)		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.
ACTUAL_SHIPMENT_DATE	DATE			The actual ship date of the product.
QUANTITY	NUMBER		Yes	The quantity shipped.
CP_STATUS	VARCHAR2	(50)	Yes	Status of Product
ACCOUNT_NUMBER	VARCHAR2	(30)	Yes	Account number
EXTERNAL_REFERENCE	VARCHAR2	(30)		This column stores the tag number of an installed base item.
OWNER_PARTY_ID	NUMBER			Party owner identifier. It is the same as the installed base customer identifier.
OWNER_PARTY_SOURCE_TABLE	VARCHAR2	(30)		The table source of the customer identifier.
LOCATION_TYPE_CODE	VARCHAR2	(30)		The Location type code for the install base location identifier.

Query Text

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


SELECT PRINCIPAL_PARTY_NAME
,      INSTANCE_ID
,      PARTY_ACCOUNT_ID
,      INVENTORY_ITEM_ID
,      MOST_RECENT_FLAG
,      SERIAL_NUMBER
,      INSTANCE_TYPE_CODE
,      SYSTEM_ID
,      SYSTEM
,      ORIGINAL_ORDER_DATE
,      ORIGINAL_ORDER_NUMBER
,      LOCATION_ID
,      INSTANCE_STATUS_ID
,      INSTANCE_NUMBER
,      PURCHASE_ORDER_NUMBER
,      LOT_NUMBER
,      INVENTORY_REVISION
,      PRODUCT_DESCRIPTION
,      SERVICED_STATUS_FLAG
,      ORIGINAL_LINE_NUMBER
,      ACTUAL_SHIPMENT_DATE
,      QUANTITY
,      CP_STATUS
,      ACCOUNT_NUMBER
,      EXTERNAL_REFERENCE
,      OWNER_PARTY_ID
,      OWNER_PARTY_SOURCE_TABLE
,      LOCATION_TYPE_CODE
FROM APPS.CS_SR_NEW_PRODUCTS_MAINT_V;

Dependencies

[top of page]

APPS.CS_SR_NEW_PRODUCTS_MAINT_V references the following:

APPS: ASO_I_OE_ORDER_HEADERS_V; ASO_I_OE_ORDER_LINES_V; CSI_INSTANCE_STATUSES; CSI_ITEM_INSTANCES; CSI_SYSTEMS_TL; CS_LOOKUPS; CS_STD - show dependent code; FND_GLOBAL - show dependent code; HZ_CUST_ACCOUNTS; HZ_PARTIES; MTL_SYSTEM_ITEMS

APPS.CS_SR_NEW_PRODUCTS_MAINT_V is not referenced by any database object