Product: | XNC - Sales for Communications (Obsolete) |
---|---|
Description: | This view provides a mapping of the item/pricing information in Oracle Sales for Communications with external billing systems that it interacts with. |
Implementation/DBA Data: | Not implemented in this database |
SELECT DISTINCT D.ROWID ROW_ID
, D.BILLING_SYSTEM_MAP_ID
, C.BILLING_SYSTEM_REFERENCE_ID
, C.BILLING_REFERENCE_CODE
, C.BILLING_USAGE
, C.BILLING_SYSTEM
, C.AMOUNT
, C.PROC_NAME
, C.PROC_BODY
, A.NAME PRICE_LIST_NAME
, A.LIST_PRICE
, A.CURRENCY_CODE
, A.LIST_HEADER_ID
, D.LIST_LINE_ID
, A.LIST_TYPE_CODE
, A.LIST_LINE_TYPE_CODE
, A.PRODUCT_ATTR_VALUE PRICING_ITEM_ID
, A.PRODUCT_UOM_CODE
, D.ORGANIZATION_ID
, D.INVENTORY_ITEM_ID
, B.PADDED_CONCATENATED_SEGMENTS ITEM_NAME
, B.DESCRIPTION ITEM_DESCRIPTION
, D.CREATED_BY
, D.CREATION_DATE
, D.LAST_UPDATE_DATE
, D.LAST_UPDATED_BY
, D.LAST_UPDATE_LOGIN
, D.CONTEXT
, D.ATTRIBUTE1
, D.ATTRIBUTE2
, D.ATTRIBUTE3
, D.ATTRIBUTE4
, D.ATTRIBUTE5
, D.ATTRIBUTE6
, D.ATTRIBUTE7
, D.ATTRIBUTE8
, D.ATTRIBUTE9
, D.ATTRIBUTE10
, D.ATTRIBUTE11
, D.ATTRIBUTE12
, D.ATTRIBUTE13
, D.ATTRIBUTE14
, D.ATTRIBUTE15
FROM QP_LIST_ATTRIBUTES_V A
, XNC_BILLING_SYSTEM_REF_V C
, XNC_BILLING_SYSTEM_MAP D
, MTL_SYSTEM_ITEMS_KFV B
WHERE TO_NUMBER(A.PRODUCT_ATTR_VALUE) = B.INVENTORY_ITEM_ID
AND A.LIST_LINE_ID = D.LIST_LINE_ID
AND C.BILLING_SYSTEM_REFERENCE_ID = D.BILLING_SYSTEM_REFERENCE_ID