機械翻訳について

OKC_K_INV_REV_SUMMARY_V

詳細

• スキーマ: FUSION

• オブジェクト所有者: OKC

• オブジェクト・タイプ: VIEW

列

名前
CONTRACT_ID CONTRACT_LINE_ID AGGR_LEVEL INVOICED REVENUE

問合せ

SQL_Statement
select contract_id, contract_line_id, aggr_level, nvl(sum(cc_billed),0) invoiced, nvl(sum(cc_revenue),0) revenue FROM pjs_cn_inv_rev_f where aggr_level in ('C','L') and CONTRACT_PROJECT_LINKAGE_ID=-1 AND bitand(currency_type_id(+),3)<>0 group by contract_id, contract_line_id, aggr_level