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


VIEW: APPS.CSI_CP_FORM_PROD_V

Object Details
Object Name: CSI_CP_FORM_PROD_V
Object Type: VIEW
Owner: APPS
FND Design Data: ViewCSI.CSI_CP_FORM_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
ROW_ID ROWID (10)
CUSTOMER_PRODUCT_ID NUMBER
Yes
CP_OBJECT_VERSION_NUMBER NUMBER
Yes
INSTANCE_PARTY_ID NUMBER
Yes
IP_OBJECT_VERSION_NUMBER NUMBER
Yes
IP_ACCOUNT_ID NUMBER

IPA_OBJECT_VERSION_NUMBER NUMBER

PRICING_ATTRIBUTE_ID NUMBER

PA_OBJECT_VERSION_NUMBER NUMBER

INSTANCE_OU_ID NUMBER

PRODUCT_DESCRIPTION VARCHAR2 (240)
CONCATENATED_SEGMENTS VARCHAR2 (40)
CUSTOMER_ID NUMBER

UNIT_OF_MEASURE_CODE VARCHAR2 (3) Yes
QUANTITY NUMBER
Yes
REFERENCE_NUMBER VARCHAR2 (30) Yes
SYSTEM VARCHAR2 (50)
SYSTEM_ID NUMBER

REVISION VARCHAR2 (3)
INSTALLATION_DATE DATE

SHIPPED_DATE DATE

CP_LOT_NUMBER VARCHAR2 (80)
CURRENT_SERIAL_NUMBER VARCHAR2 (30)
PLATFORM_VERSION VARCHAR2 (0)
RETURN_BY_DATE DATE

ACTUAL_RETURNED_DATE DATE

CP_STATUS VARCHAR2 (50) Yes
CP_TYPE VARCHAR2 (30)
PRODUCT_AGREEMENT VARCHAR2 (240)
PRODUCT_AGREEMENT_ID NUMBER

SPLIT_FLAG VARCHAR2 (0)
SHIPPED_FLAG VARCHAR2 (1)
DELIVERED_FLAG VARCHAR2 (0)
CUSTOMER_VIEW_FLAG VARCHAR2 (1) Yes
MERCHANT_VIEW_FLAG VARCHAR2 (1) Yes
PROJECT_ID NUMBER

TASK_ID NUMBER

START_DATE_ACTIVE DATE

END_DATE_ACTIVE DATE

ATTRIBUTE1 VARCHAR2 (240)
ATTRIBUTE2 VARCHAR2 (240)
ATTRIBUTE3 VARCHAR2 (240)
ATTRIBUTE4 VARCHAR2 (240)
ATTRIBUTE5 VARCHAR2 (240)
ATTRIBUTE6 VARCHAR2 (240)
ATTRIBUTE7 VARCHAR2 (240)
ATTRIBUTE8 VARCHAR2 (240)
ATTRIBUTE9 VARCHAR2 (240)
ATTRIBUTE10 VARCHAR2 (240)
ATTRIBUTE11 VARCHAR2 (240)
ATTRIBUTE12 VARCHAR2 (240)
ATTRIBUTE13 VARCHAR2 (240)
ATTRIBUTE14 VARCHAR2 (240)
ATTRIBUTE15 VARCHAR2 (240)
CONTEXT VARCHAR2 (30)
ORIGINAL_ORDER_NUMBER NUMBER

ORIGINAL_ORDER_DATE DATE

ORIGINAL_ORDER_LINE_NUMBER NUMBER

ORIGINAL_ORDER_LINE_ID NUMBER

PURCHASE_ORDER_NUM VARCHAR2 (50)
ORDER_CURRENCY VARCHAR2 (15)
ORIGINAL_NET_AMOUNT NUMBER

INVENTORY_ITEM_ID NUMBER
Yes
CREATED_MANUALLY_FLAG VARCHAR2 (1)
MOST_RECENT_FLAG CHAR (1)
ORIGINAL_LINK_TO_ORDER_LINE_ID NUMBER

ORIGINAL_LINE_SERV_DETAIL_ID VARCHAR2 (0)
PRICE_LIST_ID NUMBER

ORG_ID NUMBER

STATUS_CHANGE_ALLOWED_FLAG VARCHAR2 (1)
INCIDENT_ALLOWED_FLAG VARCHAR2 (1)
SERVICE_ORDER_ALLOWED_FLAG VARCHAR2 (1)
BOM_ITEM_ID NUMBER
Yes
RMA_LINE_ID VARCHAR2 (0)
CUSTOMER_PRODUCT_STATUS_ID NUMBER
Yes
SERIAL_NUMBER_CONTROL_CODE NUMBER

PRINCIPAL_PARTY_NAME VARCHAR2 (360) Yes
PARTY_ID NUMBER (15) Yes
ACCOUNT_NUMBER VARCHAR2 (30) Yes
PRICING_ATTRIBUTE1 VARCHAR2 (240)
PRICING_ATTRIBUTE2 VARCHAR2 (240)
PRICING_ATTRIBUTE3 VARCHAR2 (240)
PRICING_ATTRIBUTE4 VARCHAR2 (240)
PRICING_ATTRIBUTE5 VARCHAR2 (240)
PRICING_ATTRIBUTE6 VARCHAR2 (240)
PRICING_ATTRIBUTE7 VARCHAR2 (240)
PRICING_ATTRIBUTE8 VARCHAR2 (240)
PRICING_ATTRIBUTE9 VARCHAR2 (240)
PRICING_ATTRIBUTE10 VARCHAR2 (240)
PRICING_ATTRIBUTE11 VARCHAR2 (240)
PRICING_ATTRIBUTE12 VARCHAR2 (240)
PRICING_ATTRIBUTE13 VARCHAR2 (240)
PRICING_ATTRIBUTE14 VARCHAR2 (240)
PRICING_ATTRIBUTE15 VARCHAR2 (240)
PRICING_ATTRIBUTE16 VARCHAR2 (240)
PRICING_ATTRIBUTE17 VARCHAR2 (240)
PRICING_ATTRIBUTE18 VARCHAR2 (240)
PRICING_ATTRIBUTE19 VARCHAR2 (240)
PRICING_ATTRIBUTE20 VARCHAR2 (240)
PRICING_ATTRIBUTE21 VARCHAR2 (240)
PRICING_ATTRIBUTE22 VARCHAR2 (240)
PRICING_ATTRIBUTE23 VARCHAR2 (240)
PRICING_ATTRIBUTE24 VARCHAR2 (240)
PRICING_ATTRIBUTE25 VARCHAR2 (240)
PRICING_ATTRIBUTE26 VARCHAR2 (240)
PRICING_ATTRIBUTE27 VARCHAR2 (240)
PRICING_ATTRIBUTE28 VARCHAR2 (240)
PRICING_ATTRIBUTE29 VARCHAR2 (240)
PRICING_ATTRIBUTE30 VARCHAR2 (240)
PRICING_ATTRIBUTE31 VARCHAR2 (240)
PRICING_ATTRIBUTE32 VARCHAR2 (240)
PRICING_ATTRIBUTE33 VARCHAR2 (240)
PRICING_ATTRIBUTE34 VARCHAR2 (240)
PRICING_ATTRIBUTE35 VARCHAR2 (240)
PRICING_ATTRIBUTE36 VARCHAR2 (240)
PRICING_ATTRIBUTE37 VARCHAR2 (240)
PRICING_ATTRIBUTE38 VARCHAR2 (240)
PRICING_ATTRIBUTE39 VARCHAR2 (240)
PRICING_ATTRIBUTE40 VARCHAR2 (240)
PRICING_ATTRIBUTE41 VARCHAR2 (240)
PRICING_ATTRIBUTE42 VARCHAR2 (240)
PRICING_ATTRIBUTE43 VARCHAR2 (240)
PRICING_ATTRIBUTE44 VARCHAR2 (240)
PRICING_ATTRIBUTE45 VARCHAR2 (240)
PRICING_ATTRIBUTE46 VARCHAR2 (240)
PRICING_ATTRIBUTE47 VARCHAR2 (240)
PRICING_ATTRIBUTE48 VARCHAR2 (240)
PRICING_ATTRIBUTE49 VARCHAR2 (240)
PRICING_ATTRIBUTE50 VARCHAR2 (240)
PRICING_ATTRIBUTE51 VARCHAR2 (240)
PRICING_ATTRIBUTE52 VARCHAR2 (240)
PRICING_ATTRIBUTE53 VARCHAR2 (240)
PRICING_ATTRIBUTE54 VARCHAR2 (240)
PRICING_ATTRIBUTE55 VARCHAR2 (240)
PRICING_ATTRIBUTE56 VARCHAR2 (240)
PRICING_ATTRIBUTE57 VARCHAR2 (240)
PRICING_ATTRIBUTE58 VARCHAR2 (240)
PRICING_ATTRIBUTE59 VARCHAR2 (240)
PRICING_ATTRIBUTE60 VARCHAR2 (240)
PRICING_ATTRIBUTE61 VARCHAR2 (240)
PRICING_ATTRIBUTE62 VARCHAR2 (240)
PRICING_ATTRIBUTE63 VARCHAR2 (240)
PRICING_ATTRIBUTE64 VARCHAR2 (240)
PRICING_ATTRIBUTE65 VARCHAR2 (240)
PRICING_ATTRIBUTE66 VARCHAR2 (240)
PRICING_ATTRIBUTE67 VARCHAR2 (240)
PRICING_ATTRIBUTE68 VARCHAR2 (240)
PRICING_ATTRIBUTE69 VARCHAR2 (240)
PRICING_ATTRIBUTE70 VARCHAR2 (240)
PRICING_ATTRIBUTE71 VARCHAR2 (240)
PRICING_ATTRIBUTE72 VARCHAR2 (240)
PRICING_ATTRIBUTE73 VARCHAR2 (240)
PRICING_ATTRIBUTE74 VARCHAR2 (240)
PRICING_ATTRIBUTE75 VARCHAR2 (240)
PRICING_ATTRIBUTE76 VARCHAR2 (240)
PRICING_ATTRIBUTE77 VARCHAR2 (240)
PRICING_ATTRIBUTE78 VARCHAR2 (240)
PRICING_ATTRIBUTE79 VARCHAR2 (240)
PRICING_ATTRIBUTE80 VARCHAR2 (240)
PRICING_ATTRIBUTE81 VARCHAR2 (240)
PRICING_ATTRIBUTE82 VARCHAR2 (240)
PRICING_ATTRIBUTE83 VARCHAR2 (240)
PRICING_ATTRIBUTE84 VARCHAR2 (240)
PRICING_ATTRIBUTE85 VARCHAR2 (240)
PRICING_ATTRIBUTE86 VARCHAR2 (240)
PRICING_ATTRIBUTE87 VARCHAR2 (240)
PRICING_ATTRIBUTE88 VARCHAR2 (240)
PRICING_ATTRIBUTE89 VARCHAR2 (240)
PRICING_ATTRIBUTE90 VARCHAR2 (240)
PRICING_ATTRIBUTE91 VARCHAR2 (240)
PRICING_ATTRIBUTE92 VARCHAR2 (240)
PRICING_ATTRIBUTE93 VARCHAR2 (240)
PRICING_ATTRIBUTE94 VARCHAR2 (240)
PRICING_ATTRIBUTE95 VARCHAR2 (240)
PRICING_ATTRIBUTE96 VARCHAR2 (240)
PRICING_ATTRIBUTE97 VARCHAR2 (240)
PRICING_ATTRIBUTE98 VARCHAR2 (240)
PRICING_ATTRIBUTE99 VARCHAR2 (240)
PRICING_ATTRIBUTE100 VARCHAR2 (240)
PRICING_CONTEXT VARCHAR2 (30)
EXTERNAL_REFERENCE VARCHAR2 (30)
Query Text

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


SELECT ROW_ID
,      CUSTOMER_PRODUCT_ID
,      CP_OBJECT_VERSION_NUMBER
,      INSTANCE_PARTY_ID
,      IP_OBJECT_VERSION_NUMBER
,      IP_ACCOUNT_ID
,      IPA_OBJECT_VERSION_NUMBER
,      PRICING_ATTRIBUTE_ID
,      PA_OBJECT_VERSION_NUMBER
,      INSTANCE_OU_ID
,      PRODUCT_DESCRIPTION
,      CONCATENATED_SEGMENTS
,      CUSTOMER_ID
,      UNIT_OF_MEASURE_CODE
,      QUANTITY
,      REFERENCE_NUMBER
,      SYSTEM
,      SYSTEM_ID
,      REVISION
,      INSTALLATION_DATE
,      SHIPPED_DATE
,      CP_LOT_NUMBER
,      CURRENT_SERIAL_NUMBER
,      PLATFORM_VERSION
,      RETURN_BY_DATE
,      ACTUAL_RETURNED_DATE
,      CP_STATUS
,      CP_TYPE
,      PRODUCT_AGREEMENT
,      PRODUCT_AGREEMENT_ID
,      SPLIT_FLAG
,      SHIPPED_FLAG
,      DELIVERED_FLAG
,      CUSTOMER_VIEW_FLAG
,      MERCHANT_VIEW_FLAG
,      PROJECT_ID
,      TASK_ID
,      START_DATE_ACTIVE
,      END_DATE_ACTIVE
,      ATTRIBUTE1
,      ATTRIBUTE2
,      ATTRIBUTE3
,      ATTRIBUTE4
,      ATTRIBUTE5
,      ATTRIBUTE6
,      ATTRIBUTE7
,      ATTRIBUTE8
,      ATTRIBUTE9
,      ATTRIBUTE10
,      ATTRIBUTE11
,      ATTRIBUTE12
,      ATTRIBUTE13
,      ATTRIBUTE14
,      ATTRIBUTE15
,      CONTEXT
,      ORIGINAL_ORDER_NUMBER
,      ORIGINAL_ORDER_DATE
,      ORIGINAL_ORDER_LINE_NUMBER
,      ORIGINAL_ORDER_LINE_ID
,      PURCHASE_ORDER_NUM
,      ORDER_CURRENCY
,      ORIGINAL_NET_AMOUNT
,      INVENTORY_ITEM_ID
,      CREATED_MANUALLY_FLAG
,      MOST_RECENT_FLAG
,      ORIGINAL_LINK_TO_ORDER_LINE_ID
,      ORIGINAL_LINE_SERV_DETAIL_ID
,      PRICE_LIST_ID
,      ORG_ID
,      STATUS_CHANGE_ALLOWED_FLAG
,      INCIDENT_ALLOWED_FLAG
,      SERVICE_ORDER_ALLOWED_FLAG
,      BOM_ITEM_ID
,      RMA_LINE_ID
,      CUSTOMER_PRODUCT_STATUS_ID
,      SERIAL_NUMBER_CONTROL_CODE
,      PRINCIPAL_PARTY_NAME
,      PARTY_ID
,      ACCOUNT_NUMBER
,      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
,      EXTERNAL_REFERENCE
FROM APPS.CSI_CP_FORM_PROD_V;

Dependencies

[top of page]

APPS.CSI_CP_FORM_PROD_V references the following:

SchemaAPPS
SynonymCSI_INSTALL_PARAMETERS
SynonymCSI_INSTANCE_STATUSES
SynonymCSI_IP_ACCOUNTS
SynonymCSI_ITEM_INSTANCES
SynonymCSI_I_ORG_ASSIGNMENTS
SynonymCSI_I_PARTIES
SynonymCSI_I_PRICING_ATTRIBS
ViewCSI_SYSTEMS_VL
SynonymHZ_CUST_ACCOUNTS
SynonymHZ_PARTIES
SynonymMTL_SYSTEM_ITEMS
SynonymMTL_SYSTEM_ITEMS_KFV
ViewOE_AGREEMENTS_VL
SynonymOE_ORDER_HEADERS_ALL
SynonymOE_ORDER_LINES_ALL
SynonymOE_ORDER_PRICE_ATTRIBS

APPS.CSI_CP_FORM_PROD_V is not referenced by any database object