VIEW: APPS.QP_PRICE_BOOK_HEADERS_VL

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, T.PRICE_BOOK_NAME, T.PL_AGR_BSA_NAME, B.CUST_ACCOUNT_ID, T.LANGUAGE, T.SOURCE_LANG, 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
, T.PRICE_BOOK_NAME
, T.PL_AGR_BSA_NAME
, B.CUST_ACCOUNT_ID
, T.LANGUAGE
, T.SOURCE_LANG
, 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')