OKC_K_INV_REV_SUMMARY_V

Details

• Schema: FUSION

• Object owner: OKC

• Object type: VIEW

Columns

Name
CONTRACT_ID CONTRACT_LINE_ID AGGR_LEVEL INVOICED REVENUE

Query

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