VIEW: AMS.AMS_ACT_PRODUCTS#

Source

View Text - Preformatted

select ACTIVITY_PRODUCT_ID ACTIVITY_PRODUCT_ID, 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, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, ACT_PRODUCT_USED_BY_ID ACT_PRODUCT_USED_BY_ID, ARC_ACT_PRODUCT_USED_BY ARC_ACT_PRODUCT_USED_BY, PRODUCT_SALE_TYPE PRODUCT_SALE_TYPE, PRIMARY_PRODUCT_FLAG PRIMARY_PRODUCT_FLAG, ENABLED_FLAG ENABLED_FLAG, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, ORGANIZATION_ID ORGANIZATION_ID, CATEGORY_ID CATEGORY_ID, CATEGORY_SET_ID CATEGORY_SET_ID, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, LEVEL_TYPE_CODE LEVEL_TYPE_CODE, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, EXCLUDED_FLAG EXCLUDED_FLAG, SECURITY_GROUP_ID SECURITY_GROUP_ID, LINE_LUMPSUM_AMOUNT LINE_LUMPSUM_AMOUNT, LINE_LUMPSUM_QTY LINE_LUMPSUM_QTY, SCAN_VALUE SCAN_VALUE, UOM_CODE UOM_CODE, ADJUSTMENT_FLAG ADJUSTMENT_FLAG, SCAN_UNIT_FORECAST SCAN_UNIT_FORECAST, CHANNEL_ID CHANNEL_ID, QUANTITY QUANTITY from "AMS"."AMS_ACT_PRODUCTS"

View Text - HTML Formatted

SELECT ACTIVITY_PRODUCT_ID ACTIVITY_PRODUCT_ID
, 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
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, ACT_PRODUCT_USED_BY_ID ACT_PRODUCT_USED_BY_ID
, ARC_ACT_PRODUCT_USED_BY ARC_ACT_PRODUCT_USED_BY
, PRODUCT_SALE_TYPE PRODUCT_SALE_TYPE
, PRIMARY_PRODUCT_FLAG PRIMARY_PRODUCT_FLAG
, ENABLED_FLAG ENABLED_FLAG
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, ORGANIZATION_ID ORGANIZATION_ID
, CATEGORY_ID CATEGORY_ID
, CATEGORY_SET_ID CATEGORY_SET_ID
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, LEVEL_TYPE_CODE LEVEL_TYPE_CODE
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, EXCLUDED_FLAG EXCLUDED_FLAG
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, LINE_LUMPSUM_AMOUNT LINE_LUMPSUM_AMOUNT
, LINE_LUMPSUM_QTY LINE_LUMPSUM_QTY
, SCAN_VALUE SCAN_VALUE
, UOM_CODE UOM_CODE
, ADJUSTMENT_FLAG ADJUSTMENT_FLAG
, SCAN_UNIT_FORECAST SCAN_UNIT_FORECAST
, CHANNEL_ID CHANNEL_ID
, QUANTITY QUANTITY
FROM "AMS"."AMS_ACT_PRODUCTS"