VIEW: APPS.CS_CUSTOMER_PRODUCTS

Source

View Text - Preformatted

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

View Text - HTML Formatted

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