VIEW: QP.QP_PRICE_BOOK_HEADERS_ALL_B#

Source

View Text - Preformatted

select PRICE_BOOK_HEADER_ID PRICE_BOOK_HEADER_ID, PRICE_BOOK_TYPE_CODE PRICE_BOOK_TYPE_CODE, CURRENCY_CODE CURRENCY_CODE, EFFECTIVE_DATE EFFECTIVE_DATE, ORG_ID ORG_ID, CUSTOMER_ID CUSTOMER_ID, PUB_STATUS_CODE PUB_STATUS_CODE, ITEM_CATEGORY ITEM_CATEGORY, PRICE_BASED_ON PRICE_BASED_ON, PL_AGR_BSA_ID PL_AGR_BSA_ID, PRICING_PERSPECTIVE_CODE PRICING_PERSPECTIVE_CODE, ITEM_QUANTITY ITEM_QUANTITY, REQUEST_ID REQUEST_ID, REQUEST_TYPE_CODE REQUEST_TYPE_CODE, PB_INPUT_HEADER_ID PB_INPUT_HEADER_ID, CUST_ACCOUNT_ID CUST_ACCOUNT_ID, 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, DOCUMENT_ID DOCUMENT_ID from "QP"."QP_PRICE_BOOK_HEADERS_ALL_B"

View Text - HTML Formatted

SELECT PRICE_BOOK_HEADER_ID PRICE_BOOK_HEADER_ID
, PRICE_BOOK_TYPE_CODE PRICE_BOOK_TYPE_CODE
, CURRENCY_CODE CURRENCY_CODE
, EFFECTIVE_DATE EFFECTIVE_DATE
, ORG_ID ORG_ID
, CUSTOMER_ID CUSTOMER_ID
, PUB_STATUS_CODE PUB_STATUS_CODE
, ITEM_CATEGORY ITEM_CATEGORY
, PRICE_BASED_ON PRICE_BASED_ON
, PL_AGR_BSA_ID PL_AGR_BSA_ID
, PRICING_PERSPECTIVE_CODE PRICING_PERSPECTIVE_CODE
, ITEM_QUANTITY ITEM_QUANTITY
, REQUEST_ID REQUEST_ID
, REQUEST_TYPE_CODE REQUEST_TYPE_CODE
, PB_INPUT_HEADER_ID PB_INPUT_HEADER_ID
, CUST_ACCOUNT_ID CUST_ACCOUNT_ID
, 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
, DOCUMENT_ID DOCUMENT_ID
FROM "QP"."QP_PRICE_BOOK_HEADERS_ALL_B"