Product: | CS - Service |
---|---|
Description: | A view of customer products by organization. |
Implementation/DBA Data: | APPS.CS_CUSTOMER_PRODUCTS |
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