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

VIEW: APPS.OKX_CUSTOMER_PRODUCTS_V

Object Details
Object Name: OKX_CUSTOMER_PRODUCTS_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewOKX.OKX_CUSTOMER_PRODUCTS_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
ID1 NUMBER
Yes Unique identifier for a product in the installed base
ID2 CHAR (1)
(Multi-part) Primary Key
NAME VARCHAR2 (240)
Key flexfield segment
DESCRIPTION VARCHAR2 (40)
Item translated description
STATUS VARCHAR2 (1)
Status
INVENTORY_ITEM_ID NUMBER
Yes Product identifier
ORGANIZATION_ID NUMBER
Yes Organization identifier
PRIMARY_UOM_CODE VARCHAR2 (3)
Primary unit of measure code
CUSTOMER_ID NUMBER

Customer identifier
INSTALL_SITE_USE_ID NUMBER

Identifies the location where product is installed
SYSTEM_ID NUMBER

Identifies the system to which the product belongs
QUANTITY NUMBER
Yes Sales order information: quantity of product
LOT_NUMBER VARCHAR2 (80)
Lot number of product shipped
CURRENT_SERIAL_NUMBER VARCHAR2 (30)
Serial number of product shipped
REFERENCE_NUMBER VARCHAR2 (30) Yes Unique reference for a customer product
UNIT_OF_MEASURE_CODE VARCHAR2 (3) Yes Sales order information: unit of measure of product
UNIT_OF_MEASURE VARCHAR2 (25)
ORG_ID NUMBER

Operating unit identifier
CONFIG_PARENT_ID NUMBER

The customer product ID of the immediate parent customer product
START_DATE_ACTIVE DATE

Effective from
END_DATE_ACTIVE DATE

Effective till
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_ID VARCHAR2 (3)
Identifies the current revision.
TYPE_CODE VARCHAR2 (30)
Product type
PRODUCT_AGREEMENT_ID NUMBER

Product agreement identifier.
INSTALLATION_DATE DATE

Date of installation of product at customer site
ORIGINAL_ORDER_LINE_ID NUMBER

Holds the link to the sales order information.
ORIGINAL_LINE_SERV_DETAIL_ID 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
SHIPPED_FLAG VARCHAR2 (1)
Flag indicating whether product has been shipped
DELIVERED_FLAG VARCHAR2 (0)
Flag indicating whether product has reached the customer
PARENT_CP_ID VARCHAR2 (0)
See table description
CUSTOMER_PRODUCT_STATUS_ID NUMBER
Yes Status identifier of a customer product
SHIPPED_DATE DATE

Date product shipped to customer
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)
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_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.
CONTEXT VARCHAR2 (30)
Descriptive flexfield structure defining column
ORIGINAL_ORDER_CURRENCY_CODE VARCHAR2 (15)
PRICING_ATTRIBUTE1 VARCHAR2 (150)
PRICING_ATTRIBUTE2 VARCHAR2 (150)
PRICING_ATTRIBUTE3 VARCHAR2 (150)
PRICING_ATTRIBUTE4 VARCHAR2 (150)
PRICING_ATTRIBUTE5 VARCHAR2 (150)
PRICING_ATTRIBUTE6 VARCHAR2 (150)
PRICING_ATTRIBUTE7 VARCHAR2 (150)
PRICING_ATTRIBUTE8 VARCHAR2 (150)
PRICING_ATTRIBUTE9 VARCHAR2 (150)
PRICING_ATTRIBUTE10 VARCHAR2 (150)
PRICING_ATTRIBUTE11 VARCHAR2 (150)
PRICING_ATTRIBUTE12 VARCHAR2 (150)
PRICING_ATTRIBUTE13 VARCHAR2 (150)
PRICING_ATTRIBUTE14 VARCHAR2 (150)
PRICING_ATTRIBUTE15 VARCHAR2 (150)
PRICING_ATTRIBUTE16 VARCHAR2 (150)
PRICING_ATTRIBUTE17 VARCHAR2 (150)
PRICING_ATTRIBUTE18 VARCHAR2 (150)
PRICING_ATTRIBUTE19 VARCHAR2 (150)
PRICING_ATTRIBUTE20 VARCHAR2 (150)
PRICING_ATTRIBUTE21 VARCHAR2 (150)
PRICING_ATTRIBUTE22 VARCHAR2 (150)
PRICING_ATTRIBUTE23 VARCHAR2 (150)
PRICING_ATTRIBUTE24 VARCHAR2 (150)
PRICING_ATTRIBUTE25 VARCHAR2 (150)
PRICING_ATTRIBUTE26 VARCHAR2 (150)
PRICING_ATTRIBUTE27 VARCHAR2 (150)
PRICING_ATTRIBUTE28 VARCHAR2 (150)
PRICING_ATTRIBUTE29 VARCHAR2 (150)
PRICING_ATTRIBUTE30 VARCHAR2 (150)
PRICING_ATTRIBUTE31 VARCHAR2 (150)
PRICING_ATTRIBUTE32 VARCHAR2 (150)
PRICING_ATTRIBUTE33 VARCHAR2 (150)
PRICING_ATTRIBUTE34 VARCHAR2 (150)
PRICING_ATTRIBUTE35 VARCHAR2 (150)
PRICING_ATTRIBUTE36 VARCHAR2 (150)
PRICING_ATTRIBUTE37 VARCHAR2 (150)
PRICING_ATTRIBUTE38 VARCHAR2 (150)
PRICING_ATTRIBUTE39 VARCHAR2 (150)
PRICING_ATTRIBUTE40 VARCHAR2 (150)
PRICING_ATTRIBUTE41 VARCHAR2 (150)
PRICING_ATTRIBUTE42 VARCHAR2 (150)
PRICING_ATTRIBUTE43 VARCHAR2 (150)
PRICING_ATTRIBUTE44 VARCHAR2 (150)
PRICING_ATTRIBUTE45 VARCHAR2 (150)
PRICING_ATTRIBUTE46 VARCHAR2 (150)
PRICING_ATTRIBUTE47 VARCHAR2 (150)
PRICING_ATTRIBUTE48 VARCHAR2 (150)
PRICING_ATTRIBUTE49 VARCHAR2 (150)
PRICING_ATTRIBUTE50 VARCHAR2 (150)
PRICING_ATTRIBUTE51 VARCHAR2 (150)
PRICING_ATTRIBUTE52 VARCHAR2 (150)
PRICING_ATTRIBUTE53 VARCHAR2 (150)
PRICING_ATTRIBUTE54 VARCHAR2 (150)
PRICING_ATTRIBUTE55 VARCHAR2 (150)
PRICING_ATTRIBUTE56 VARCHAR2 (150)
PRICING_ATTRIBUTE57 VARCHAR2 (150)
PRICING_ATTRIBUTE58 VARCHAR2 (150)
PRICING_ATTRIBUTE59 VARCHAR2 (150)
PRICING_ATTRIBUTE60 VARCHAR2 (150)
PRICING_ATTRIBUTE61 VARCHAR2 (150)
PRICING_ATTRIBUTE62 VARCHAR2 (150)
PRICING_ATTRIBUTE63 VARCHAR2 (150)
PRICING_ATTRIBUTE64 VARCHAR2 (150)
PRICING_ATTRIBUTE65 VARCHAR2 (150)
PRICING_ATTRIBUTE66 VARCHAR2 (150)
PRICING_ATTRIBUTE67 VARCHAR2 (150)
PRICING_ATTRIBUTE68 VARCHAR2 (150)
PRICING_ATTRIBUTE69 VARCHAR2 (150)
PRICING_ATTRIBUTE70 VARCHAR2 (150)
PRICING_ATTRIBUTE71 VARCHAR2 (150)
PRICING_ATTRIBUTE72 VARCHAR2 (150)
PRICING_ATTRIBUTE73 VARCHAR2 (150)
PRICING_ATTRIBUTE74 VARCHAR2 (150)
PRICING_ATTRIBUTE75 VARCHAR2 (150)
PRICING_ATTRIBUTE76 VARCHAR2 (150)
PRICING_ATTRIBUTE77 VARCHAR2 (150)
PRICING_ATTRIBUTE78 VARCHAR2 (150)
PRICING_ATTRIBUTE79 VARCHAR2 (150)
PRICING_ATTRIBUTE80 VARCHAR2 (150)
PRICING_ATTRIBUTE81 VARCHAR2 (150)
PRICING_ATTRIBUTE82 VARCHAR2 (150)
PRICING_ATTRIBUTE83 VARCHAR2 (150)
PRICING_ATTRIBUTE84 VARCHAR2 (150)
PRICING_ATTRIBUTE85 VARCHAR2 (150)
PRICING_ATTRIBUTE86 VARCHAR2 (150)
PRICING_ATTRIBUTE87 VARCHAR2 (150)
PRICING_ATTRIBUTE88 VARCHAR2 (150)
PRICING_ATTRIBUTE89 VARCHAR2 (150)
PRICING_ATTRIBUTE90 VARCHAR2 (150)
PRICING_ATTRIBUTE91 VARCHAR2 (150)
PRICING_ATTRIBUTE92 VARCHAR2 (150)
PRICING_ATTRIBUTE93 VARCHAR2 (150)
PRICING_ATTRIBUTE94 VARCHAR2 (150)
PRICING_ATTRIBUTE95 VARCHAR2 (150)
PRICING_ATTRIBUTE96 VARCHAR2 (150)
PRICING_ATTRIBUTE97 VARCHAR2 (150)
PRICING_ATTRIBUTE98 VARCHAR2 (150)
PRICING_ATTRIBUTE99 VARCHAR2 (150)
PRICING_ATTRIBUTE100 VARCHAR2 (150)
PRICING_CONTEXT VARCHAR2 (30)
Query Text

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


SELECT ID1
,      ID2
,      NAME
,      DESCRIPTION
,      STATUS
,      INVENTORY_ITEM_ID
,      ORGANIZATION_ID
,      PRIMARY_UOM_CODE
,      CUSTOMER_ID
,      INSTALL_SITE_USE_ID
,      SYSTEM_ID
,      QUANTITY
,      LOT_NUMBER
,      CURRENT_SERIAL_NUMBER
,      REFERENCE_NUMBER
,      UNIT_OF_MEASURE_CODE
,      UNIT_OF_MEASURE
,      ORG_ID
,      CONFIG_PARENT_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      CREATED_MANUALLY_FLAG
,      MOST_RECENT_FLAG
,      CURRENT_CP_REVISION_ID
,      TYPE_CODE
,      PRODUCT_AGREEMENT_ID
,      INSTALLATION_DATE
,      ORIGINAL_ORDER_LINE_ID
,      ORIGINAL_LINE_SERV_DETAIL_ID
,      ORIGINAL_NET_AMOUNT
,      SHIP_TO_SITE_USE_ID
,      BILL_TO_SITE_USE_ID
,      SHIPPED_FLAG
,      DELIVERED_FLAG
,      PARENT_CP_ID
,      CUSTOMER_PRODUCT_STATUS_ID
,      SHIPPED_DATE
,      RETURN_BY_DATE
,      ACTUAL_RETURNED_DATE
,      RMA_LINE_ID
,      SPLIT_FLAG
,      CONFIG_ENABLED_FLAG
,      CONFIG_START_DATE
,      CONFIG_END_DATE
,      CONFIG_ROOT_ID
,      CONFIG_TYPE
,      PLATFORM_VERSION_ID
,      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_CUSTOMER_PRODUCTS_V;

Dependencies

[top of page]

APPS.OKX_CUSTOMER_PRODUCTS_V references the following:

SchemaAPPS
PL/SQL PackageCSICUMPI_PUB - show dependent code
SynonymCS_CUSTOMER_PRODUCTS_ALL
ViewMTL_SYSTEM_ITEMS_B_KFV
SynonymMTL_SYSTEM_ITEMS_TL
SynonymMTL_UNITS_OF_MEASURE_TL
APPS.OKX_CUSTOMER_PRODUCTS_V is referenced by following:

SchemaAPPS
Package BodyOKC_OC_INT_KTQ_PVT - show dependent code
Package BodyOKC_PRICE_PVT - show dependent code
ViewOKS_CUST_PRODUCTS_V
Package BodyOKS_ENT_UTIL_PVT - show dependent code
Package BodyOKS_OKSCODET_XMLP_PKG - show dependent code
Package BodyOKS_OMINT_PUB - show dependent code