Views [dbo].[al_bi_model_pricing_view]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Created10:33:18 PM Thursday, February 10, 2011
Last Modified10:33:18 PM Thursday, February 10, 2011
Columns
Name
PRICING_ID
MODEL_UUID
BEGIN_DATE
EXPIRATION_DATE
PRICING_AMOUNT
CURRENCY_TYPE_CODE
PRICING_TYPE_ID
PART_NUMBER
RESELLER_UUID
PRICING_COMMENT
CREATION_USER
CREATION_DATE
LAST_UPDATE_USER
LAST_UPDATE_DATE
VERSION_NUMBER
IS_MANUFACTURER_PART_NUMBER
TENANT
TENANT_DISPLAY
SQL Script
CREATE VIEW [dbo].[al_bi_model_pricing_view]
AS
SELECT     PRICING_ID, MODEL_UUID, BEGIN_DATE, EXPIRATION_DATE, PRICING_AMOUNT, CURRENCY_TYPE_CODE, PRICING_TYPE_ID, PART_NUMBER,
                      RESELLER_UUID, PRICING_COMMENT, CREATION_USER, CREATION_DATE, LAST_UPDATE_USER, LAST_UPDATE_DATE, VERSION_NUMBER,
                      IS_MANUFACTURER_PART_NUMBER, TENANT,dbo.al_bi_bintohexstr(TENANT) AS TENANT_DISPLAY
FROM         dbo.ARG_MODEL_PRICING
GO
Uses