1. Tables and Views for Sales and Fusion Service
  2. OSS_TXN_INVOICE_DETAILS_V

OSS_TXN_INVOICE_DETAILS_V

Details

  • Schema: FUSION

  • Object owner: OSS

  • Object type: VIEW

Columns

Name

TRX_ID

BILL_LINE_ID

SUBSCRIPTION_PRODUCT_ID

SUBSCRIPTION_ID

PRODUCT_NAME

PRODUCT_TYPE

BILLING_FREQ

PO_NUMBER

WIRE_NUMBER

SUBSCRIPTION_NUMBER

PRIMARY_PARTY_ID

BUSINESS_UNIT_ID

Query

SQL_Statement

select

b.trx_id,

b.bill_line_id,

b.subscription_product_id,

b.subscription_id,

p.product_name,

p.product_type,

p.billing_freq,

p.po_number,

p.wire_number,

s.subscription_number,

s.primary_party_id,

s.business_unit_id

from oss_bill_lines b, oss_products p, oss_subscriptions s

where b.subscription_product_id = p.subscription_product_id

and b.subscription_id = s.subscription_id