VIEW: CZ.CZ_CONFIG_USAGES#

Source

View Text - Preformatted

select CALLING_APPLICATION_ID CALLING_APPLICATION_ID, CALLING_APPLICATION_REF_KEY CALLING_APPLICATION_REF_KEY, CONFIG_HDR_ID CONFIG_HDR_ID, CONFIG_REV_NBR CONFIG_REV_NBR, CONFIG_ITEM_ID CONFIG_ITEM_ID, LIST_PRICE LIST_PRICE, AUTO_DISCOUNT_ID AUTO_DISCOUNT_ID, AUTO_DISCOUNT_LINE_ID AUTO_DISCOUNT_LINE_ID, AUTO_DISCOUNT_PCT AUTO_DISCOUNT_PCT, MANUAL_DISCOUNT_ID MANUAL_DISCOUNT_ID, MANUAL_DISCOUNT_LINE_ID MANUAL_DISCOUNT_LINE_ID, MANUAL_DISCOUNT_PCT MANUAL_DISCOUNT_PCT, DISCOUNTED_PRICE DISCOUNTED_PRICE, ATP_DATE ATP_DATE, UOM_CODE UOM_CODE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, SECURITY_MASK SECURITY_MASK, EFF_MASK EFF_MASK, CHECKOUT_USER CHECKOUT_USER, DELETED_FLAG DELETED_FLAG, EFF_FROM EFF_FROM, EFF_TO EFF_TO from "CZ"."CZ_CONFIG_USAGES"

View Text - HTML Formatted

SELECT CALLING_APPLICATION_ID CALLING_APPLICATION_ID
, CALLING_APPLICATION_REF_KEY CALLING_APPLICATION_REF_KEY
, CONFIG_HDR_ID CONFIG_HDR_ID
, CONFIG_REV_NBR CONFIG_REV_NBR
, CONFIG_ITEM_ID CONFIG_ITEM_ID
, LIST_PRICE LIST_PRICE
, AUTO_DISCOUNT_ID AUTO_DISCOUNT_ID
, AUTO_DISCOUNT_LINE_ID AUTO_DISCOUNT_LINE_ID
, AUTO_DISCOUNT_PCT AUTO_DISCOUNT_PCT
, MANUAL_DISCOUNT_ID MANUAL_DISCOUNT_ID
, MANUAL_DISCOUNT_LINE_ID MANUAL_DISCOUNT_LINE_ID
, MANUAL_DISCOUNT_PCT MANUAL_DISCOUNT_PCT
, DISCOUNTED_PRICE DISCOUNTED_PRICE
, ATP_DATE ATP_DATE
, UOM_CODE UOM_CODE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, SECURITY_MASK SECURITY_MASK
, EFF_MASK EFF_MASK
, CHECKOUT_USER CHECKOUT_USER
, DELETED_FLAG DELETED_FLAG
, EFF_FROM EFF_FROM
, EFF_TO EFF_TO
FROM "CZ"."CZ_CONFIG_USAGES"