VIEW: QPR.QPR_PN_INT_LINES#

Source

View Text - Preformatted

select PN_INT_LINE_ID PN_INT_LINE_ID, SOURCE_ID SOURCE_ID, SOURCE_REF_HDR_ID SOURCE_REF_HDR_ID, SOURCE_REF_LINE_ID SOURCE_REF_LINE_ID, SOURCE_REQUEST_LINE_NUMBER SOURCE_REQUEST_LINE_NUMBER, PRICE_PLAN_ID PRICE_PLAN_ID, ORG_ID ORG_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, GEOGRAPHY_ID GEOGRAPHY_ID, PAYMENT_TERM_ID PAYMENT_TERM_ID, PR_SEGMENT_ID PR_SEGMENT_ID, VOL_BAND_SK VOL_BAND_SK, TOP_MDL_SRC_LINE_ID TOP_MDL_SRC_LINE_ID, PN_REQ_LINE_STATUS_FLAG PN_REQ_LINE_STATUS_FLAG, UOM_CODE UOM_CODE, CURRENCY_CODE CURRENCY_CODE, ITEM_TYPE_CODE ITEM_TYPE_CODE, ORDERED_QTY ORDERED_QTY, REVISED_OQ REVISED_OQ, LIST_PRICE LIST_PRICE, PROPOSED_PRICE PROPOSED_PRICE, COMPETITOR_PRICE COMPETITOR_PRICE, DATAMART_NAME DATAMART_NAME, ORG_LONG_DESC ORG_LONG_DESC, ORG_SHORT_DESC ORG_SHORT_DESC, COMPETITOR_NAME COMPETITOR_NAME, INVENTORY_ITEM_SHORT_DESC INVENTORY_ITEM_SHORT_DESC, INVENTORY_ITEM_LONG_DESC INVENTORY_ITEM_LONG_DESC, GEOGRAPHY_SHORT_DESC GEOGRAPHY_SHORT_DESC, GEOGRAPHY_LONG_DESC GEOGRAPHY_LONG_DESC, PAYMENT_TERM_SHORT_DESC PAYMENT_TERM_SHORT_DESC, PAYMENT_TERM_LONG_DESC PAYMENT_TERM_LONG_DESC, CURRENCY_SHORT_DESC CURRENCY_SHORT_DESC, UOM_SHORT_DESC UOM_SHORT_DESC, SHIP_METHOD_CODE SHIP_METHOD_CODE, SHIP_METHOD_SHORT_DESC SHIP_METHOD_SHORT_DESC, SHIP_METHOD_LONG_DESC SHIP_METHOD_LONG_DESC, COMMENTS COMMENTS, ADDITIONAL_INFORMATION ADDITIONAL_INFORMATION, REGRESSION_SLOPE REGRESSION_SLOPE, REGRESSION_INTERCEPT REGRESSION_INTERCEPT, 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, FREIGHT_CHARGES FREIGHT_CHARGES, 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_LINES"

View Text - HTML Formatted

SELECT PN_INT_LINE_ID PN_INT_LINE_ID
, SOURCE_ID SOURCE_ID
, SOURCE_REF_HDR_ID SOURCE_REF_HDR_ID
, SOURCE_REF_LINE_ID SOURCE_REF_LINE_ID
, SOURCE_REQUEST_LINE_NUMBER SOURCE_REQUEST_LINE_NUMBER
, PRICE_PLAN_ID PRICE_PLAN_ID
, ORG_ID ORG_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, GEOGRAPHY_ID GEOGRAPHY_ID
, PAYMENT_TERM_ID PAYMENT_TERM_ID
, PR_SEGMENT_ID PR_SEGMENT_ID
, VOL_BAND_SK VOL_BAND_SK
, TOP_MDL_SRC_LINE_ID TOP_MDL_SRC_LINE_ID
, PN_REQ_LINE_STATUS_FLAG PN_REQ_LINE_STATUS_FLAG
, UOM_CODE UOM_CODE
, CURRENCY_CODE CURRENCY_CODE
, ITEM_TYPE_CODE ITEM_TYPE_CODE
, ORDERED_QTY ORDERED_QTY
, REVISED_OQ REVISED_OQ
, LIST_PRICE LIST_PRICE
, PROPOSED_PRICE PROPOSED_PRICE
, COMPETITOR_PRICE COMPETITOR_PRICE
, DATAMART_NAME DATAMART_NAME
, ORG_LONG_DESC ORG_LONG_DESC
, ORG_SHORT_DESC ORG_SHORT_DESC
, COMPETITOR_NAME COMPETITOR_NAME
, INVENTORY_ITEM_SHORT_DESC INVENTORY_ITEM_SHORT_DESC
, INVENTORY_ITEM_LONG_DESC INVENTORY_ITEM_LONG_DESC
, GEOGRAPHY_SHORT_DESC GEOGRAPHY_SHORT_DESC
, GEOGRAPHY_LONG_DESC GEOGRAPHY_LONG_DESC
, PAYMENT_TERM_SHORT_DESC PAYMENT_TERM_SHORT_DESC
, PAYMENT_TERM_LONG_DESC PAYMENT_TERM_LONG_DESC
, CURRENCY_SHORT_DESC CURRENCY_SHORT_DESC
, UOM_SHORT_DESC UOM_SHORT_DESC
, SHIP_METHOD_CODE SHIP_METHOD_CODE
, SHIP_METHOD_SHORT_DESC SHIP_METHOD_SHORT_DESC
, SHIP_METHOD_LONG_DESC SHIP_METHOD_LONG_DESC
, COMMENTS COMMENTS
, ADDITIONAL_INFORMATION ADDITIONAL_INFORMATION
, REGRESSION_SLOPE REGRESSION_SLOPE
, REGRESSION_INTERCEPT REGRESSION_INTERCEPT
, 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
, FREIGHT_CHARGES FREIGHT_CHARGES
, 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_LINES"