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.

[Home] [Help]

VIEW: CZ.CZ_QUOTE_HDRS#

Source

View Text - Preformatted


select LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, QUOTE_HDR_ID QUOTE_HDR_ID, QUOTE_REV_NBR QUOTE_REV_NBR, BILLTO_CONTACT_ID BILLTO_CONTACT_ID, BILLTO_ADDRESS_ID BILLTO_ADDRESS_ID, MAIN_CONTACT_ID MAIN_CONTACT_ID, BILLTO_CUSTOMER_ID BILLTO_CUSTOMER_ID, TAX_STATE TAX_STATE, SHIPPING SHIPPING, BOM_DOC_PATH_NAME BOM_DOC_PATH_NAME, QUOTE_NOTE_REP QUOTE_NOTE_REP, QUOTE_DOC_PATH_NAME QUOTE_DOC_PATH_NAME, QUOTE_SHORTDOC_PATH_NAME QUOTE_SHORTDOC_PATH_NAME, USER_ID_CREATED USER_ID_CREATED, USER_ID_FOR_WHOM_CREATED USER_ID_FOR_WHOM_CREATED, QUOTE_VIOLATION_FLAG QUOTE_VIOLATION_FLAG, TAX_CITY TAX_CITY, OPPORTUNITY_HDR_ID OPPORTUNITY_HDR_ID, QUOTE_NAME QUOTE_NAME, QUOTE_DESC QUOTE_DESC, DISC_PERCENTAGE DISC_PERCENTAGE, DISC_TYPE DISC_TYPE, QUOTE_CREATED_DATE QUOTE_CREATED_DATE, QUOTE_EXPIRATION_DATE QUOTE_EXPIRATION_DATE, QUOTE_EFFECTIVE_DATE QUOTE_EFFECTIVE_DATE, QUOTE_NOTE_PRINT QUOTE_NOTE_PRINT, QUOTE_STATUS QUOTE_STATUS, OTHER_CHARGES OTHER_CHARGES, TAX_FEDERAL TAX_FEDERAL, PRICE_GROUP_ID PRICE_GROUP_ID, SHIPTO_CONTACT_ID SHIPTO_CONTACT_ID, TOTAL_QUOTED_PRICE TOTAL_QUOTED_PRICE, ORDER_REQUEST_FLAG ORDER_REQUEST_FLAG, ORACLE_PRICING_FLAG ORACLE_PRICING_FLAG, SHIPTO_CUSTOMER_ID SHIPTO_CUSTOMER_ID, SHIPTO_ADDRESS_ID SHIPTO_ADDRESS_ID, ORDER_SUBMITTED_DATE ORDER_SUBMITTED_DATE, SO_PRICE_LIST_ID SO_PRICE_LIST_ID, USER_NUM01 USER_NUM01, USER_NUM02 USER_NUM02, USER_NUM03 USER_NUM03, USER_NUM04 USER_NUM04, USER_STR01 USER_STR01, USER_STR02 USER_STR02, USER_STR03 USER_STR03, USER_STR04 USER_STR04, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, DELETED_FLAG DELETED_FLAG, EFF_FROM EFF_FROM, EFF_TO EFF_TO, CREATED_BY CREATED_BY, LAST_UPDATED_BY LAST_UPDATED_BY, SECURITY_MASK SECURITY_MASK, EFF_MASK EFF_MASK, CHECKOUT_USER CHECKOUT_USER from "CZ"."CZ_QUOTE_HDRS"

View Text - HTML Formatted

SELECT LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, QUOTE_HDR_ID QUOTE_HDR_ID
, QUOTE_REV_NBR QUOTE_REV_NBR
, BILLTO_CONTACT_ID BILLTO_CONTACT_ID
, BILLTO_ADDRESS_ID BILLTO_ADDRESS_ID
, MAIN_CONTACT_ID MAIN_CONTACT_ID
, BILLTO_CUSTOMER_ID BILLTO_CUSTOMER_ID
, TAX_STATE TAX_STATE
, SHIPPING SHIPPING
, BOM_DOC_PATH_NAME BOM_DOC_PATH_NAME
, QUOTE_NOTE_REP QUOTE_NOTE_REP
, QUOTE_DOC_PATH_NAME QUOTE_DOC_PATH_NAME
, QUOTE_SHORTDOC_PATH_NAME QUOTE_SHORTDOC_PATH_NAME
, USER_ID_CREATED USER_ID_CREATED
, USER_ID_FOR_WHOM_CREATED USER_ID_FOR_WHOM_CREATED
, QUOTE_VIOLATION_FLAG QUOTE_VIOLATION_FLAG
, TAX_CITY TAX_CITY
, OPPORTUNITY_HDR_ID OPPORTUNITY_HDR_ID
, QUOTE_NAME QUOTE_NAME
, QUOTE_DESC QUOTE_DESC
, DISC_PERCENTAGE DISC_PERCENTAGE
, DISC_TYPE DISC_TYPE
, QUOTE_CREATED_DATE QUOTE_CREATED_DATE
, QUOTE_EXPIRATION_DATE QUOTE_EXPIRATION_DATE
, QUOTE_EFFECTIVE_DATE QUOTE_EFFECTIVE_DATE
, QUOTE_NOTE_PRINT QUOTE_NOTE_PRINT
, QUOTE_STATUS QUOTE_STATUS
, OTHER_CHARGES OTHER_CHARGES
, TAX_FEDERAL TAX_FEDERAL
, PRICE_GROUP_ID PRICE_GROUP_ID
, SHIPTO_CONTACT_ID SHIPTO_CONTACT_ID
, TOTAL_QUOTED_PRICE TOTAL_QUOTED_PRICE
, ORDER_REQUEST_FLAG ORDER_REQUEST_FLAG
, ORACLE_PRICING_FLAG ORACLE_PRICING_FLAG
, SHIPTO_CUSTOMER_ID SHIPTO_CUSTOMER_ID
, SHIPTO_ADDRESS_ID SHIPTO_ADDRESS_ID
, ORDER_SUBMITTED_DATE ORDER_SUBMITTED_DATE
, SO_PRICE_LIST_ID SO_PRICE_LIST_ID
, USER_NUM01 USER_NUM01
, USER_NUM02 USER_NUM02
, USER_NUM03 USER_NUM03
, USER_NUM04 USER_NUM04
, USER_STR01 USER_STR01
, USER_STR02 USER_STR02
, USER_STR03 USER_STR03
, USER_STR04 USER_STR04
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, DELETED_FLAG DELETED_FLAG
, EFF_FROM EFF_FROM
, EFF_TO EFF_TO
, CREATED_BY CREATED_BY
, LAST_UPDATED_BY LAST_UPDATED_BY
, SECURITY_MASK SECURITY_MASK
, EFF_MASK EFF_MASK
, CHECKOUT_USER CHECKOUT_USER
FROM "CZ"."CZ_QUOTE_HDRS"