VIEW: APPS.QP_PRICE_BOOK_LINES_V

Source

View Text - Preformatted

SELECT L.RowId ROW_ID, L.PRICE_BOOK_LINE_ID, L.PRICE_BOOK_HEADER_ID, L.ITEM_NUMBER , L.PRODUCT_UOM_CODE , L.LIST_PRICE , L.NET_PRICE , L.SYNC_ACTION_CODE , L.LINE_STATUS_CODE, L.CREATION_DATE , L.CREATED_BY , L.LAST_UPDATE_DATE , L.LAST_UPDATED_BY , L.LAST_UPDATE_LOGIN , QP_Price_Book_Util.get_item_description(L.ITEM_NUMBER,L.PRICE_BOOK_HEADER_ID) DESCRIPTION, QP_Price_Book_Util.get_customer_number(L.ITEM_NUMBER,L.PRICE_BOOK_HEADER_ID) CUSTOMER_ITEM_NUMBER, null CATEGORY_NAME, null CATEGORY_DESCRIPTION, QP_Price_Book_Util.get_item_number(L.ITEM_NUMBER, L.PRICE_BOOK_HEADER_ID) DISPLAY_ITEM_NUMBER, QP_Price_Book_Util.value_to_meaning(L.SYNC_ACTION_CODE,'SYNC_ACTION_CODE') SYNC_ACTION, QP_Price_Book_Util.Get_Customer_Item_Desc(L.ITEM_NUMBER,L.PRICE_BOOK_HEADER_ID) Customer_Item_Desc FROM QP_PRICE_BOOK_LINES L

View Text - HTML Formatted

SELECT L.ROWID ROW_ID
, L.PRICE_BOOK_LINE_ID
, L.PRICE_BOOK_HEADER_ID
, L.ITEM_NUMBER
, L.PRODUCT_UOM_CODE
, L.LIST_PRICE
, L.NET_PRICE
, L.SYNC_ACTION_CODE
, L.LINE_STATUS_CODE
, L.CREATION_DATE
, L.CREATED_BY
, L.LAST_UPDATE_DATE
, L.LAST_UPDATED_BY
, L.LAST_UPDATE_LOGIN
, QP_PRICE_BOOK_UTIL.GET_ITEM_DESCRIPTION(L.ITEM_NUMBER
, L.PRICE_BOOK_HEADER_ID) DESCRIPTION
, QP_PRICE_BOOK_UTIL.GET_CUSTOMER_NUMBER(L.ITEM_NUMBER
, L.PRICE_BOOK_HEADER_ID) CUSTOMER_ITEM_NUMBER
, NULL CATEGORY_NAME
, NULL CATEGORY_DESCRIPTION
, QP_PRICE_BOOK_UTIL.GET_ITEM_NUMBER(L.ITEM_NUMBER
, L.PRICE_BOOK_HEADER_ID) DISPLAY_ITEM_NUMBER
, QP_PRICE_BOOK_UTIL.VALUE_TO_MEANING(L.SYNC_ACTION_CODE
, 'SYNC_ACTION_CODE') SYNC_ACTION
, QP_PRICE_BOOK_UTIL.GET_CUSTOMER_ITEM_DESC(L.ITEM_NUMBER
, L.PRICE_BOOK_HEADER_ID) CUSTOMER_ITEM_DESC
FROM QP_PRICE_BOOK_LINES L