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_ACC_CP_RG_V

Object Details

Object Name:	CS_ACC_CP_RG_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	CS.CS_ACC_CP_RG_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
CUSTOMER_PRODUCT_ID	NUMBER		Yes	Unique identifier for a product in the installed base.
PRODUCT_NAME	VARCHAR2	(40)		Product Name
PRODUCT_DESCRIPTION	VARCHAR2	(240)		Description for the product.
INVENTORY_ITEM_ID	NUMBER		Yes	Product identifier.
CURRENT_SERIAL_NUMBER	VARCHAR2	(30)		Serial number of product shipped
SYSTEM_ID	NUMBER			Identifies the system to which the product belongs
SYSTEM_NAME	VARCHAR2	(50)		System Name
CURRENT_CP_REVISION_ID	VARCHAR2	(3)		Identifies the current revision.
REVISION	VARCHAR2	(15)		Current revision name
PRODUCT_TYPE	VARCHAR2	(30)		Type of product
CUSTOMER_PRODUCT_STATUS_ID	NUMBER		Yes	Status identifier of a customer product
CUSTOMER_PRODUCT_STATUS	VARCHAR2	(50)	Yes	Status of a customer product
REFERENCE_NUMBER	VARCHAR2	(30)	Yes	Unique reference for a customer product
LOT_NUMBER	VARCHAR2	(80)		Lot number for the product
CUST_PO_NUMBER	VARCHAR2	(50)		Customer's Purchase Order Number
ORDER_NUMBER	NUMBER			Original Order Number
CONFIG_ROOT_ID	NUMBER			The customer product ID of the top most parent of the tree that includes the current product
CONFIG_PARENT_ID	NUMBER			The customer product ID of the immediate parent customer product
PLATFORM_ID	NUMBER			Identifier for the platform on which the product is installed
PLATFORM	VARCHAR2	(0)		Platform Name
PLATFORM_VERSION_ID	NUMBER			Applicable only for software products in the installed base. Identifier of the platform version on which this product exists in the installed base.
VERSION	VARCHAR2	(0)		Platform Version name
ORG_ID	NUMBER			Operating unit identifier
INCIDENT_ALLOWED_FLAG	VARCHAR2	(1)		Flag to indicate whether a Service request can be created for a given product
CUSTOMER_ID	NUMBER			Account id for the product
INSTALL_SITE_USE_ID	NUMBER			Install Site Use identifier.

Query Text

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


SELECT CUSTOMER_PRODUCT_ID
,      PRODUCT_NAME
,      PRODUCT_DESCRIPTION
,      INVENTORY_ITEM_ID
,      CURRENT_SERIAL_NUMBER
,      SYSTEM_ID
,      SYSTEM_NAME
,      CURRENT_CP_REVISION_ID
,      REVISION
,      PRODUCT_TYPE
,      CUSTOMER_PRODUCT_STATUS_ID
,      CUSTOMER_PRODUCT_STATUS
,      REFERENCE_NUMBER
,      LOT_NUMBER
,      CUST_PO_NUMBER
,      ORDER_NUMBER
,      CONFIG_ROOT_ID
,      CONFIG_PARENT_ID
,      PLATFORM_ID
,      PLATFORM
,      PLATFORM_VERSION_ID
,      VERSION
,      ORG_ID
,      INCIDENT_ALLOWED_FLAG
,      CUSTOMER_ID
,      INSTALL_SITE_USE_ID
FROM APPS.CS_ACC_CP_RG_V;

Dependencies

[top of page]

APPS.CS_ACC_CP_RG_V references the following:

APPS: CSICUMPI_PUB - show dependent code; CS_CP_REVISIONS; CS_CUSTOMER_PRODUCTS_ALL; CS_CUSTOMER_PRODUCT_STATUSES; CS_LOOKUPS; CS_STD - show dependent code; CS_SYSTEMS; FND_GLOBAL - show dependent code; MTL_SYSTEM_ITEMS_KFV; OE_ORDER_HEADERS_ALL; OE_ORDER_LINES_ALL

APPS.CS_ACC_CP_RG_V is referenced by following:

APPS: CS_SR_FUL_PKG - show dependent code