eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PJI.PJI_AC_AGGR_PJP0#

Source

View Text - Preformatted


select WORKER_ID WORKER_ID, 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 from "PJI"."PJI_AC_AGGR_PJP0"

View Text - HTML Formatted

SELECT WORKER_ID WORKER_ID
, 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
FROM "PJI"."PJI_AC_AGGR_PJP0"