View: OKX_CUSTOMER_PRODUCTS_V

Product:	OKX - Contracts Integration
Description:	The installed base products information (customer products)
Implementation/DBA Data:	APPS.OKX_CUSTOMER_PRODUCTS_V

View Text

SELECT CP.CUSTOMER_PRODUCT_ID ID1
, '#' ID2
, SIT.DESCRIPTION NAME
, BK.CONCATENATED_SEGMENTS DESCRIPTION
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(CP.START_DATE_ACTIVE
, TRUNC(SYSDATE)))
, -1
, 'I'
, DECODE(SIGN(TRUNC(SYSDATE)-NVL(CP.END_DATE_ACTIVE
, TRUNC(SYSDATE)))
, 1
, 'I'
, 'A')) STATUS
, CP.INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, BK.ORGANIZATION_ID ORGANIZATION_ID
, BK.PRIMARY_UOM_CODE PRIMARY_UOM_CODE
, CP.CUSTOMER_ID CUSTOMER_ID
, CP.INSTALL_SITE_USE_ID INSTALL_SITE_USE_ID
, CP.SYSTEM_ID SYSTEM_ID
, CP.QUANTITY QUANTITY
, CP.LOT_NUMBER LOT_NUMBER
, CP.CURRENT_SERIAL_NUMBER CURRENT_SERIAL_NUMBER
, CP.REFERENCE_NUMBER REFERENCE_NUMBER
, CP.UNIT_OF_MEASURE_CODE UNIT_OF_MEASURE_CODE
, UOM.UNIT_OF_MEASURE UNIT_OF_MEASURE
, CP.ORG_ID ORG_ID
, CP.CONFIG_PARENT_ID CONFIG_PARENT_ID
, CP.START_DATE_ACTIVE START_DATE_ACTIVE
, CP.END_DATE_ACTIVE END_DATE_ACTIVE
, CP.CREATED_MANUALLY_FLAG CREATED_MANUALLY_FLAG
, CP.MOST_RECENT_FLAG MOST_RECENT_FLAG
, CP.CURRENT_CP_REVISION_ID CURRENT_CP_REVISION_ID
, CP.TYPE_CODE TYPE_CODE
, CP.PRODUCT_AGREEMENT_ID PRODUCT_AGREEMENT_ID
, CP.INSTALLATION_DATE INSTALLATION_DATE
, CP.ORIGINAL_ORDER_LINE_ID ORIGINAL_ORDER_LINE_ID
, CP.ORIGINAL_LINE_SERV_DETAIL_ID ORIGINAL_LINE_SERV_DETAIL_ID
, 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.SHIPPED_FLAG SHIPPED_FLAG
, CP.DELIVERED_FLAG DELIVERED_FLAG
, CP.PARENT_CP_ID PARENT_CP_ID
, CP.CUSTOMER_PRODUCT_STATUS_ID CUSTOMER_PRODUCT_STATUS_ID
, CP.SHIPPED_DATE SHIPPED_DATE
, 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.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_TYPE CONFIG_TYPE
, CP.PLATFORM_VERSION_ID PLATFORM_VERSION_ID
, CP.CONTEXT CONTEXT
, CP.ORIGINAL_ORDER_CURRENCY_CODE 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 MTL_UNITS_OF_MEASURE_TL UOM
, CS_CUSTOMER_PRODUCTS_ALL CP
, MTL_SYSTEM_ITEMS_TL SIT
, MTL_SYSTEM_ITEMS_B_KFV BK
WHERE BK.INVENTORY_ITEM_ID = CP.INVENTORY_ITEM_ID
AND SIT.INVENTORY_ITEM_ID = BK.INVENTORY_ITEM_ID
AND SIT.ORGANIZATION_ID = BK.ORGANIZATION_ID
AND SIT.LANGUAGE = USERENV('LANG')
AND UOM.UOM_CODE(+) = CP.UNIT_OF_MEASURE_CODE
AND UOM.LANGUAGE = USERENV('LANG')

Columns