VIEW: AR.AR_COGS_REV_ITF#

Source

View Text - Preformatted

select REQUEST_ID REQUEST_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, SET_OF_BOOKS_ID SET_OF_BOOKS_ID, COGS_GL_ACCOUNT COGS_GL_ACCOUNT, COGS_ACCT_DESCRIPTION COGS_ACCT_DESCRIPTION, CUSTOMER_NAME CUSTOMER_NAME, SALES_ORDER_TYPE SALES_ORDER_TYPE, SALES_ORDER SALES_ORDER, SALES_ORDER_LINE SALES_ORDER_LINE, TRX_CLASS TRX_CLASS, TRX_NUMBER TRX_NUMBER, TRX_LINE_NUMBER TRX_LINE_NUMBER, ORDER_AMOUNT_ORIG ORDER_AMOUNT_ORIG, COGS_AMOUNT_ORIG COGS_AMOUNT_ORIG, COGS_AMOUNT_PERIOD COGS_AMOUNT_PERIOD, COGS_PERCENT_PERIOD COGS_PERCENT_PERIOD, REV_AMOUNT_PERIOD REV_AMOUNT_PERIOD, REV_PERCENT_PERIOD REV_PERCENT_PERIOD, COGS_ADJUSTMENT COGS_ADJUSTMENT from "AR"."AR_COGS_REV_ITF"

View Text - HTML Formatted

SELECT REQUEST_ID REQUEST_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, COGS_GL_ACCOUNT COGS_GL_ACCOUNT
, COGS_ACCT_DESCRIPTION COGS_ACCT_DESCRIPTION
, CUSTOMER_NAME CUSTOMER_NAME
, SALES_ORDER_TYPE SALES_ORDER_TYPE
, SALES_ORDER SALES_ORDER
, SALES_ORDER_LINE SALES_ORDER_LINE
, TRX_CLASS TRX_CLASS
, TRX_NUMBER TRX_NUMBER
, TRX_LINE_NUMBER TRX_LINE_NUMBER
, ORDER_AMOUNT_ORIG ORDER_AMOUNT_ORIG
, COGS_AMOUNT_ORIG COGS_AMOUNT_ORIG
, COGS_AMOUNT_PERIOD COGS_AMOUNT_PERIOD
, COGS_PERCENT_PERIOD COGS_PERCENT_PERIOD
, REV_AMOUNT_PERIOD REV_AMOUNT_PERIOD
, REV_PERCENT_PERIOD REV_PERCENT_PERIOD
, COGS_ADJUSTMENT COGS_ADJUSTMENT
FROM "AR"."AR_COGS_REV_ITF"