VIEW: QPR.QPR_PN_INT_HEADERS#

Source

View Text - Preformatted

select PN_INT_HEADER_ID PN_INT_HEADER_ID, SOURCE_ID SOURCE_ID, SOURCE_REF_HEADER_ID SOURCE_REF_HEADER_ID, INSTANCE_ID INSTANCE_ID, PN_REQ_HEADER_CREATION_DATE PN_REQ_HEADER_CREATION_DATE, PN_REQ_EXPIRY_DATE PN_REQ_EXPIRY_DATE, PN_REQ_HEADER_STATUS_FLAG PN_REQ_HEADER_STATUS_FLAG, CUSTOMER_ID CUSTOMER_ID, SALES_REP_ID SALES_REP_ID, INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID, SALES_CHANNEL_CODE SALES_CHANNEL_CODE, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE, CURRENCY_CODE CURRENCY_CODE, SOURCE_LONG_DESC SOURCE_LONG_DESC, SOURCE_REF_HEADER_SHORT_DESC SOURCE_REF_HEADER_SHORT_DESC, SOURCE_SHORT_DESC SOURCE_SHORT_DESC, SOURCE_REF_HEADER_LONG_DESC SOURCE_REF_HEADER_LONG_DESC, CUSTOMER_SHORT_DESC CUSTOMER_SHORT_DESC, CUSTOMER_LONG_DESC CUSTOMER_LONG_DESC, INVOICE_TO_PARTY_SITE_ADDRESS INVOICE_TO_PARTY_SITE_ADDRESS, SALES_REP_SHORT_DESC SALES_REP_SHORT_DESC, SALES_REP_LONG_DESC SALES_REP_LONG_DESC, SALES_REP_EMAIL_ADDRESS SALES_REP_EMAIL_ADDRESS, SALES_CHANNEL_SHORT_DESC SALES_CHANNEL_SHORT_DESC, SALES_CHANNEL_LONG_DESC SALES_CHANNEL_LONG_DESC, FREIGHT_TERMS_SHORT_DESC FREIGHT_TERMS_SHORT_DESC, FREIGHT_TERMS_LONG_DESC FREIGHT_TERMS_LONG_DESC, CURRENCY_SHORT_DESC CURRENCY_SHORT_DESC, CURRENCY_LONG_DESC CURRENCY_LONG_DESC, MEASURE1_NUMBER MEASURE1_NUMBER, MEASURE2_NUMBER MEASURE2_NUMBER, MEASURE3_NUMBER MEASURE3_NUMBER, MEASURE4_NUMBER MEASURE4_NUMBER, MEASURE5_NUMBER MEASURE5_NUMBER, MEASURE6_NUMBER MEASURE6_NUMBER, MEASURE7_NUMBER MEASURE7_NUMBER, MEASURE8_NUMBER MEASURE8_NUMBER, MEASURE9_NUMBER MEASURE9_NUMBER, MEASURE10_NUMBER MEASURE10_NUMBER, MEASURE1_CHAR MEASURE1_CHAR, MEASURE2_CHAR MEASURE2_CHAR, MEASURE3_CHAR MEASURE3_CHAR, MEASURE4_CHAR MEASURE4_CHAR, MEASURE5_CHAR MEASURE5_CHAR, MEASURE6_CHAR MEASURE6_CHAR, MEASURE7_CHAR MEASURE7_CHAR, MEASURE8_CHAR MEASURE8_CHAR, MEASURE9_CHAR MEASURE9_CHAR, MEASURE10_CHAR MEASURE10_CHAR, COMMENTS COMMENTS, ADDITIONAL_INFORMATION ADDITIONAL_INFORMATION, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, PROGRAM_ID PROGRAM_ID, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, REQUEST_ID REQUEST_ID from "QPR"."QPR_PN_INT_HEADERS"

View Text - HTML Formatted

SELECT PN_INT_HEADER_ID PN_INT_HEADER_ID
, SOURCE_ID SOURCE_ID
, SOURCE_REF_HEADER_ID SOURCE_REF_HEADER_ID
, INSTANCE_ID INSTANCE_ID
, PN_REQ_HEADER_CREATION_DATE PN_REQ_HEADER_CREATION_DATE
, PN_REQ_EXPIRY_DATE PN_REQ_EXPIRY_DATE
, PN_REQ_HEADER_STATUS_FLAG PN_REQ_HEADER_STATUS_FLAG
, CUSTOMER_ID CUSTOMER_ID
, SALES_REP_ID SALES_REP_ID
, INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID
, SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, FREIGHT_TERMS_CODE FREIGHT_TERMS_CODE
, CURRENCY_CODE CURRENCY_CODE
, SOURCE_LONG_DESC SOURCE_LONG_DESC
, SOURCE_REF_HEADER_SHORT_DESC SOURCE_REF_HEADER_SHORT_DESC
, SOURCE_SHORT_DESC SOURCE_SHORT_DESC
, SOURCE_REF_HEADER_LONG_DESC SOURCE_REF_HEADER_LONG_DESC
, CUSTOMER_SHORT_DESC CUSTOMER_SHORT_DESC
, CUSTOMER_LONG_DESC CUSTOMER_LONG_DESC
, INVOICE_TO_PARTY_SITE_ADDRESS INVOICE_TO_PARTY_SITE_ADDRESS
, SALES_REP_SHORT_DESC SALES_REP_SHORT_DESC
, SALES_REP_LONG_DESC SALES_REP_LONG_DESC
, SALES_REP_EMAIL_ADDRESS SALES_REP_EMAIL_ADDRESS
, SALES_CHANNEL_SHORT_DESC SALES_CHANNEL_SHORT_DESC
, SALES_CHANNEL_LONG_DESC SALES_CHANNEL_LONG_DESC
, FREIGHT_TERMS_SHORT_DESC FREIGHT_TERMS_SHORT_DESC
, FREIGHT_TERMS_LONG_DESC FREIGHT_TERMS_LONG_DESC
, CURRENCY_SHORT_DESC CURRENCY_SHORT_DESC
, CURRENCY_LONG_DESC CURRENCY_LONG_DESC
, MEASURE1_NUMBER MEASURE1_NUMBER
, MEASURE2_NUMBER MEASURE2_NUMBER
, MEASURE3_NUMBER MEASURE3_NUMBER
, MEASURE4_NUMBER MEASURE4_NUMBER
, MEASURE5_NUMBER MEASURE5_NUMBER
, MEASURE6_NUMBER MEASURE6_NUMBER
, MEASURE7_NUMBER MEASURE7_NUMBER
, MEASURE8_NUMBER MEASURE8_NUMBER
, MEASURE9_NUMBER MEASURE9_NUMBER
, MEASURE10_NUMBER MEASURE10_NUMBER
, MEASURE1_CHAR MEASURE1_CHAR
, MEASURE2_CHAR MEASURE2_CHAR
, MEASURE3_CHAR MEASURE3_CHAR
, MEASURE4_CHAR MEASURE4_CHAR
, MEASURE5_CHAR MEASURE5_CHAR
, MEASURE6_CHAR MEASURE6_CHAR
, MEASURE7_CHAR MEASURE7_CHAR
, MEASURE8_CHAR MEASURE8_CHAR
, MEASURE9_CHAR MEASURE9_CHAR
, MEASURE10_CHAR MEASURE10_CHAR
, COMMENTS COMMENTS
, ADDITIONAL_INFORMATION ADDITIONAL_INFORMATION
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PROGRAM_ID PROGRAM_ID
, PROGRAM_LOGIN_ID PROGRAM_LOGIN_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, REQUEST_ID REQUEST_ID
FROM "QPR"."QPR_PN_INT_HEADERS"