VIEW: PJI.PJI_AC_XBS_ACCUM_F#

Source

View Text - Preformatted

select PROJECT_ID PROJECT_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, PROJECT_ELEMENT_ID PROJECT_ELEMENT_ID, TIME_ID TIME_ID, PERIOD_TYPE_ID PERIOD_TYPE_ID, CALENDAR_TYPE CALENDAR_TYPE, WBS_ROLLUP_FLAG WBS_ROLLUP_FLAG, PRG_ROLLUP_FLAG PRG_ROLLUP_FLAG, CURR_RECORD_TYPE_ID CURR_RECORD_TYPE_ID, CURRENCY_CODE CURRENCY_CODE, REVENUE REVENUE, INITIAL_FUNDING_AMOUNT INITIAL_FUNDING_AMOUNT, INITIAL_FUNDING_COUNT INITIAL_FUNDING_COUNT, ADDITIONAL_FUNDING_AMOUNT ADDITIONAL_FUNDING_AMOUNT, ADDITIONAL_FUNDING_COUNT ADDITIONAL_FUNDING_COUNT, CANCELLED_FUNDING_AMOUNT CANCELLED_FUNDING_AMOUNT, CANCELLED_FUNDING_COUNT CANCELLED_FUNDING_COUNT, FUNDING_ADJUSTMENT_AMOUNT FUNDING_ADJUSTMENT_AMOUNT, FUNDING_ADJUSTMENT_COUNT FUNDING_ADJUSTMENT_COUNT, REVENUE_WRITEOFF REVENUE_WRITEOFF, AR_INVOICE_AMOUNT AR_INVOICE_AMOUNT, AR_INVOICE_COUNT AR_INVOICE_COUNT, AR_CASH_APPLIED_AMOUNT AR_CASH_APPLIED_AMOUNT, AR_INVOICE_WRITE_OFF_AMOUNT AR_INVOICE_WRITE_OFF_AMOUNT, AR_INVOICE_WRITEOFF_COUNT AR_INVOICE_WRITEOFF_COUNT, AR_CREDIT_MEMO_AMOUNT AR_CREDIT_MEMO_AMOUNT, AR_CREDIT_MEMO_COUNT AR_CREDIT_MEMO_COUNT, UNBILLED_RECEIVABLES UNBILLED_RECEIVABLES, UNEARNED_REVENUE UNEARNED_REVENUE, AR_UNAPPR_INVOICE_AMOUNT AR_UNAPPR_INVOICE_AMOUNT, AR_UNAPPR_INVOICE_COUNT AR_UNAPPR_INVOICE_COUNT, AR_APPR_INVOICE_AMOUNT AR_APPR_INVOICE_AMOUNT, AR_APPR_INVOICE_COUNT AR_APPR_INVOICE_COUNT, AR_AMOUNT_DUE AR_AMOUNT_DUE, AR_COUNT_DUE AR_COUNT_DUE, AR_AMOUNT_OVERDUE AR_AMOUNT_OVERDUE, AR_COUNT_OVERDUE AR_COUNT_OVERDUE, DORMANT_BACKLOG_INACTIV DORMANT_BACKLOG_INACTIV, DORMANT_BACKLOG_START DORMANT_BACKLOG_START, LOST_BACKLOG LOST_BACKLOG, ACTIVE_BACKLOG ACTIVE_BACKLOG, REVENUE_AT_RISK REVENUE_AT_RISK, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CUSTOM1 CUSTOM1, CUSTOM2 CUSTOM2, CUSTOM3 CUSTOM3, CUSTOM4 CUSTOM4, CUSTOM5 CUSTOM5, CUSTOM6 CUSTOM6, CUSTOM7 CUSTOM7, CUSTOM8 CUSTOM8, CUSTOM9 CUSTOM9, CUSTOM10 CUSTOM10, CUSTOM11 CUSTOM11, CUSTOM12 CUSTOM12, CUSTOM13 CUSTOM13, CUSTOM14 CUSTOM14, CUSTOM15 CUSTOM15 from "PJI"."PJI_AC_XBS_ACCUM_F"

View Text - HTML Formatted

SELECT PROJECT_ID PROJECT_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, PROJECT_ELEMENT_ID PROJECT_ELEMENT_ID
, TIME_ID TIME_ID
, PERIOD_TYPE_ID PERIOD_TYPE_ID
, CALENDAR_TYPE CALENDAR_TYPE
, WBS_ROLLUP_FLAG WBS_ROLLUP_FLAG
, PRG_ROLLUP_FLAG PRG_ROLLUP_FLAG
, CURR_RECORD_TYPE_ID CURR_RECORD_TYPE_ID
, CURRENCY_CODE CURRENCY_CODE
, REVENUE REVENUE
, INITIAL_FUNDING_AMOUNT INITIAL_FUNDING_AMOUNT
, INITIAL_FUNDING_COUNT INITIAL_FUNDING_COUNT
, ADDITIONAL_FUNDING_AMOUNT ADDITIONAL_FUNDING_AMOUNT
, ADDITIONAL_FUNDING_COUNT ADDITIONAL_FUNDING_COUNT
, CANCELLED_FUNDING_AMOUNT CANCELLED_FUNDING_AMOUNT
, CANCELLED_FUNDING_COUNT CANCELLED_FUNDING_COUNT
, FUNDING_ADJUSTMENT_AMOUNT FUNDING_ADJUSTMENT_AMOUNT
, FUNDING_ADJUSTMENT_COUNT FUNDING_ADJUSTMENT_COUNT
, REVENUE_WRITEOFF REVENUE_WRITEOFF
, AR_INVOICE_AMOUNT AR_INVOICE_AMOUNT
, AR_INVOICE_COUNT AR_INVOICE_COUNT
, AR_CASH_APPLIED_AMOUNT AR_CASH_APPLIED_AMOUNT
, AR_INVOICE_WRITE_OFF_AMOUNT AR_INVOICE_WRITE_OFF_AMOUNT
, AR_INVOICE_WRITEOFF_COUNT AR_INVOICE_WRITEOFF_COUNT
, AR_CREDIT_MEMO_AMOUNT AR_CREDIT_MEMO_AMOUNT
, AR_CREDIT_MEMO_COUNT AR_CREDIT_MEMO_COUNT
, UNBILLED_RECEIVABLES UNBILLED_RECEIVABLES
, UNEARNED_REVENUE UNEARNED_REVENUE
, AR_UNAPPR_INVOICE_AMOUNT AR_UNAPPR_INVOICE_AMOUNT
, AR_UNAPPR_INVOICE_COUNT AR_UNAPPR_INVOICE_COUNT
, AR_APPR_INVOICE_AMOUNT AR_APPR_INVOICE_AMOUNT
, AR_APPR_INVOICE_COUNT AR_APPR_INVOICE_COUNT
, AR_AMOUNT_DUE AR_AMOUNT_DUE
, AR_COUNT_DUE AR_COUNT_DUE
, AR_AMOUNT_OVERDUE AR_AMOUNT_OVERDUE
, AR_COUNT_OVERDUE AR_COUNT_OVERDUE
, DORMANT_BACKLOG_INACTIV DORMANT_BACKLOG_INACTIV
, DORMANT_BACKLOG_START DORMANT_BACKLOG_START
, LOST_BACKLOG LOST_BACKLOG
, ACTIVE_BACKLOG ACTIVE_BACKLOG
, REVENUE_AT_RISK REVENUE_AT_RISK
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CUSTOM1 CUSTOM1
, CUSTOM2 CUSTOM2
, CUSTOM3 CUSTOM3
, CUSTOM4 CUSTOM4
, CUSTOM5 CUSTOM5
, CUSTOM6 CUSTOM6
, CUSTOM7 CUSTOM7
, CUSTOM8 CUSTOM8
, CUSTOM9 CUSTOM9
, CUSTOM10 CUSTOM10
, CUSTOM11 CUSTOM11
, CUSTOM12 CUSTOM12
, CUSTOM13 CUSTOM13
, CUSTOM14 CUSTOM14
, CUSTOM15 CUSTOM15
FROM "PJI"."PJI_AC_XBS_ACCUM_F"