eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: OKS.OKS_CASCADE_CONC_REQ#

Source

View Text - Preformatted


select CHR_ID CHR_ID, CLE_ID CLE_ID, HEADER_STO HEADER_STO, HEADER_BTO HEADER_BTO, HEADER_DATES HEADER_DATES, HEADER_ARL HEADER_ARL, HEADER_IRE HEADER_IRE, HEADER_TAX HEADER_TAX, HEADER_EXCEPTION_NUMBER HEADER_EXCEPTION_NUMBER, HEADER_BCA HEADER_BCA, HEADER_SCA HEADER_SCA, HEADER_TAX_CODE_ID HEADER_TAX_CODE_ID, HEADER_TAX_CODE HEADER_TAX_CODE, HEADER_SALES_CREDITS HEADER_SALES_CREDITS, HEADER_BILLTO_CONTACT HEADER_BILLTO_CONTACT, BILLTO_ID BILLTO_ID, BILLING_PROFILE BILLING_PROFILE, BILLING_PROFILE_ID BILLING_PROFILE_ID, CALCULATE_TAX CALCULATE_TAX, PAYMENT_METHOD PAYMENT_METHOD, PRICE_UOM PRICE_UOM, PRICE_LIST PRICE_LIST, HEADER_TAX_CLS_CODE HEADER_TAX_CLS_CODE from "OKS"."OKS_CASCADE_CONC_REQ"

View Text - HTML Formatted

SELECT CHR_ID CHR_ID
, CLE_ID CLE_ID
, HEADER_STO HEADER_STO
, HEADER_BTO HEADER_BTO
, HEADER_DATES HEADER_DATES
, HEADER_ARL HEADER_ARL
, HEADER_IRE HEADER_IRE
, HEADER_TAX HEADER_TAX
, HEADER_EXCEPTION_NUMBER HEADER_EXCEPTION_NUMBER
, HEADER_BCA HEADER_BCA
, HEADER_SCA HEADER_SCA
, HEADER_TAX_CODE_ID HEADER_TAX_CODE_ID
, HEADER_TAX_CODE HEADER_TAX_CODE
, HEADER_SALES_CREDITS HEADER_SALES_CREDITS
, HEADER_BILLTO_CONTACT HEADER_BILLTO_CONTACT
, BILLTO_ID BILLTO_ID
, BILLING_PROFILE BILLING_PROFILE
, BILLING_PROFILE_ID BILLING_PROFILE_ID
, CALCULATE_TAX CALCULATE_TAX
, PAYMENT_METHOD PAYMENT_METHOD
, PRICE_UOM PRICE_UOM
, PRICE_LIST PRICE_LIST
, HEADER_TAX_CLS_CODE HEADER_TAX_CLS_CODE
FROM "OKS"."OKS_CASCADE_CONC_REQ"