DBA Data[Home] [Help] [Dependency Information]

VIEW: APPS.CS_SR_NEW_ACC_CP_RG_V

Object Details
Object Name: CS_SR_NEW_ACC_CP_RG_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_NEW_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
INSTANCE_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.
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
INVENTORY_REVISION VARCHAR2 (3)
Current revision name
PRODUCT_TYPE VARCHAR2 (30)
Type of product
INSTANCE_STATUS_ID NUMBER
Yes Status identifier of a customer product
CUSTOMER_PRODUCT_STATUS VARCHAR2 (50) Yes Status of a customer product
INSTANCE_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
OBJECT_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
INCIDENT_ALLOWED_FLAG VARCHAR2 (1)
Flag to indicate whether a Service request can be created for a given product
PARTY_ACCOUNT_ID NUMBER

Account id for the product
LOCATION_ID NUMBER

Location Identifier determined by the location type code.
INV_MASTER_ORGANIZATION_ID NUMBER
Yes Organization Identifier for the Installed Base Product.
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.
ORGANIZATION_ID NUMBER
Yes Organization Id of the Installed base instance.
INSTANCE_NAME VARCHAR2 (240)
Description for Item Instance
MAINT_ORGANIZATION_ID NUMBER

Maintenance Organization Id
Query Text

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


SELECT INSTANCE_ID
,      PRODUCT_NAME
,      PRODUCT_DESCRIPTION
,      INVENTORY_ITEM_ID
,      SERIAL_NUMBER
,      SYSTEM_ID
,      SYSTEM_NAME
,      INVENTORY_REVISION
,      PRODUCT_TYPE
,      INSTANCE_STATUS_ID
,      CUSTOMER_PRODUCT_STATUS
,      INSTANCE_NUMBER
,      LOT_NUMBER
,      CUST_PO_NUMBER
,      ORDER_NUMBER
,      OBJECT_ID
,      PLATFORM_ID
,      PLATFORM
,      PLATFORM_VERSION_ID
,      VERSION
,      INCIDENT_ALLOWED_FLAG
,      PARTY_ACCOUNT_ID
,      LOCATION_ID
,      INV_MASTER_ORGANIZATION_ID
,      EXTERNAL_REFERENCE
,      OWNER_PARTY_ID
,      OWNER_PARTY_SOURCE_TABLE
,      LOCATION_TYPE_CODE
,      ORGANIZATION_ID
,      INSTANCE_NAME
,      MAINT_ORGANIZATION_ID
FROM APPS.CS_SR_NEW_ACC_CP_RG_V;

Dependencies

[top of page]

APPS.CS_SR_NEW_ACC_CP_RG_V references the following:

SchemaAPPS
SynonymCSI_II_RELATIONSHIPS
SynonymCSI_INSTANCE_STATUSES
SynonymCSI_ITEM_INSTANCES
SynonymCSI_SYSTEMS_B
SynonymCSI_SYSTEMS_TL
ViewMTL_SYSTEM_ITEMS_VL
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
APPS.CS_SR_NEW_ACC_CP_RG_V is referenced by following:

SchemaAPPS
Package BodyCS_SERVICEREQUEST_UTIL - show dependent code
Package BodyCS_SR_FUL_PKG - show dependent code