[Home] [Help] [Dependency Information]
Object Name: | CSI_CP_FORM_PROD_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
FND Design Data: | CSI.CSI_CP_FORM_PROD_V |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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) |
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;
APPS.CSI_CP_FORM_PROD_V is not referenced by any database object
|
|
|