VIEW: PJI.PJI_FM_AGGR_ACT1#

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, CUSTOMER_ID CUSTOMER_ID, GL_TIME_ID GL_TIME_ID, PA_TIME_ID PA_TIME_ID, PRJ_REVENUE PRJ_REVENUE, PRJ_FUNDING PRJ_FUNDING, PRJ_INITIAL_FUNDING_AMOUNT PRJ_INITIAL_FUNDING_AMOUNT, PRJ_ADDITIONAL_FUNDING_AMOUNT PRJ_ADDITIONAL_FUNDING_AMOUNT, PRJ_CANCELLED_FUNDING_AMOUNT PRJ_CANCELLED_FUNDING_AMOUNT, PRJ_FUNDING_ADJUSTMENT_AMOUNT PRJ_FUNDING_ADJUSTMENT_AMOUNT, PRJ_REVENUE_WRITEOFF PRJ_REVENUE_WRITEOFF, PRJ_AR_INVOICE_AMOUNT PRJ_AR_INVOICE_AMOUNT, PRJ_AR_CASH_APPLIED_AMOUNT PRJ_AR_CASH_APPLIED_AMOUNT, PRJ_AR_INVOICE_WRITEOFF_AMOUNT PRJ_AR_INVOICE_WRITEOFF_AMOUNT, PRJ_AR_CREDIT_MEMO_AMOUNT PRJ_AR_CREDIT_MEMO_AMOUNT, PRJ_UNBILLED_RECEIVABLES PRJ_UNBILLED_RECEIVABLES, PRJ_UNEARNED_REVENUE PRJ_UNEARNED_REVENUE, PRJ_AR_UNAPPR_INVOICE_AMOUNT PRJ_AR_UNAPPR_INVOICE_AMOUNT, PRJ_AR_APPR_INVOICE_AMOUNT PRJ_AR_APPR_INVOICE_AMOUNT, PRJ_AR_AMOUNT_DUE PRJ_AR_AMOUNT_DUE, PRJ_AR_AMOUNT_OVERDUE PRJ_AR_AMOUNT_OVERDUE, POU_REVENUE POU_REVENUE, POU_FUNDING POU_FUNDING, POU_INITIAL_FUNDING_AMOUNT POU_INITIAL_FUNDING_AMOUNT, POU_ADDITIONAL_FUNDING_AMOUNT POU_ADDITIONAL_FUNDING_AMOUNT, POU_CANCELLED_FUNDING_AMOUNT POU_CANCELLED_FUNDING_AMOUNT, POU_FUNDING_ADJUSTMENT_AMOUNT POU_FUNDING_ADJUSTMENT_AMOUNT, POU_REVENUE_WRITEOFF POU_REVENUE_WRITEOFF, POU_AR_INVOICE_AMOUNT POU_AR_INVOICE_AMOUNT, POU_AR_CASH_APPLIED_AMOUNT POU_AR_CASH_APPLIED_AMOUNT, POU_AR_INVOICE_WRITEOFF_AMOUNT POU_AR_INVOICE_WRITEOFF_AMOUNT, POU_AR_CREDIT_MEMO_AMOUNT POU_AR_CREDIT_MEMO_AMOUNT, POU_UNBILLED_RECEIVABLES POU_UNBILLED_RECEIVABLES, POU_UNEARNED_REVENUE POU_UNEARNED_REVENUE, POU_AR_UNAPPR_INVOICE_AMOUNT POU_AR_UNAPPR_INVOICE_AMOUNT, POU_AR_APPR_INVOICE_AMOUNT POU_AR_APPR_INVOICE_AMOUNT, POU_AR_AMOUNT_DUE POU_AR_AMOUNT_DUE, POU_AR_AMOUNT_OVERDUE POU_AR_AMOUNT_OVERDUE, INITIAL_FUNDING_COUNT INITIAL_FUNDING_COUNT, ADDITIONAL_FUNDING_COUNT ADDITIONAL_FUNDING_COUNT, CANCELLED_FUNDING_COUNT CANCELLED_FUNDING_COUNT, FUNDING_ADJUSTMENT_COUNT FUNDING_ADJUSTMENT_COUNT, AR_INVOICE_COUNT AR_INVOICE_COUNT, AR_CASH_APPLIED_COUNT AR_CASH_APPLIED_COUNT, AR_INVOICE_WRITEOFF_COUNT AR_INVOICE_WRITEOFF_COUNT, AR_CREDIT_MEMO_COUNT AR_CREDIT_MEMO_COUNT, AR_UNAPPR_INVOICE_COUNT AR_UNAPPR_INVOICE_COUNT, AR_APPR_INVOICE_COUNT AR_APPR_INVOICE_COUNT, AR_COUNT_DUE AR_COUNT_DUE, AR_COUNT_OVERDUE AR_COUNT_OVERDUE, TASK_ID TASK_ID, GL_PERIOD_NAME GL_PERIOD_NAME, PA_PERIOD_NAME PA_PERIOD_NAME, TXN_CURRENCY_CODE TXN_CURRENCY_CODE, TXN_REVENUE TXN_REVENUE, TXN_FUNDING TXN_FUNDING, TXN_INITIAL_FUNDING_AMOUNT TXN_INITIAL_FUNDING_AMOUNT, TXN_ADDITIONAL_FUNDING_AMOUNT TXN_ADDITIONAL_FUNDING_AMOUNT, TXN_CANCELLED_FUNDING_AMOUNT TXN_CANCELLED_FUNDING_AMOUNT, TXN_FUNDING_ADJUSTMENT_AMOUNT TXN_FUNDING_ADJUSTMENT_AMOUNT, TXN_REVENUE_WRITEOFF TXN_REVENUE_WRITEOFF, TXN_AR_INVOICE_AMOUNT TXN_AR_INVOICE_AMOUNT, TXN_AR_CASH_APPLIED_AMOUNT TXN_AR_CASH_APPLIED_AMOUNT, TXN_AR_INVOICE_WRITEOFF_AMOUNT TXN_AR_INVOICE_WRITEOFF_AMOUNT, TXN_AR_CREDIT_MEMO_AMOUNT TXN_AR_CREDIT_MEMO_AMOUNT, TXN_UNBILLED_RECEIVABLES TXN_UNBILLED_RECEIVABLES, TXN_UNEARNED_REVENUE TXN_UNEARNED_REVENUE, TXN_AR_UNAPPR_INVOICE_AMOUNT TXN_AR_UNAPPR_INVOICE_AMOUNT, TXN_AR_APPR_INVOICE_AMOUNT TXN_AR_APPR_INVOICE_AMOUNT, TXN_AR_AMOUNT_DUE TXN_AR_AMOUNT_DUE, TXN_AR_AMOUNT_OVERDUE TXN_AR_AMOUNT_OVERDUE from "PJI"."PJI_FM_AGGR_ACT1"

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
, CUSTOMER_ID CUSTOMER_ID
, GL_TIME_ID GL_TIME_ID
, PA_TIME_ID PA_TIME_ID
, PRJ_REVENUE PRJ_REVENUE
, PRJ_FUNDING PRJ_FUNDING
, PRJ_INITIAL_FUNDING_AMOUNT PRJ_INITIAL_FUNDING_AMOUNT
, PRJ_ADDITIONAL_FUNDING_AMOUNT PRJ_ADDITIONAL_FUNDING_AMOUNT
, PRJ_CANCELLED_FUNDING_AMOUNT PRJ_CANCELLED_FUNDING_AMOUNT
, PRJ_FUNDING_ADJUSTMENT_AMOUNT PRJ_FUNDING_ADJUSTMENT_AMOUNT
, PRJ_REVENUE_WRITEOFF PRJ_REVENUE_WRITEOFF
, PRJ_AR_INVOICE_AMOUNT PRJ_AR_INVOICE_AMOUNT
, PRJ_AR_CASH_APPLIED_AMOUNT PRJ_AR_CASH_APPLIED_AMOUNT
, PRJ_AR_INVOICE_WRITEOFF_AMOUNT PRJ_AR_INVOICE_WRITEOFF_AMOUNT
, PRJ_AR_CREDIT_MEMO_AMOUNT PRJ_AR_CREDIT_MEMO_AMOUNT
, PRJ_UNBILLED_RECEIVABLES PRJ_UNBILLED_RECEIVABLES
, PRJ_UNEARNED_REVENUE PRJ_UNEARNED_REVENUE
, PRJ_AR_UNAPPR_INVOICE_AMOUNT PRJ_AR_UNAPPR_INVOICE_AMOUNT
, PRJ_AR_APPR_INVOICE_AMOUNT PRJ_AR_APPR_INVOICE_AMOUNT
, PRJ_AR_AMOUNT_DUE PRJ_AR_AMOUNT_DUE
, PRJ_AR_AMOUNT_OVERDUE PRJ_AR_AMOUNT_OVERDUE
, POU_REVENUE POU_REVENUE
, POU_FUNDING POU_FUNDING
, POU_INITIAL_FUNDING_AMOUNT POU_INITIAL_FUNDING_AMOUNT
, POU_ADDITIONAL_FUNDING_AMOUNT POU_ADDITIONAL_FUNDING_AMOUNT
, POU_CANCELLED_FUNDING_AMOUNT POU_CANCELLED_FUNDING_AMOUNT
, POU_FUNDING_ADJUSTMENT_AMOUNT POU_FUNDING_ADJUSTMENT_AMOUNT
, POU_REVENUE_WRITEOFF POU_REVENUE_WRITEOFF
, POU_AR_INVOICE_AMOUNT POU_AR_INVOICE_AMOUNT
, POU_AR_CASH_APPLIED_AMOUNT POU_AR_CASH_APPLIED_AMOUNT
, POU_AR_INVOICE_WRITEOFF_AMOUNT POU_AR_INVOICE_WRITEOFF_AMOUNT
, POU_AR_CREDIT_MEMO_AMOUNT POU_AR_CREDIT_MEMO_AMOUNT
, POU_UNBILLED_RECEIVABLES POU_UNBILLED_RECEIVABLES
, POU_UNEARNED_REVENUE POU_UNEARNED_REVENUE
, POU_AR_UNAPPR_INVOICE_AMOUNT POU_AR_UNAPPR_INVOICE_AMOUNT
, POU_AR_APPR_INVOICE_AMOUNT POU_AR_APPR_INVOICE_AMOUNT
, POU_AR_AMOUNT_DUE POU_AR_AMOUNT_DUE
, POU_AR_AMOUNT_OVERDUE POU_AR_AMOUNT_OVERDUE
, INITIAL_FUNDING_COUNT INITIAL_FUNDING_COUNT
, ADDITIONAL_FUNDING_COUNT ADDITIONAL_FUNDING_COUNT
, CANCELLED_FUNDING_COUNT CANCELLED_FUNDING_COUNT
, FUNDING_ADJUSTMENT_COUNT FUNDING_ADJUSTMENT_COUNT
, AR_INVOICE_COUNT AR_INVOICE_COUNT
, AR_CASH_APPLIED_COUNT AR_CASH_APPLIED_COUNT
, AR_INVOICE_WRITEOFF_COUNT AR_INVOICE_WRITEOFF_COUNT
, AR_CREDIT_MEMO_COUNT AR_CREDIT_MEMO_COUNT
, AR_UNAPPR_INVOICE_COUNT AR_UNAPPR_INVOICE_COUNT
, AR_APPR_INVOICE_COUNT AR_APPR_INVOICE_COUNT
, AR_COUNT_DUE AR_COUNT_DUE
, AR_COUNT_OVERDUE AR_COUNT_OVERDUE
, TASK_ID TASK_ID
, GL_PERIOD_NAME GL_PERIOD_NAME
, PA_PERIOD_NAME PA_PERIOD_NAME
, TXN_CURRENCY_CODE TXN_CURRENCY_CODE
, TXN_REVENUE TXN_REVENUE
, TXN_FUNDING TXN_FUNDING
, TXN_INITIAL_FUNDING_AMOUNT TXN_INITIAL_FUNDING_AMOUNT
, TXN_ADDITIONAL_FUNDING_AMOUNT TXN_ADDITIONAL_FUNDING_AMOUNT
, TXN_CANCELLED_FUNDING_AMOUNT TXN_CANCELLED_FUNDING_AMOUNT
, TXN_FUNDING_ADJUSTMENT_AMOUNT TXN_FUNDING_ADJUSTMENT_AMOUNT
, TXN_REVENUE_WRITEOFF TXN_REVENUE_WRITEOFF
, TXN_AR_INVOICE_AMOUNT TXN_AR_INVOICE_AMOUNT
, TXN_AR_CASH_APPLIED_AMOUNT TXN_AR_CASH_APPLIED_AMOUNT
, TXN_AR_INVOICE_WRITEOFF_AMOUNT TXN_AR_INVOICE_WRITEOFF_AMOUNT
, TXN_AR_CREDIT_MEMO_AMOUNT TXN_AR_CREDIT_MEMO_AMOUNT
, TXN_UNBILLED_RECEIVABLES TXN_UNBILLED_RECEIVABLES
, TXN_UNEARNED_REVENUE TXN_UNEARNED_REVENUE
, TXN_AR_UNAPPR_INVOICE_AMOUNT TXN_AR_UNAPPR_INVOICE_AMOUNT
, TXN_AR_APPR_INVOICE_AMOUNT TXN_AR_APPR_INVOICE_AMOUNT
, TXN_AR_AMOUNT_DUE TXN_AR_AMOUNT_DUE
, TXN_AR_AMOUNT_OVERDUE TXN_AR_AMOUNT_OVERDUE
FROM "PJI"."PJI_FM_AGGR_ACT1"