VIEW: OZF.OZF_SD_RES_HEADER_INTF#

Source

View Text - Preformatted

select GLBDOCFUNCCODE GLBDOCFUNCCODE, REQDOCDATETIME REQDOCDATETIME, REQDOCID REQDOCID, THISDOCGENDTTIME THISDOCGENDTTIME, BLANKET_FLAG BLANKET_FLAG, SUPP_QUOTE_NUMBER SUPP_QUOTE_NUMBER, AUTH_NUMBER AUTH_NUMBER, FROMROLE_CINFO_CTNAME FROMROLE_CINFO_CTNAME, FROMROLE_CINFO_EMAIL FROMROLE_CINFO_EMAIL, FROMROLE_CINFO_TEL_NUMBER FROMROLE_CINFO_TEL_NUMBER, FROMROLE_GLBPRTRCCODE FROMROLE_GLBPRTRCCODE, FROMROLE_B_BNAME FROMROLE_B_BNAME, FROMROLE_P_BUSDESC_GLBBUSID FROMROLE_P_BUSDESC_GLBBUSID, FROMROLE_P_BUSDESC_GLBSUPPCODE FROMROLE_P_BUSDESC_GLBSUPPCODE, FROMROLE_P_CTINFO_CNAME FROMROLE_P_CTINFO_CNAME, FROMROLE_P_CTINFO_EMAIL FROMROLE_P_CTINFO_EMAIL, FROMROLE_P_CTINFO_TELE_NUM FROMROLE_P_CTINFO_TELE_NUM, FROMROLE_P_GLBPRTCCODE FROMROLE_P_GLBPRTCCODE, FROMROLE_P_PLOC_ADD1 FROMROLE_P_PLOC_ADD1, FROMROLE_P_PLOC_ADD2 FROMROLE_P_PLOC_ADD2, FROMROLE_P_PLOC_ADD3 FROMROLE_P_PLOC_ADD3, FROMROLE_P_PLOC_CITY FROMROLE_P_PLOC_CITY, FROMROLE_P_PLOC_COUNTRY FROMROLE_P_PLOC_COUNTRY, FROMROLE_P_PLOC_POSTALCODE FROMROLE_P_PLOC_POSTALCODE, FROMROLE_P_PLOC_POBOXID FROMROLE_P_PLOC_POBOXID, FROMROLE_P_PLOC_REGION FROMROLE_P_PLOC_REGION, TOROLE_CINFO_CTNAME TOROLE_CINFO_CTNAME, TOROLE_CINFO_EMAIL TOROLE_CINFO_EMAIL, TOROLE_CINFO_TEL_NUMBER TOROLE_CINFO_TEL_NUMBER, TOROLE_GLBPRTRCCODE TOROLE_GLBPRTRCCODE, TOROLE_B_BNAME TOROLE_B_BNAME, TOROLE_P_BUSDESC_GLBBUSID TOROLE_P_BUSDESC_GLBBUSID, TOROLE_P_BUSDESC_GLBSUPPCODE TOROLE_P_BUSDESC_GLBSUPPCODE, TOROLE_P_CTINFO_CNAME TOROLE_P_CTINFO_CNAME, TOROLE_P_CTINFO_EMAIL TOROLE_P_CTINFO_EMAIL, TOROLE_P_CTINFO_TELE_NUM TOROLE_P_CTINFO_TELE_NUM, TOROLE_P_GLBPRTCCODE TOROLE_P_GLBPRTCCODE, TOROLE_P_PLOC_ADD1 TOROLE_P_PLOC_ADD1, TOROLE_P_PLOC_ADD2 TOROLE_P_PLOC_ADD2, TOROLE_P_PLOC_ADD3 TOROLE_P_PLOC_ADD3, TOROLE_P_PLOC_CITY TOROLE_P_PLOC_CITY, TOROLE_P_PLOC_COUNTRY TOROLE_P_PLOC_COUNTRY, TOROLE_P_PLOC_POSTALCODE TOROLE_P_PLOC_POSTALCODE, TOROLE_P_PLOC_POBOXID TOROLE_P_PLOC_POBOXID, TOROLE_P_PLOC_REGION TOROLE_P_PLOC_REGION, REQUEST_NUMBER REQUEST_NUMBER, PROCESSED_FLAG PROCESSED_FLAG, ERROR_TXT ERROR_TXT, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY, ATTRIBUTE1 ATTRIBUTE1, ATTRIBUTE2 ATTRIBUTE2, ATTRIBUTE3 ATTRIBUTE3, ATTRIBUTE4 ATTRIBUTE4, ATTRIBUTE5 ATTRIBUTE5, ATTRIBUTE6 ATTRIBUTE6, ATTRIBUTE7 ATTRIBUTE7, ATTRIBUTE8 ATTRIBUTE8, ATTRIBUTE9 ATTRIBUTE9, ATTRIBUTE10 ATTRIBUTE10, ATTRIBUTE11 ATTRIBUTE11, ATTRIBUTE12 ATTRIBUTE12, ATTRIBUTE13 ATTRIBUTE13, ATTRIBUTE14 ATTRIBUTE14, ATTRIBUTE15 ATTRIBUTE15, RES_HEADER_INTF_ID RES_HEADER_INTF_ID from "OZF"."OZF_SD_RES_HEADER_INTF"

View Text - HTML Formatted

SELECT GLBDOCFUNCCODE GLBDOCFUNCCODE
, REQDOCDATETIME REQDOCDATETIME
, REQDOCID REQDOCID
, THISDOCGENDTTIME THISDOCGENDTTIME
, BLANKET_FLAG BLANKET_FLAG
, SUPP_QUOTE_NUMBER SUPP_QUOTE_NUMBER
, AUTH_NUMBER AUTH_NUMBER
, FROMROLE_CINFO_CTNAME FROMROLE_CINFO_CTNAME
, FROMROLE_CINFO_EMAIL FROMROLE_CINFO_EMAIL
, FROMROLE_CINFO_TEL_NUMBER FROMROLE_CINFO_TEL_NUMBER
, FROMROLE_GLBPRTRCCODE FROMROLE_GLBPRTRCCODE
, FROMROLE_B_BNAME FROMROLE_B_BNAME
, FROMROLE_P_BUSDESC_GLBBUSID FROMROLE_P_BUSDESC_GLBBUSID
, FROMROLE_P_BUSDESC_GLBSUPPCODE FROMROLE_P_BUSDESC_GLBSUPPCODE
, FROMROLE_P_CTINFO_CNAME FROMROLE_P_CTINFO_CNAME
, FROMROLE_P_CTINFO_EMAIL FROMROLE_P_CTINFO_EMAIL
, FROMROLE_P_CTINFO_TELE_NUM FROMROLE_P_CTINFO_TELE_NUM
, FROMROLE_P_GLBPRTCCODE FROMROLE_P_GLBPRTCCODE
, FROMROLE_P_PLOC_ADD1 FROMROLE_P_PLOC_ADD1
, FROMROLE_P_PLOC_ADD2 FROMROLE_P_PLOC_ADD2
, FROMROLE_P_PLOC_ADD3 FROMROLE_P_PLOC_ADD3
, FROMROLE_P_PLOC_CITY FROMROLE_P_PLOC_CITY
, FROMROLE_P_PLOC_COUNTRY FROMROLE_P_PLOC_COUNTRY
, FROMROLE_P_PLOC_POSTALCODE FROMROLE_P_PLOC_POSTALCODE
, FROMROLE_P_PLOC_POBOXID FROMROLE_P_PLOC_POBOXID
, FROMROLE_P_PLOC_REGION FROMROLE_P_PLOC_REGION
, TOROLE_CINFO_CTNAME TOROLE_CINFO_CTNAME
, TOROLE_CINFO_EMAIL TOROLE_CINFO_EMAIL
, TOROLE_CINFO_TEL_NUMBER TOROLE_CINFO_TEL_NUMBER
, TOROLE_GLBPRTRCCODE TOROLE_GLBPRTRCCODE
, TOROLE_B_BNAME TOROLE_B_BNAME
, TOROLE_P_BUSDESC_GLBBUSID TOROLE_P_BUSDESC_GLBBUSID
, TOROLE_P_BUSDESC_GLBSUPPCODE TOROLE_P_BUSDESC_GLBSUPPCODE
, TOROLE_P_CTINFO_CNAME TOROLE_P_CTINFO_CNAME
, TOROLE_P_CTINFO_EMAIL TOROLE_P_CTINFO_EMAIL
, TOROLE_P_CTINFO_TELE_NUM TOROLE_P_CTINFO_TELE_NUM
, TOROLE_P_GLBPRTCCODE TOROLE_P_GLBPRTCCODE
, TOROLE_P_PLOC_ADD1 TOROLE_P_PLOC_ADD1
, TOROLE_P_PLOC_ADD2 TOROLE_P_PLOC_ADD2
, TOROLE_P_PLOC_ADD3 TOROLE_P_PLOC_ADD3
, TOROLE_P_PLOC_CITY TOROLE_P_PLOC_CITY
, TOROLE_P_PLOC_COUNTRY TOROLE_P_PLOC_COUNTRY
, TOROLE_P_PLOC_POSTALCODE TOROLE_P_PLOC_POSTALCODE
, TOROLE_P_PLOC_POBOXID TOROLE_P_PLOC_POBOXID
, TOROLE_P_PLOC_REGION TOROLE_P_PLOC_REGION
, REQUEST_NUMBER REQUEST_NUMBER
, PROCESSED_FLAG PROCESSED_FLAG
, ERROR_TXT ERROR_TXT
, ATTRIBUTE_CATEGORY ATTRIBUTE_CATEGORY
, ATTRIBUTE1 ATTRIBUTE1
, ATTRIBUTE2 ATTRIBUTE2
, ATTRIBUTE3 ATTRIBUTE3
, ATTRIBUTE4 ATTRIBUTE4
, ATTRIBUTE5 ATTRIBUTE5
, ATTRIBUTE6 ATTRIBUTE6
, ATTRIBUTE7 ATTRIBUTE7
, ATTRIBUTE8 ATTRIBUTE8
, ATTRIBUTE9 ATTRIBUTE9
, ATTRIBUTE10 ATTRIBUTE10
, ATTRIBUTE11 ATTRIBUTE11
, ATTRIBUTE12 ATTRIBUTE12
, ATTRIBUTE13 ATTRIBUTE13
, ATTRIBUTE14 ATTRIBUTE14
, ATTRIBUTE15 ATTRIBUTE15
, RES_HEADER_INTF_ID RES_HEADER_INTF_ID
FROM "OZF"."OZF_SD_RES_HEADER_INTF"