VIEW: APPS.OKX_CUST_PROD_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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