VIEW: QPR.QPR_PN_REQUEST_HDRS_B#

Source

View Text - Preformatted

select REQUEST_HEADER_ID REQUEST_HEADER_ID, REQUEST_STATUS REQUEST_STATUS, CUSTOMER_SK CUSTOMER_SK, CUSTOMER_ID CUSTOMER_ID, PN_INT_HEADER_ID PN_INT_HEADER_ID, INSTANCE_ID INSTANCE_ID, SOURCE_ID SOURCE_ID, SOURCE_REF_HDR_ID SOURCE_REF_HDR_ID, SALES_CHANNEL_CODE SALES_CHANNEL_CODE, SALES_CHANNEL_SK SALES_CHANNEL_SK, SALES_REP_ID SALES_REP_ID, SALES_REP_SK SALES_REP_SK, PAYMENT_TERMS_ID PAYMENT_TERMS_ID, DEAL_CREATION_DATE DEAL_CREATION_DATE, DEAL_EXPIRY_DATE DEAL_EXPIRY_DATE, INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID, INVOICE_TO_PARTY_SITE_ADDRESS INVOICE_TO_PARTY_SITE_ADDRESS, CURRENCY_SHORT_DESC CURRENCY_SHORT_DESC, CURRENCY_LONG_DESC CURRENCY_LONG_DESC, SOURCE_SHORT_DESC SOURCE_SHORT_DESC, SOURCE_LONG_DESC SOURCE_LONG_DESC, SOURCE_REF_HDR_SHORT_DESC SOURCE_REF_HDR_SHORT_DESC, SOURCE_REF_HDR_LONG_DESC SOURCE_REF_HDR_LONG_DESC, CUSTOMER_SHORT_DESC CUSTOMER_SHORT_DESC, CUSTOMER_LONG_DESC CUSTOMER_LONG_DESC, SALES_REP_EMAIL SALES_REP_EMAIL, SALES_REP_SHORT_DESC SALES_REP_SHORT_DESC, SALES_REP_LONG_DESC SALES_REP_LONG_DESC, 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, PAYMENT_TERMS_SHORT_DESC PAYMENT_TERMS_SHORT_DESC, PAYMENT_TERMS_LONG_DESC PAYMENT_TERMS_LONG_DESC, SIMULATION_FLAG SIMULATION_FLAG, COMMENTS COMMENTS, 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, 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_REQUEST_HDRS_B"

View Text - HTML Formatted

SELECT REQUEST_HEADER_ID REQUEST_HEADER_ID
, REQUEST_STATUS REQUEST_STATUS
, CUSTOMER_SK CUSTOMER_SK
, CUSTOMER_ID CUSTOMER_ID
, PN_INT_HEADER_ID PN_INT_HEADER_ID
, INSTANCE_ID INSTANCE_ID
, SOURCE_ID SOURCE_ID
, SOURCE_REF_HDR_ID SOURCE_REF_HDR_ID
, SALES_CHANNEL_CODE SALES_CHANNEL_CODE
, SALES_CHANNEL_SK SALES_CHANNEL_SK
, SALES_REP_ID SALES_REP_ID
, SALES_REP_SK SALES_REP_SK
, PAYMENT_TERMS_ID PAYMENT_TERMS_ID
, DEAL_CREATION_DATE DEAL_CREATION_DATE
, DEAL_EXPIRY_DATE DEAL_EXPIRY_DATE
, INVOICE_TO_PARTY_SITE_ID INVOICE_TO_PARTY_SITE_ID
, INVOICE_TO_PARTY_SITE_ADDRESS INVOICE_TO_PARTY_SITE_ADDRESS
, CURRENCY_SHORT_DESC CURRENCY_SHORT_DESC
, CURRENCY_LONG_DESC CURRENCY_LONG_DESC
, SOURCE_SHORT_DESC SOURCE_SHORT_DESC
, SOURCE_LONG_DESC SOURCE_LONG_DESC
, SOURCE_REF_HDR_SHORT_DESC SOURCE_REF_HDR_SHORT_DESC
, SOURCE_REF_HDR_LONG_DESC SOURCE_REF_HDR_LONG_DESC
, CUSTOMER_SHORT_DESC CUSTOMER_SHORT_DESC
, CUSTOMER_LONG_DESC CUSTOMER_LONG_DESC
, SALES_REP_EMAIL SALES_REP_EMAIL
, SALES_REP_SHORT_DESC SALES_REP_SHORT_DESC
, SALES_REP_LONG_DESC SALES_REP_LONG_DESC
, 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
, PAYMENT_TERMS_SHORT_DESC PAYMENT_TERMS_SHORT_DESC
, PAYMENT_TERMS_LONG_DESC PAYMENT_TERMS_LONG_DESC
, SIMULATION_FLAG SIMULATION_FLAG
, COMMENTS COMMENTS
, 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
, 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_REQUEST_HDRS_B"