VIEW: APPS.PA_AC_OLAP_STAGE_V

Source

View Text - Preformatted

SELECT OLAP_GROUP, PROJECT_ID, PROJECT_ELEMENT_ID, TIME_ID, CALENDAR_TYPE, CURRENCY_CODE, REVENUE, INITIAL_FUNDING_AMOUNT, INITIAL_FUNDING_COUNT, ADDITIONAL_FUNDING_AMOUNT, ADDITIONAL_FUNDING_COUNT, CANCELLED_FUNDING_AMOUNT, CANCELLED_FUNDING_COUNT, FUNDING_ADJUSTMENT_AMOUNT, FUNDING_ADJUSTMENT_COUNT, REVENUE_WRITEOFF, AR_INVOICE_AMOUNT, AR_INVOICE_COUNT, AR_CASH_APPLIED_AMOUNT, AR_INVOICE_WRITE_OFF_AMOUNT, AR_INVOICE_WRITEOFF_COUNT, AR_CREDIT_MEMO_AMOUNT, AR_CREDIT_MEMO_COUNT, UNBILLED_RECEIVABLES, UNEARNED_REVENUE, AR_UNAPPR_INVOICE_AMOUNT, AR_UNAPPR_INVOICE_COUNT, AR_APPR_INVOICE_AMOUNT, AR_APPR_INVOICE_COUNT, AR_AMOUNT_DUE, AR_COUNT_DUE, AR_AMOUNT_OVERDUE, AR_COUNT_OVERDUE, DORMANT_BACKLOG_INACTIV, DORMANT_BACKLOG_START, LOST_BACKLOG, ACTIVE_BACKLOG, REVENUE_AT_RISK, LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN, CUSTOM1, CUSTOM2, CUSTOM3, CUSTOM4, CUSTOM5, CUSTOM6, CUSTOM7, CUSTOM8, CUSTOM9, CUSTOM10, CUSTOM11, CUSTOM12, CUSTOM13, CUSTOM14, CUSTOM15, CAST(NULL AS NUMBER) CUSTOM16, CAST(NULL AS NUMBER) CUSTOM17, CAST(NULL AS NUMBER) CUSTOM18, CAST(NULL AS NUMBER) CUSTOM19, CAST(NULL AS NUMBER) CUSTOM20, CAST(NULL AS NUMBER) CUSTOM21, CAST(NULL AS NUMBER) CUSTOM22, CAST(NULL AS NUMBER) CUSTOM23, CAST(NULL AS NUMBER) CUSTOM24, CAST(NULL AS NUMBER) CUSTOM25, CAST(NULL AS NUMBER) CUSTOM26, CAST(NULL AS NUMBER) CUSTOM27, CAST(NULL AS NUMBER) CUSTOM28, CAST(NULL AS NUMBER) CUSTOM29, CAST(NULL AS NUMBER) CUSTOM30 FROM pa_ac_olap_stage

View Text - HTML Formatted

SELECT OLAP_GROUP
, PROJECT_ID
, PROJECT_ELEMENT_ID
, TIME_ID
, CALENDAR_TYPE
, CURRENCY_CODE
, REVENUE
, INITIAL_FUNDING_AMOUNT
, INITIAL_FUNDING_COUNT
, ADDITIONAL_FUNDING_AMOUNT
, ADDITIONAL_FUNDING_COUNT
, CANCELLED_FUNDING_AMOUNT
, CANCELLED_FUNDING_COUNT
, FUNDING_ADJUSTMENT_AMOUNT
, FUNDING_ADJUSTMENT_COUNT
, REVENUE_WRITEOFF
, AR_INVOICE_AMOUNT
, AR_INVOICE_COUNT
, AR_CASH_APPLIED_AMOUNT
, AR_INVOICE_WRITE_OFF_AMOUNT
, AR_INVOICE_WRITEOFF_COUNT
, AR_CREDIT_MEMO_AMOUNT
, AR_CREDIT_MEMO_COUNT
, UNBILLED_RECEIVABLES
, UNEARNED_REVENUE
, AR_UNAPPR_INVOICE_AMOUNT
, AR_UNAPPR_INVOICE_COUNT
, AR_APPR_INVOICE_AMOUNT
, AR_APPR_INVOICE_COUNT
, AR_AMOUNT_DUE
, AR_COUNT_DUE
, AR_AMOUNT_OVERDUE
, AR_COUNT_OVERDUE
, DORMANT_BACKLOG_INACTIV
, DORMANT_BACKLOG_START
, LOST_BACKLOG
, ACTIVE_BACKLOG
, REVENUE_AT_RISK
, LAST_UPDATE_DATE
, LAST_UPDATED_BY
, CREATION_DATE
, CREATED_BY
, LAST_UPDATE_LOGIN
, CUSTOM1
, CUSTOM2
, CUSTOM3
, CUSTOM4
, CUSTOM5
, CUSTOM6
, CUSTOM7
, CUSTOM8
, CUSTOM9
, CUSTOM10
, CUSTOM11
, CUSTOM12
, CUSTOM13
, CUSTOM14
, CUSTOM15
, CAST(NULL AS NUMBER) CUSTOM16
, CAST(NULL AS NUMBER) CUSTOM17
, CAST(NULL AS NUMBER) CUSTOM18
, CAST(NULL AS NUMBER) CUSTOM19
, CAST(NULL AS NUMBER) CUSTOM20
, CAST(NULL AS NUMBER) CUSTOM21
, CAST(NULL AS NUMBER) CUSTOM22
, CAST(NULL AS NUMBER) CUSTOM23
, CAST(NULL AS NUMBER) CUSTOM24
, CAST(NULL AS NUMBER) CUSTOM25
, CAST(NULL AS NUMBER) CUSTOM26
, CAST(NULL AS NUMBER) CUSTOM27
, CAST(NULL AS NUMBER) CUSTOM28
, CAST(NULL AS NUMBER) CUSTOM29
, CAST(NULL AS NUMBER) CUSTOM30
FROM PA_AC_OLAP_STAGE