Product: | OKX - Contracts Integration |
---|---|
Description: | The installed base products information (customer products) |
Implementation/DBA Data: | APPS.OKX_CUST_PROD_V |
SELECT CP.CUSTOMER_PRODUCT_ID CUSTOMER_PRODUCT_ID
, CP.CUSTOMER_ID CUSTOMER_ID
, CP.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, CP.LOT_NUMBER LOT_NUMBER
, CP.CREATED_MANUALLY_FLAG CREATED_MANUALLY_FLAG
, CP.MOST_RECENT_FLAG MOST_RECENT_FLAG
, CP.CURRENT_CP_REVISION_ID CURRENT_CP_REVISION_I
, CP.CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER
, CP.TYPE_CODE TYPE_CODE
, CP.SYSTEM_ID SYSTEM_ID
, CP.PRODUCT_AGREEMENT_ID PRODUCT_AGREEMENT_ID
, CP.INSTALLATION_DATE INSTALLATION_DATE
, CP.ORIGINAL_ORDER_LINE_ID ORIGINAL_ORDER_LINE_I
, CP.ORIGINAL_LINE_SERV_DETAIL_ID ORIGINAL_LINE_SERV_DE
, CP.ORIGINAL_NET_AMOUNT ORIGINAL_NET_AMOUNT
, CP.SHIP_TO_SITE_USE_ID SHIP_TO_SITE_USE_ID
, CP.BILL_TO_SITE_USE_ID BILL_TO_SITE_USE_ID
, CP.INSTALL_SITE_USE_ID INSTALL_SITE_USE_ID
, CP.QUANTITY QUANTITY
, CP.SHIPPED_FLAG SHIPPED_FLAG
, CP.DELIVERED_FLAG DELIVERED_FLAG
, CP.UNIT_OF_MEASURE_CODE UNIT_OF_MEASURE_CODE
, CP.PARENT_CP_ID PARENT_CP_ID
, CP.CUSTOMER_PRODUCT_STATUS_ID CUSTOMER_PRODUCT_STAT
, CP.SHIPPED_DATE SHIPPED_DATE
, CP.ORG_ID ORG_ID
, CP.REFERENCE_NUMBER REFERENCE_NUMBER
, CP.RETURN_BY_DATE RETURN_BY_DATE
, CP.ACTUAL_RETURNED_DATE ACTUAL_RETURNED_DATE
, CP.RMA_LINE_ID RMA_LINE_ID
, CP.SPLIT_FLAG SPLIT_FLAG
, CP.PROJECT_ID PROJECT_ID
, CP.TASK_ID TASK_ID
, CP.CONFIG_ENABLED_FLAG CONFIG_ENABLED_FLAG
, CP.CONFIG_START_DATE CONFIG_START_DATE
, CP.CONFIG_END_DATE CONFIG_END_DATE
, CP.CONFIG_ROOT_ID CONFIG_ROOT_ID
, CP.CONFIG_PARENT_ID CONFIG_PARENT_ID
, CP.CONFIG_TYPE CONFIG_TYPE
, CP.PLATFORM_VERSION_ID PLATFORM_VERSION_ID
, CP.START_DATE_ACTIVE START_DATE_ACTIVE
, CP.END_DATE_ACTIVE END_DATE_ACTIVE
, CP.OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, CP.CONTEXT CONTEXT
, CP.ORIGINAL_ORDER_CURRENCY_CODE
, CP.PRICING_ATTRIBUTE1
, CP.PRICING_ATTRIBUTE2
, CP.PRICING_ATTRIBUTE3
, CP.PRICING_ATTRIBUTE4
, CP.PRICING_ATTRIBUTE5
, CP.PRICING_ATTRIBUTE6
, CP.PRICING_ATTRIBUTE7
, CP.PRICING_ATTRIBUTE8
, CP.PRICING_ATTRIBUTE9
, CP.PRICING_ATTRIBUTE10
, CP.PRICING_ATTRIBUTE11
, CP.PRICING_ATTRIBUTE12
, CP.PRICING_ATTRIBUTE13
, CP.PRICING_ATTRIBUTE14
, CP.PRICING_ATTRIBUTE15
, CP.PRICING_ATTRIBUTE16
, CP.PRICING_ATTRIBUTE17
, CP.PRICING_ATTRIBUTE18
, CP.PRICING_ATTRIBUTE19
, CP.PRICING_ATTRIBUTE20
, CP.PRICING_ATTRIBUTE21
, CP.PRICING_ATTRIBUTE22
, CP.PRICING_ATTRIBUTE23
, CP.PRICING_ATTRIBUTE24
, CP.PRICING_ATTRIBUTE25
, CP.PRICING_ATTRIBUTE26
, CP.PRICING_ATTRIBUTE27
, CP.PRICING_ATTRIBUTE28
, CP.PRICING_ATTRIBUTE29
, CP.PRICING_ATTRIBUTE30
, CP.PRICING_ATTRIBUTE31
, CP.PRICING_ATTRIBUTE32
, CP.PRICING_ATTRIBUTE33
, CP.PRICING_ATTRIBUTE34
, CP.PRICING_ATTRIBUTE35
, CP.PRICING_ATTRIBUTE36
, CP.PRICING_ATTRIBUTE37
, CP.PRICING_ATTRIBUTE38
, CP.PRICING_ATTRIBUTE39
, CP.PRICING_ATTRIBUTE40
, CP.PRICING_ATTRIBUTE41
, CP.PRICING_ATTRIBUTE42
, CP.PRICING_ATTRIBUTE43
, CP.PRICING_ATTRIBUTE44
, CP.PRICING_ATTRIBUTE45
, CP.PRICING_ATTRIBUTE46
, CP.PRICING_ATTRIBUTE47
, CP.PRICING_ATTRIBUTE48
, CP.PRICING_ATTRIBUTE49
, CP.PRICING_ATTRIBUTE50
, CP.PRICING_ATTRIBUTE51
, CP.PRICING_ATTRIBUTE52
, CP.PRICING_ATTRIBUTE53
, CP.PRICING_ATTRIBUTE54
, CP.PRICING_ATTRIBUTE55
, CP.PRICING_ATTRIBUTE56
, CP.PRICING_ATTRIBUTE57
, CP.PRICING_ATTRIBUTE58
, CP.PRICING_ATTRIBUTE59
, CP.PRICING_ATTRIBUTE60
, CP.PRICING_ATTRIBUTE61
, CP.PRICING_ATTRIBUTE62
, CP.PRICING_ATTRIBUTE63
, CP.PRICING_ATTRIBUTE64
, CP.PRICING_ATTRIBUTE65
, CP.PRICING_ATTRIBUTE66
, CP.PRICING_ATTRIBUTE67
, CP.PRICING_ATTRIBUTE68
, CP.PRICING_ATTRIBUTE69
, CP.PRICING_ATTRIBUTE70
, CP.PRICING_ATTRIBUTE71
, CP.PRICING_ATTRIBUTE72
, CP.PRICING_ATTRIBUTE73
, CP.PRICING_ATTRIBUTE74
, CP.PRICING_ATTRIBUTE75
, CP.PRICING_ATTRIBUTE76
, CP.PRICING_ATTRIBUTE77
, CP.PRICING_ATTRIBUTE78
, CP.PRICING_ATTRIBUTE79
, CP.PRICING_ATTRIBUTE80
, CP.PRICING_ATTRIBUTE81
, CP.PRICING_ATTRIBUTE82
, CP.PRICING_ATTRIBUTE83
, CP.PRICING_ATTRIBUTE84
, CP.PRICING_ATTRIBUTE85
, CP.PRICING_ATTRIBUTE86
, CP.PRICING_ATTRIBUTE87
, CP.PRICING_ATTRIBUTE88
, CP.PRICING_ATTRIBUTE89
, CP.PRICING_ATTRIBUTE90
, CP.PRICING_ATTRIBUTE91
, CP.PRICING_ATTRIBUTE92
, CP.PRICING_ATTRIBUTE93
, CP.PRICING_ATTRIBUTE94
, CP.PRICING_ATTRIBUTE95
, CP.PRICING_ATTRIBUTE96
, CP.PRICING_ATTRIBUTE97
, CP.PRICING_ATTRIBUTE98
, CP.PRICING_ATTRIBUTE99
, CP.PRICING_ATTRIBUTE100
, CP.PRICING_CONTEXT
FROM CS_CUSTOMER_PRODUCTS_ALL CP