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
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
|
|
|