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

VIEW: APPS.OKX_CUST_PROD_V

Object Details
Object Name: OKX_CUST_PROD_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_CUST_PROD_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
CUSTOMER_ID NUMBER

Identifier of the customer account.
INVENTORY_ITEM_ID NUMBER
Yes Product identifier.
LOT_NUMBER VARCHAR2 (80)
Lot number of product shipped
CREATED_MANUALLY_FLAG VARCHAR2 (1)
Flag indicating whether record was created manually or imported from an "order management" system.
MOST_RECENT_FLAG CHAR (1)
Flags the most recent of a set of related (i.e., upgraded, etc.) customer products
CURRENT_CP_REVISION_I VARCHAR2 (3)
Identifies the current revision.
CURRENT_SERIAL_NUMBER VARCHAR2 (30)
Serial number of product shipped
TYPE_CODE VARCHAR2 (30)
Product type
SYSTEM_ID NUMBER

Identifies the system to which the product belongs
PRODUCT_AGREEMENT_ID NUMBER

Product agreement identifier.
INSTALLATION_DATE DATE

Date of installation of product at customer site
ORIGINAL_ORDER_LINE_I NUMBER

Holds the link to the sales order information.
ORIGINAL_LINE_SERV_DE VARCHAR2 (0)
The identifier of the installation details record from the sales order.
ORIGINAL_NET_AMOUNT NUMBER

The amount of the product in the Installed Base. Maybe different from the amount in the order line in case of splits, etc.
SHIP_TO_SITE_USE_ID NUMBER

Identifies the location to which product was shipped
BILL_TO_SITE_USE_ID NUMBER

Identifies the location to which product was invoiced
INSTALL_SITE_USE_ID NUMBER

Identifies the location where product is installed
QUANTITY NUMBER
Yes Quantity of product.
SHIPPED_FLAG VARCHAR2 (1)
Flag indicating whether product has been shipped
DELIVERED_FLAG VARCHAR2 (0)
Flag indicating whether product has reached the customer
UNIT_OF_MEASURE_CODE VARCHAR2 (3) Yes unit of measure of product
PARENT_CP_ID VARCHAR2 (0)
See table description
CUSTOMER_PRODUCT_STAT NUMBER
Yes Status identifier of a customer product
SHIPPED_DATE DATE

Date product shipped to customer
ORG_ID NUMBER

Operating unit identifier
REFERENCE_NUMBER VARCHAR2 (30) Yes Unique reference for a customer product
RETURN_BY_DATE DATE

The date by which the product should be returned
ACTUAL_RETURNED_DATE DATE

The actual date on which the product was returned
RMA_LINE_ID VARCHAR2 (0)
Identifies the RMA line created for the return of the product
SPLIT_FLAG VARCHAR2 (0)
Flag that gets set if the product has been split from/into another product(s)
PROJECT_ID NUMBER

Project identifier
TASK_ID NUMBER

Task identifier
CONFIG_ENABLED_FLAG CHAR (1)
Determines if Configuration Management is enabled
CONFIG_START_DATE DATE

The date when a configuration type becomes active
CONFIG_END_DATE DATE

The date when a configuration type becomes inactive
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
CONFIG_TYPE VARCHAR2 (30)
The configuration type of the customer product
PLATFORM_VERSION_ID VARCHAR2 (0)
Applicable only for software products in the installed base. Identifier of the platform version on which this product exists in the installed base.
START_DATE_ACTIVE DATE

Effective from
END_DATE_ACTIVE DATE

Effective till
OBJECT_VERSION_NUMBER NUMBER
Yes Sequential number used for database locking control
CONTEXT VARCHAR2 (30)
Descriptive flexfield structure defining column
ORIGINAL_ORDER_CURRENCY_CODE VARCHAR2 (15)
Currency code of the amount of product in Installed Base
PRICING_ATTRIBUTE1 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE2 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE3 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE4 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE5 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE6 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE7 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE8 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE9 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE10 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE11 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE12 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE13 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE14 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE15 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE16 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE17 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE18 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE19 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE20 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE21 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE22 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE23 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE24 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE25 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE26 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE27 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE28 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE29 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE30 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE31 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE32 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE33 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE34 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE35 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE36 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE37 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE38 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE39 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE40 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE41 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE42 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE43 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE44 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE45 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE46 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE47 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE48 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE49 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE50 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE51 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE52 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE53 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE54 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE55 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE56 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE57 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE58 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE59 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE60 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE61 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE62 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE63 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE64 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE65 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE66 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE67 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE68 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE69 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE70 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE71 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE72 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE73 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE74 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE75 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE76 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE77 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE78 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE79 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE80 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE81 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE82 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE83 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE84 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE85 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE86 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE87 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE88 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE89 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE90 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE91 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE92 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE93 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE94 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE95 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE96 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE97 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE98 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE99 VARCHAR2 (150)
Pricing Attribute
PRICING_ATTRIBUTE100 VARCHAR2 (150)
Pricing Attribute
PRICING_CONTEXT VARCHAR2 (30)
Pricing Context
Query Text

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


SELECT CUSTOMER_PRODUCT_ID
,      CUSTOMER_ID
,      INVENTORY_ITEM_ID
,      LOT_NUMBER
,      CREATED_MANUALLY_FLAG
,      MOST_RECENT_FLAG
,      CURRENT_CP_REVISION_I
,      CURRENT_SERIAL_NUMBER
,      TYPE_CODE
,      SYSTEM_ID
,      PRODUCT_AGREEMENT_ID
,      INSTALLATION_DATE
,      ORIGINAL_ORDER_LINE_I
,      ORIGINAL_LINE_SERV_DE
,      ORIGINAL_NET_AMOUNT
,      SHIP_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      INSTALL_SITE_USE_ID
,      QUANTITY
,      SHIPPED_FLAG
,      DELIVERED_FLAG
,      UNIT_OF_MEASURE_CODE
,      PARENT_CP_ID
,      CUSTOMER_PRODUCT_STAT
,      SHIPPED_DATE
,      ORG_ID
,      REFERENCE_NUMBER
,      RETURN_BY_DATE
,      ACTUAL_RETURNED_DATE
,      RMA_LINE_ID
,      SPLIT_FLAG
,      PROJECT_ID
,      TASK_ID
,      CONFIG_ENABLED_FLAG
,      CONFIG_START_DATE
,      CONFIG_END_DATE
,      CONFIG_ROOT_ID
,      CONFIG_PARENT_ID
,      CONFIG_TYPE
,      PLATFORM_VERSION_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      OBJECT_VERSION_NUMBER
,      CONTEXT
,      ORIGINAL_ORDER_CURRENCY_CODE
,      PRICING_ATTRIBUTE1
,      PRICING_ATTRIBUTE2
,      PRICING_ATTRIBUTE3
,      PRICING_ATTRIBUTE4
,      PRICING_ATTRIBUTE5
,      PRICING_ATTRIBUTE6
,      PRICING_ATTRIBUTE7
,      PRICING_ATTRIBUTE8
,      PRICING_ATTRIBUTE9
,      PRICING_ATTRIBUTE10
,      PRICING_ATTRIBUTE11
,      PRICING_ATTRIBUTE12
,      PRICING_ATTRIBUTE13
,      PRICING_ATTRIBUTE14
,      PRICING_ATTRIBUTE15
,      PRICING_ATTRIBUTE16
,      PRICING_ATTRIBUTE17
,      PRICING_ATTRIBUTE18
,      PRICING_ATTRIBUTE19
,      PRICING_ATTRIBUTE20
,      PRICING_ATTRIBUTE21
,      PRICING_ATTRIBUTE22
,      PRICING_ATTRIBUTE23
,      PRICING_ATTRIBUTE24
,      PRICING_ATTRIBUTE25
,      PRICING_ATTRIBUTE26
,      PRICING_ATTRIBUTE27
,      PRICING_ATTRIBUTE28
,      PRICING_ATTRIBUTE29
,      PRICING_ATTRIBUTE30
,      PRICING_ATTRIBUTE31
,      PRICING_ATTRIBUTE32
,      PRICING_ATTRIBUTE33
,      PRICING_ATTRIBUTE34
,      PRICING_ATTRIBUTE35
,      PRICING_ATTRIBUTE36
,      PRICING_ATTRIBUTE37
,      PRICING_ATTRIBUTE38
,      PRICING_ATTRIBUTE39
,      PRICING_ATTRIBUTE40
,      PRICING_ATTRIBUTE41
,      PRICING_ATTRIBUTE42
,      PRICING_ATTRIBUTE43
,      PRICING_ATTRIBUTE44
,      PRICING_ATTRIBUTE45
,      PRICING_ATTRIBUTE46
,      PRICING_ATTRIBUTE47
,      PRICING_ATTRIBUTE48
,      PRICING_ATTRIBUTE49
,      PRICING_ATTRIBUTE50
,      PRICING_ATTRIBUTE51
,      PRICING_ATTRIBUTE52
,      PRICING_ATTRIBUTE53
,      PRICING_ATTRIBUTE54
,      PRICING_ATTRIBUTE55
,      PRICING_ATTRIBUTE56
,      PRICING_ATTRIBUTE57
,      PRICING_ATTRIBUTE58
,      PRICING_ATTRIBUTE59
,      PRICING_ATTRIBUTE60
,      PRICING_ATTRIBUTE61
,      PRICING_ATTRIBUTE62
,      PRICING_ATTRIBUTE63
,      PRICING_ATTRIBUTE64
,      PRICING_ATTRIBUTE65
,      PRICING_ATTRIBUTE66
,      PRICING_ATTRIBUTE67
,      PRICING_ATTRIBUTE68
,      PRICING_ATTRIBUTE69
,      PRICING_ATTRIBUTE70
,      PRICING_ATTRIBUTE71
,      PRICING_ATTRIBUTE72
,      PRICING_ATTRIBUTE73
,      PRICING_ATTRIBUTE74
,      PRICING_ATTRIBUTE75
,      PRICING_ATTRIBUTE76
,      PRICING_ATTRIBUTE77
,      PRICING_ATTRIBUTE78
,      PRICING_ATTRIBUTE79
,      PRICING_ATTRIBUTE80
,      PRICING_ATTRIBUTE81
,      PRICING_ATTRIBUTE82
,      PRICING_ATTRIBUTE83
,      PRICING_ATTRIBUTE84
,      PRICING_ATTRIBUTE85
,      PRICING_ATTRIBUTE86
,      PRICING_ATTRIBUTE87
,      PRICING_ATTRIBUTE88
,      PRICING_ATTRIBUTE89
,      PRICING_ATTRIBUTE90
,      PRICING_ATTRIBUTE91
,      PRICING_ATTRIBUTE92
,      PRICING_ATTRIBUTE93
,      PRICING_ATTRIBUTE94
,      PRICING_ATTRIBUTE95
,      PRICING_ATTRIBUTE96
,      PRICING_ATTRIBUTE97
,      PRICING_ATTRIBUTE98
,      PRICING_ATTRIBUTE99
,      PRICING_ATTRIBUTE100
,      PRICING_CONTEXT
FROM APPS.OKX_CUST_PROD_V;

Dependencies

[top of page]

APPS.OKX_CUST_PROD_V references the following:

SchemaAPPS
PL/SQL PackageCSICUMPI_PUB - show dependent code
SynonymCS_CUSTOMER_PRODUCTS_ALL
APPS.OKX_CUST_PROD_V is referenced by following:

SchemaAPPS
Package BodyOKS_AUTO_REMINDER - show dependent code
Package BodyOKS_OKSNREPD_XMLP_PKG - show dependent code