Product: | PJI - Project Intelligence(Obsolete) |
---|---|
Description: | This view stores Project Intelligence numbers for activity data at the project level |
Implementation/DBA Data: | APPS.PJI_AC_XBS_ACCUM_F_V |
SELECT PROJECT_ID
, PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID
, PROJECT_ELEMENT_ID
, TIME_ID
, PERIOD_TYPE_ID
, CALENDAR_TYPE
, WBS_ROLLUP_FLAG
, PRG_ROLLUP_FLAG
, CURR_RECORD_TYPE_ID
, 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 PJI_AC_XBS_ACCUM_F