VIEW: OZF.OZF_COMPETITOR_PRICE_POINTS#

Source

View Text - Preformatted

select COMP_PRICE_POINT_ID COMP_PRICE_POINT_ID, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RETAIL_PRICE_POINT_ID RETAIL_PRICE_POINT_ID, COMPETITOR_PRODUCT_ID COMPETITOR_PRODUCT_ID, FROM_DATE FROM_DATE, TO_DATE TO_DATE, COMPETITOR_RETAIL_PRICE COMPETITOR_RETAIL_PRICE, RETAIL_UOM_CODE RETAIL_UOM_CODE, FACING FACING, REVISION REVISION, HISTORY_FLAG HISTORY_FLAG, ORGANIZATION_ID ORGANIZATION_ID, AUDITED_DATE AUDITED_DATE, PROMOTIONAL_PRICE PROMOTIONAL_PRICE, DISPLAYS DISPLAYS, FEATURE FEATURE, CHR_ATTRIBUTE1 CHR_ATTRIBUTE1, CHR_ATTRIBUTE2 CHR_ATTRIBUTE2, CHR_ATTRIBUTE3 CHR_ATTRIBUTE3, CHR_ATTRIBUTE4 CHR_ATTRIBUTE4, CHR_ATTRIBUTE5 CHR_ATTRIBUTE5, CHR_ATTRIBUTE6 CHR_ATTRIBUTE6, CHR_ATTRIBUTE7 CHR_ATTRIBUTE7, CHR_ATTRIBUTE8 CHR_ATTRIBUTE8, CHR_ATTRIBUTE9 CHR_ATTRIBUTE9, CHR_ATTRIBUTE10 CHR_ATTRIBUTE10, CHR_ATTRIBUTE11 CHR_ATTRIBUTE11, CHR_ATTRIBUTE12 CHR_ATTRIBUTE12, CHR_ATTRIBUTE13 CHR_ATTRIBUTE13, CHR_ATTRIBUTE14 CHR_ATTRIBUTE14, CHR_ATTRIBUTE15 CHR_ATTRIBUTE15, NUM_ATTRIBUTE1 NUM_ATTRIBUTE1, NUM_ATTRIBUTE2 NUM_ATTRIBUTE2, NUM_ATTRIBUTE3 NUM_ATTRIBUTE3, NUM_ATTRIBUTE4 NUM_ATTRIBUTE4, NUM_ATTRIBUTE5 NUM_ATTRIBUTE5, NUM_ATTRIBUTE6 NUM_ATTRIBUTE6, NUM_ATTRIBUTE7 NUM_ATTRIBUTE7, NUM_ATTRIBUTE8 NUM_ATTRIBUTE8, NUM_ATTRIBUTE9 NUM_ATTRIBUTE9, NUM_ATTRIBUTE10 NUM_ATTRIBUTE10, NUM_ATTRIBUTE11 NUM_ATTRIBUTE11, NUM_ATTRIBUTE12 NUM_ATTRIBUTE12, NUM_ATTRIBUTE13 NUM_ATTRIBUTE13, NUM_ATTRIBUTE14 NUM_ATTRIBUTE14, NUM_ATTRIBUTE15 NUM_ATTRIBUTE15 from "OZF"."OZF_COMPETITOR_PRICE_POINTS"

View Text - HTML Formatted

SELECT COMP_PRICE_POINT_ID COMP_PRICE_POINT_ID
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RETAIL_PRICE_POINT_ID RETAIL_PRICE_POINT_ID
, COMPETITOR_PRODUCT_ID COMPETITOR_PRODUCT_ID
, FROM_DATE FROM_DATE
, TO_DATE TO_DATE
, COMPETITOR_RETAIL_PRICE COMPETITOR_RETAIL_PRICE
, RETAIL_UOM_CODE RETAIL_UOM_CODE
, FACING FACING
, REVISION REVISION
, HISTORY_FLAG HISTORY_FLAG
, ORGANIZATION_ID ORGANIZATION_ID
, AUDITED_DATE AUDITED_DATE
, PROMOTIONAL_PRICE PROMOTIONAL_PRICE
, DISPLAYS DISPLAYS
, FEATURE FEATURE
, CHR_ATTRIBUTE1 CHR_ATTRIBUTE1
, CHR_ATTRIBUTE2 CHR_ATTRIBUTE2
, CHR_ATTRIBUTE3 CHR_ATTRIBUTE3
, CHR_ATTRIBUTE4 CHR_ATTRIBUTE4
, CHR_ATTRIBUTE5 CHR_ATTRIBUTE5
, CHR_ATTRIBUTE6 CHR_ATTRIBUTE6
, CHR_ATTRIBUTE7 CHR_ATTRIBUTE7
, CHR_ATTRIBUTE8 CHR_ATTRIBUTE8
, CHR_ATTRIBUTE9 CHR_ATTRIBUTE9
, CHR_ATTRIBUTE10 CHR_ATTRIBUTE10
, CHR_ATTRIBUTE11 CHR_ATTRIBUTE11
, CHR_ATTRIBUTE12 CHR_ATTRIBUTE12
, CHR_ATTRIBUTE13 CHR_ATTRIBUTE13
, CHR_ATTRIBUTE14 CHR_ATTRIBUTE14
, CHR_ATTRIBUTE15 CHR_ATTRIBUTE15
, NUM_ATTRIBUTE1 NUM_ATTRIBUTE1
, NUM_ATTRIBUTE2 NUM_ATTRIBUTE2
, NUM_ATTRIBUTE3 NUM_ATTRIBUTE3
, NUM_ATTRIBUTE4 NUM_ATTRIBUTE4
, NUM_ATTRIBUTE5 NUM_ATTRIBUTE5
, NUM_ATTRIBUTE6 NUM_ATTRIBUTE6
, NUM_ATTRIBUTE7 NUM_ATTRIBUTE7
, NUM_ATTRIBUTE8 NUM_ATTRIBUTE8
, NUM_ATTRIBUTE9 NUM_ATTRIBUTE9
, NUM_ATTRIBUTE10 NUM_ATTRIBUTE10
, NUM_ATTRIBUTE11 NUM_ATTRIBUTE11
, NUM_ATTRIBUTE12 NUM_ATTRIBUTE12
, NUM_ATTRIBUTE13 NUM_ATTRIBUTE13
, NUM_ATTRIBUTE14 NUM_ATTRIBUTE14
, NUM_ATTRIBUTE15 NUM_ATTRIBUTE15
FROM "OZF"."OZF_COMPETITOR_PRICE_POINTS"