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


VIEW: APPS.CS_SR_NEW_ACC_CP_RG2_V

Object Details
Object Name: CS_SR_NEW_ACC_CP_RG2_V
Object Type: VIEW
Owner: APPS
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
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
,      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_RG2_V;

Dependencies

[top of page]

APPS.CS_SR_NEW_ACC_CP_RG2_V references the following:

SchemaAPPS
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_RG2_V is not referenced by any database object