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: ViewCS.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:

SchemaAPPS
PL/SQL PackageCSICUMPI_PUB - show dependent code
SynonymCS_CP_REVISIONS
SynonymCS_CUSTOMER_PRODUCTS_ALL
SynonymCS_CUSTOMER_PRODUCT_STATUSES
ViewCS_LOOKUPS
PL/SQL PackageCS_STD - show dependent code
SynonymCS_SYSTEMS
PL/SQL PackageFND_GLOBAL - show dependent code
SynonymMTL_SYSTEM_ITEMS_KFV
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
APPS.CS_ACC_CP_RG_V is referenced by following:

SchemaAPPS
Package BodyCS_SR_FUL_PKG - show dependent code