MATERIALIZED VIEW: APPS.PJI_AC_ORGO_F_MV

Source

select /* 12.0: bug#4526784 */
    aco.TIME_ID,
    den.ORGANIZATION_ID                      ORGANIZATION_ID,
    aco.CALENDAR_TYPE,
    aco.PERIOD_TYPE_ID,
    aco.CURR_RECORD_TYPE_ID,
    aco.CURRENCY_CODE,
    aco.ORG_ID,
    count(*)                                 CNT,
    sum  (aco.REVENUE)                       REVENUE,
    count(aco.REVENUE)                       REVENUE_CNT,
    sum  (aco.PROJECT_COUNT)                 PROJECT_COUNT,
    count(aco.PROJECT_COUNT)                 PROJECT_COUNT_CNT,
    sum  (aco.INITIAL_FUNDING_AMOUNT)        INITIAL_FUNDING_AMOUNT,
    count(aco.INITIAL_FUNDING_AMOUNT)        INITIAL_FUNDING_AMOUNT_CNT,
    sum  (aco.INITIAL_FUNDING_COUNT)         INITIAL_FUNDING_COUNT,
    count(aco.INITIAL_FUNDING_COUNT)         INITIAL_FUNDING_COUNT_CNT,
    sum  (aco.ADDITIONAL_FUNDING_AMOUNT)     ADDITIONAL_FUNDING_AMOUNT,
    count(aco.ADDITIONAL_FUNDING_AMOUNT)     ADDITIONAL_FUNDING_AMOUNT_CNT,
    sum  (aco.ADDITIONAL_FUNDING_COUNT)      ADDITIONAL_FUNDING_COUNT,
    count(aco.ADDITIONAL_FUNDING_COUNT)      ADDITIONAL_FUNDING_COUNT_CNT,
    sum  (aco.CANCELLED_FUNDING_AMOUNT)      CANCELLED_FUNDING_AMOUNT,
    count(aco.CANCELLED_FUNDING_AMOUNT)      CANCELLED_FUNDING_AMOUNT_CNT,
    sum  (aco.CANCELLED_FUNDING_COUNT)       CANCELLED_FUNDING_COUNT,
    count(aco.CANCELLED_FUNDING_COUNT)       CANCELLED_FUNDING_COUNT_CNT,
    sum  (aco.FUNDING_ADJUSTMENT_AMOUNT)     FUNDING_ADJUSTMENT_AMOUNT,
    count(aco.FUNDING_ADJUSTMENT_AMOUNT)     FUNDING_ADJUSTMENT_AMOUNT_CNT,
    sum  (aco.FUNDING_ADJUSTMENT_COUNT)      FUNDING_ADJUSTMENT_COUNT,
    count(aco.FUNDING_ADJUSTMENT_COUNT)      FUNDING_ADJUSTMENT_COUNT_CNT,
    sum  (aco.REVENUE_WRITEOFF)              REVENUE_WRITEOFF,
    count(aco.REVENUE_WRITEOFF)              REVENUE_WRITEOFF_CNT,
    sum  (aco.AR_INVOICE_AMOUNT)             AR_INVOICE_AMOUNT,
    count(aco.AR_INVOICE_AMOUNT)             AR_INVOICE_AMOUNT_CNT,
    sum  (aco.AR_INVOICE_COUNT)              AR_INVOICE_COUNT,
    count(aco.AR_INVOICE_COUNT)              AR_INVOICE_COUNT_CNT,
    sum  (aco.AR_CASH_APPLIED_AMOUNT)        AR_CASH_APPLIED_AMOUNT,
    count(aco.AR_CASH_APPLIED_AMOUNT)        AR_CASH_APPLIED_AMOUNT_CNT,
    sum  (aco.AR_INVOICE_WRITEOFF_AMOUNT)    AR_INVOICE_WRITEOFF_AMOUNT,
    count(aco.AR_INVOICE_WRITEOFF_AMOUNT)    AR_INVOICE_WRITEOFF_AMOUNT_CNT,
    sum  (aco.AR_INVOICE_WRITEOFF_COUNT)     AR_INVOICE_WRITEOFF_COUNT,
    count(aco.AR_INVOICE_WRITEOFF_COUNT)     AR_INVOICE_WRITEOFF_COUNT_CNT,
    sum  (aco.AR_CREDIT_MEMO_AMOUNT)         AR_CREDIT_MEMO_AMOUNT,
    count(aco.AR_CREDIT_MEMO_AMOUNT)         AR_CREDIT_MEMO_AMOUNT_CNT,
    sum  (aco.AR_CREDIT_MEMO_COUNT)          AR_CREDIT_MEMO_COUNT,
    count(aco.AR_CREDIT_MEMO_COUNT)          AR_CREDIT_MEMO_COUNT_CNT,
    sum  (aco.UNBILLED_RECEIVABLES)          UNBILLED_RECEIVABLES,
    count(aco.UNBILLED_RECEIVABLES)          UNBILLED_RECEIVABLES_CNT,
    sum  (aco.UNEARNED_REVENUE)              UNEARNED_REVENUE,
    count(aco.UNEARNED_REVENUE)              UNEARNED_REVENUE_CNT,
    sum  (aco.AR_UNAPPR_INVOICE_AMOUNT)      AR_UNAPPR_INVOICE_AMOUNT,
    count(aco.AR_UNAPPR_INVOICE_AMOUNT)      AR_UNAPPR_INVOICE_AMOUNT_CNT,
    sum  (aco.AR_UNAPPR_INVOICE_COUNT)       AR_UNAPPR_INVOICE_COUNT,
    count(aco.AR_UNAPPR_INVOICE_COUNT)       AR_UNAPPR_INVOICE_COUNT_CNT,
    sum  (aco.AR_APPR_INVOICE_AMOUNT)        AR_APPR_INVOICE_AMOUNT,
    count(aco.AR_APPR_INVOICE_AMOUNT)        AR_APPR_INVOICE_AMOUNT_CNT,
    sum  (aco.AR_APPR_INVOICE_COUNT)         AR_APPR_INVOICE_COUNT,
    count(aco.AR_APPR_INVOICE_COUNT)         AR_APPR_INVOICE_COUNT_CNT,
    sum  (aco.AR_AMOUNT_DUE)                 AR_AMOUNT_DUE,
    count(aco.AR_AMOUNT_DUE)                 AR_AMOUNT_DUE_CNT,
    sum  (aco.AR_COUNT_DUE)                  AR_COUNT_DUE,
    count(aco.AR_COUNT_DUE)                  AR_COUNT_DUE_CNT,
    sum  (aco.AR_AMOUNT_OVERDUE)             AR_AMOUNT_OVERDUE,
    count(aco.AR_AMOUNT_OVERDUE)             AR_AMOUNT_OVERDUE_CNT,
    sum  (aco.AR_COUNT_OVERDUE)              AR_COUNT_OVERDUE,
    count(aco.AR_COUNT_OVERDUE)              AR_COUNT_OVERDUE_CNT,
    sum  (aco.DORMANT_BACKLOG_INACTIV)       DORMANT_BACKLOG_INACTIV,
    count(aco.DORMANT_BACKLOG_INACTIV)       DORMANT_BACKLOG_INACTIV_CNT,
    sum  (aco.DORMANT_BACKLOG_START)         DORMANT_BACKLOG_START,
    count(aco.DORMANT_BACKLOG_START)         DORMANT_BACKLOG_START_CNT,
    sum  (aco.LOST_BACKLOG)                  LOST_BACKLOG,
    count(aco.LOST_BACKLOG)                  LOST_BACKLOG_CNT,
    sum  (aco.ACTIVE_BACKLOG)                ACTIVE_BACKLOG,
    count(aco.ACTIVE_BACKLOG)                ACTIVE_BACKLOG_CNT,
    sum  (aco.REVENUE_AT_RISK)               REVENUE_AT_RISK,
    count(aco.REVENUE_AT_RISK)               REVENUE_AT_RISK_CNT
  from
    PJI_AC_ORG_F_MV    aco,
    PJI.PJI_ORG_DENORM den
  where
    aco.ORGANIZATION_ID = den.SUB_ORGANIZATION_ID
  group by
    aco.TIME_ID,
    den.ORGANIZATION_ID,
    aco.CALENDAR_TYPE,
    aco.PERIOD_TYPE_ID,
    aco.CURR_RECORD_TYPE_ID,
    aco.CURRENCY_CODE,
    aco.ORG_ID