[Home] [Help]
View: XNC_BILLING_PRICELIST_V
Product: | XNC - Sales for Communications (Obsolete) |
Description: | This view provides the list of Price list / Discounts, item/pricing information in Oracle Sales for Communicationsfrom the Advanced Pricing. |
Implementation/DBA Data: |
Not implemented in this database
|
View Text
SELECT DISTINCT A.ROW_ID
, A.LIST_HEADER_ID
, A.NAME PRICE_LIST_NAME
, A.CURRENCY_CODE
, A.LIST_TYPE_CODE
, A.LIST_LINE_TYPE_CODE
, A.LIST_PRICE
, A.LIST_LINE_ID
, A.PRODUCT_UOM_CODE
, M.INVENTORY_ITEM_ID
, M.PADDED_CONCATENATED_SEGMENTS ITEM_NAME
FROM QP_LIST_ATTRIBUTES_V A
, MTL_SYSTEM_ITEMS_KFV M
WHERE A.PRODUCT_ATTRIBUTE_CONTEXT = 'ITEM'
AND A.PRODUCT_ATTR_VALUE = TO_CHAR(M.INVENTORY_ITEM_ID)
Columns
Name |
ROW_ID |
LIST_HEADER_ID |
PRICE_LIST_NAME |
CURRENCY_CODE |
LIST_TYPE_CODE |
LIST_LINE_TYPE_CODE |
LIST_PRICE |
LIST_LINE_ID |
PRODUCT_UOM_CODE |
INVENTORY_ITEM_ID |
ITEM_NAME |