VIEW: APPS.QP_PRICE_BOOK_HEADERS_V

Source

View Text - Preformatted

SELECT B.RowId ROW_ID, B.PRICE_BOOK_HEADER_ID, B.CREATION_DATE, B.CREATED_BY, B.LAST_UPDATE_DATE, B.LAST_UPDATED_BY, B.LAST_UPDATE_LOGIN, B.PRICE_BOOK_TYPE_CODE, B.CURRENCY_CODE, B.EFFECTIVE_DATE, B.ORG_ID, B.CUSTOMER_ID, B.ITEM_CATEGORY, B.PRICE_BASED_ON, B.PL_AGR_BSA_ID, B.PRICING_PERSPECTIVE_CODE, B.ITEM_QUANTITY, B.REQUEST_ID, B.REQUEST_TYPE_CODE, B.PB_INPUT_HEADER_ID, B.PUB_STATUS_CODE, QP_Price_Book_Util.value_to_meaning(B.PRICE_BOOK_TYPE_CODE,'PRICE_BOOK_TYPE_CODE') PRICE_BOOK_TYPE, QP_Price_Book_Util.get_currency_name(B.CURRENCY_CODE), QP_Price_Book_Util.get_operating_unit(B.ORG_ID) OPERATING_UNIT, QP_Price_Book_Util.get_customer_name(B.CUSTOMER_ID) CUSTOMER_NAME, T.PRICE_BOOK_NAME, T.PL_AGR_BSA_NAME, T.LANGUAGE, T.SOURCE_LANG, B.CUST_ACCOUNT_ID, B.DOCUMENT_ID FROM QP_PRICE_BOOK_HEADERS_B B,QP_PRICE_BOOK_HEADERS_TL T WHERE B.PRICE_BOOK_HEADER_ID = T.PRICE_BOOK_HEADER_ID and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.PRICE_BOOK_HEADER_ID
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.PRICE_BOOK_TYPE_CODE
, B.CURRENCY_CODE
, B.EFFECTIVE_DATE
, B.ORG_ID
, B.CUSTOMER_ID
, B.ITEM_CATEGORY
, B.PRICE_BASED_ON
, B.PL_AGR_BSA_ID
, B.PRICING_PERSPECTIVE_CODE
, B.ITEM_QUANTITY
, B.REQUEST_ID
, B.REQUEST_TYPE_CODE
, B.PB_INPUT_HEADER_ID
, B.PUB_STATUS_CODE
, QP_PRICE_BOOK_UTIL.VALUE_TO_MEANING(B.PRICE_BOOK_TYPE_CODE
, 'PRICE_BOOK_TYPE_CODE') PRICE_BOOK_TYPE
, QP_PRICE_BOOK_UTIL.GET_CURRENCY_NAME(B.CURRENCY_CODE)
, QP_PRICE_BOOK_UTIL.GET_OPERATING_UNIT(B.ORG_ID) OPERATING_UNIT
, QP_PRICE_BOOK_UTIL.GET_CUSTOMER_NAME(B.CUSTOMER_ID) CUSTOMER_NAME
, T.PRICE_BOOK_NAME
, T.PL_AGR_BSA_NAME
, T.LANGUAGE
, T.SOURCE_LANG
, B.CUST_ACCOUNT_ID
, B.DOCUMENT_ID
FROM QP_PRICE_BOOK_HEADERS_B B
, QP_PRICE_BOOK_HEADERS_TL T
WHERE B.PRICE_BOOK_HEADER_ID = T.PRICE_BOOK_HEADER_ID
AND T.LANGUAGE = USERENV('LANG')