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

VIEW: APPS.CS_SR_NEW_FIND_PROD_MAINT_V

Object Details
Object Name: CS_SR_NEW_FIND_PROD_MAINT_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCS.CS_SR_NEW_FIND_PROD_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
CUSTOMER_PRODUCT_ID NUMBER
Yes Unique identifier for a product in the installed base.
CUSTOMER_ID NUMBER (15) Yes 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
CURRENT_SERIAL_NUMBER VARCHAR2 (30)
Serial number of product shipped
RELATIONSHIP_TYPE_CODE VARCHAR2 (30) Yes
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
INSTALL_SITE_USE_ID VARCHAR2 (0)
Identifies the location where product is installed.
PARENT_CP_ID NUMBER

Parent customer product identifier
CUSTOMER_PRODUCT_STATUS_ID NUMBER
Yes Status identifier of a customer product
REFERENCE_NUMBER VARCHAR2 (30) Yes Unique reference for a customer product
PURCHASE_ORDER_NUM VARCHAR2 (50)
The purchase order number for this product.
CP_LOT_NUMBER VARCHAR2 (80)
Customer product lot number
REVISION VARCHAR2 (3)
Revision of product
INSTANCE_NAME VARCHAR2 (240)
Instance Name
PRODUCT_DESCRIPTION VARCHAR2 (240)
Description of product
SERVICED_STATUS_FLAG CHAR (1)
Flag indicating service status
ORIGINAL_LINE_NUMBER NUMBER

Order Information. Line number.
SHIPPED_DATE DATE

The ship date of the product.
QUANTITY NUMBER
Yes The quantity shipped.
EXTERNAL_REFERENCE VARCHAR2 (30)
This column stores the tag number of an installed base item.
LOCATION_TYPE_CODE VARCHAR2 (30)
The Location type code for the install base location identifier.
ACCOUNT_ID NUMBER

Account identifier.
ACCOUNT_NUMBER VARCHAR2 (30)
store account number
ORGANIZATION_ID NUMBER
Yes Organization Id of the inventory item.
LOCATION_ID NUMBER

Identifies the location where product is installed.
PRODUCT_NAME VARCHAR2 (40)
Incident Location Type Code - HZ_PARTY_SITES or HZ_LOCATIONS or NULL.
CUSTOMER_NUMBER VARCHAR2 (30) Yes
CURRENT_ADDRESS VARCHAR2 (963)
Current Address
Query Text

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


SELECT PRINCIPAL_PARTY_NAME
,      CUSTOMER_PRODUCT_ID
,      CUSTOMER_ID
,      INVENTORY_ITEM_ID
,      MOST_RECENT_FLAG
,      CURRENT_SERIAL_NUMBER
,      RELATIONSHIP_TYPE_CODE
,      TYPE_CODE
,      SYSTEM_ID
,      SYSTEM
,      ORIGINAL_ORDER_DATE
,      ORIGINAL_ORDER_NUMBER
,      INSTALL_SITE_USE_ID
,      PARENT_CP_ID
,      CUSTOMER_PRODUCT_STATUS_ID
,      REFERENCE_NUMBER
,      PURCHASE_ORDER_NUM
,      CP_LOT_NUMBER
,      REVISION
,      INSTANCE_NAME
,      PRODUCT_DESCRIPTION
,      SERVICED_STATUS_FLAG
,      ORIGINAL_LINE_NUMBER
,      SHIPPED_DATE
,      QUANTITY
,      EXTERNAL_REFERENCE
,      LOCATION_TYPE_CODE
,      ACCOUNT_ID
,      ACCOUNT_NUMBER
,      ORGANIZATION_ID
,      LOCATION_ID
,      PRODUCT_NAME
,      CUSTOMER_NUMBER
,      CURRENT_ADDRESS
FROM APPS.CS_SR_NEW_FIND_PROD_MAINT_V;

Dependencies

[top of page]

APPS.CS_SR_NEW_FIND_PROD_MAINT_V references the following:

SchemaAPPS
SynonymCSI_INSTANCE_STATUSES
SynonymCSI_IP_ACCOUNTS
SynonymCSI_ITEM_INSTANCES
SynonymCSI_I_PARTIES
SynonymCSI_SYSTEMS_B
SynonymCSI_SYSTEMS_TL
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_LOCATIONS
SynonymHZ_PARTIES
SynonymHZ_PARTY_SITES
ViewMTL_SYSTEM_ITEMS_VL
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL

APPS.CS_SR_NEW_FIND_PROD_MAINT_V is not referenced by any database object