FND Design Data [Home] [Help]

View: CS_CUSTOMER_PRODUCTS

Product: CS - Service
Description: A view of customer products by organization.
Implementation/DBA Data: ViewAPPS.CS_CUSTOMER_PRODUCTS
View Text

SELECT CUSTOMER_PRODUCT_ID
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CUSTOMER_ID
, INVENTORY_ITEM_ID
, LOT_NUMBER
, CREATED_MANUALLY_FLAG
, MOST_RECENT_FLAG
, CURRENT_CP_REVISION_ID
, CURRENT_SERIAL_NUMBER
, TYPE_CODE
, SYSTEM_ID
, PRODUCT_AGREEMENT_ID
, INSTALLATION_DATE
, ORIGINAL_ORDER_LINE_ID
, ORIGINAL_LINE_SERV_DETAIL_ID
, ORIGINAL_NET_AMOUNT
, ORIGINAL_ORDER_CURRENCY_CODE
, PURCHASE_ORDER_NUM
, 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_STATUS_ID
, 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
, MERCHANT_VIEW_FLAG
, CUSTOMER_VIEW_FLAG
, ATTRIBUTE1
, ATTRIBUTE2
, ATTRIBUTE3
, ATTRIBUTE4
, ATTRIBUTE5
, ATTRIBUTE6
, ATTRIBUTE7
, ATTRIBUTE8
, ATTRIBUTE9
, ATTRIBUTE10
, ATTRIBUTE11
, ATTRIBUTE12
, ATTRIBUTE13
, ATTRIBUTE14
, ATTRIBUTE15
, CONTEXT
, 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 CS_CUSTOMER_PRODUCTS_ALL

Columns

Name
CUSTOMER_PRODUCT_ID
LAST_UPDATE_DATE
LAST_UPDATED_BY
CREATION_DATE
CREATED_BY
LAST_UPDATE_LOGIN
CUSTOMER_ID
INVENTORY_ITEM_ID
LOT_NUMBER
CREATED_MANUALLY_FLAG
MOST_RECENT_FLAG
CURRENT_CP_REVISION_ID
CURRENT_SERIAL_NUMBER
TYPE_CODE
SYSTEM_ID
PRODUCT_AGREEMENT_ID
INSTALLATION_DATE
ORIGINAL_ORDER_LINE_ID
ORIGINAL_LINE_SERV_DETAIL_ID
ORIGINAL_NET_AMOUNT
ORIGINAL_ORDER_CURRENCY_CODE
PURCHASE_ORDER_NUM
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_STATUS_ID
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
MERCHANT_VIEW_FLAG
CUSTOMER_VIEW_FLAG
ATTRIBUTE1
ATTRIBUTE2
ATTRIBUTE3
ATTRIBUTE4
ATTRIBUTE5
ATTRIBUTE6
ATTRIBUTE7
ATTRIBUTE8
ATTRIBUTE9
ATTRIBUTE10
ATTRIBUTE11
ATTRIBUTE12
ATTRIBUTE13
ATTRIBUTE14
ATTRIBUTE15
CONTEXT
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