OSS_TXN_INVOICE_DETAILS_V
詳細
-
スキーマ: FUSION
-
オブジェクト所有者: OSS
-
オブジェクト・タイプ: VIEW
列
| 名前 |
|---|
|
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 |
問合せ
| 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 |