VIEW: PJI.PJI_FM_DNGL_ACT#

Source

View Text - Preformatted

select WORKER_ID WORKER_ID, DANGLING_GL_RATE_FLAG DANGLING_GL_RATE_FLAG, DANGLING_PA_RATE_FLAG DANGLING_PA_RATE_FLAG, DANGLING_EN_TIME_FLAG DANGLING_EN_TIME_FLAG, DANGLING_GL_TIME_FLAG DANGLING_GL_TIME_FLAG, DANGLING_PA_TIME_FLAG DANGLING_PA_TIME_FLAG, ROW_ID ROW_ID, PROJECT_ID PROJECT_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_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, GG_REVENUE GG_REVENUE, GG_FUNDING GG_FUNDING, GG_INITIAL_FUNDING_AMOUNT GG_INITIAL_FUNDING_AMOUNT, GG_ADDITIONAL_FUNDING_AMOUNT GG_ADDITIONAL_FUNDING_AMOUNT, GG_CANCELLED_FUNDING_AMOUNT GG_CANCELLED_FUNDING_AMOUNT, GG_FUNDING_ADJUSTMENT_AMOUNT GG_FUNDING_ADJUSTMENT_AMOUNT, GG_REVENUE_WRITEOFF GG_REVENUE_WRITEOFF, GG_AR_INVOICE_AMOUNT GG_AR_INVOICE_AMOUNT, GG_AR_CASH_APPLIED_AMOUNT GG_AR_CASH_APPLIED_AMOUNT, GG_AR_INVOICE_WRITEOFF_AMOUNT GG_AR_INVOICE_WRITEOFF_AMOUNT, GG_AR_CREDIT_MEMO_AMOUNT GG_AR_CREDIT_MEMO_AMOUNT, GG_UNBILLED_RECEIVABLES GG_UNBILLED_RECEIVABLES, GG_UNEARNED_REVENUE GG_UNEARNED_REVENUE, GG_AR_UNAPPR_INVOICE_AMOUNT GG_AR_UNAPPR_INVOICE_AMOUNT, GG_AR_APPR_INVOICE_AMOUNT GG_AR_APPR_INVOICE_AMOUNT, GG_AR_AMOUNT_DUE GG_AR_AMOUNT_DUE, GG_AR_AMOUNT_OVERDUE GG_AR_AMOUNT_OVERDUE, GP_REVENUE GP_REVENUE, GP_FUNDING GP_FUNDING, GP_INITIAL_FUNDING_AMOUNT GP_INITIAL_FUNDING_AMOUNT, GP_ADDITIONAL_FUNDING_AMOUNT GP_ADDITIONAL_FUNDING_AMOUNT, GP_CANCELLED_FUNDING_AMOUNT GP_CANCELLED_FUNDING_AMOUNT, GP_FUNDING_ADJUSTMENT_AMOUNT GP_FUNDING_ADJUSTMENT_AMOUNT, GP_REVENUE_WRITEOFF GP_REVENUE_WRITEOFF, GP_AR_INVOICE_AMOUNT GP_AR_INVOICE_AMOUNT, GP_AR_CASH_APPLIED_AMOUNT GP_AR_CASH_APPLIED_AMOUNT, GP_AR_INVOICE_WRITEOFF_AMOUNT GP_AR_INVOICE_WRITEOFF_AMOUNT, GP_AR_CREDIT_MEMO_AMOUNT GP_AR_CREDIT_MEMO_AMOUNT, GP_UNBILLED_RECEIVABLES GP_UNBILLED_RECEIVABLES, GP_UNEARNED_REVENUE GP_UNEARNED_REVENUE, GP_AR_UNAPPR_INVOICE_AMOUNT GP_AR_UNAPPR_INVOICE_AMOUNT, GP_AR_APPR_INVOICE_AMOUNT GP_AR_APPR_INVOICE_AMOUNT, GP_AR_AMOUNT_DUE GP_AR_AMOUNT_DUE, GP_AR_AMOUNT_OVERDUE GP_AR_AMOUNT_OVERDUE, GL_CALENDAR_ID GL_CALENDAR_ID, PA_CALENDAR_ID PA_CALENDAR_ID, DANGLING_GL_RATE2_FLAG DANGLING_GL_RATE2_FLAG, DANGLING_PA_RATE2_FLAG DANGLING_PA_RATE2_FLAG, 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, GG2_REVENUE GG2_REVENUE, GG2_FUNDING GG2_FUNDING, GG2_INITIAL_FUNDING_AMOUNT GG2_INITIAL_FUNDING_AMOUNT, GG2_ADDITIONAL_FUNDING_AMOUNT GG2_ADDITIONAL_FUNDING_AMOUNT, GG2_CANCELLED_FUNDING_AMOUNT GG2_CANCELLED_FUNDING_AMOUNT, GG2_FUNDING_ADJUSTMENT_AMOUNT GG2_FUNDING_ADJUSTMENT_AMOUNT, GG2_REVENUE_WRITEOFF GG2_REVENUE_WRITEOFF, GG2_AR_INVOICE_AMOUNT GG2_AR_INVOICE_AMOUNT, GG2_AR_CASH_APPLIED_AMOUNT GG2_AR_CASH_APPLIED_AMOUNT, GG2_AR_INVOICE_WRITEOFF_AMOUNT GG2_AR_INVOICE_WRITEOFF_AMOUNT, GG2_AR_CREDIT_MEMO_AMOUNT GG2_AR_CREDIT_MEMO_AMOUNT, GG2_UNBILLED_RECEIVABLES GG2_UNBILLED_RECEIVABLES, GG2_UNEARNED_REVENUE GG2_UNEARNED_REVENUE, GG2_AR_UNAPPR_INVOICE_AMOUNT GG2_AR_UNAPPR_INVOICE_AMOUNT, GG2_AR_APPR_INVOICE_AMOUNT GG2_AR_APPR_INVOICE_AMOUNT, GG2_AR_AMOUNT_DUE GG2_AR_AMOUNT_DUE, GG2_AR_AMOUNT_OVERDUE GG2_AR_AMOUNT_OVERDUE, GP2_REVENUE GP2_REVENUE, GP2_FUNDING GP2_FUNDING, GP2_INITIAL_FUNDING_AMOUNT GP2_INITIAL_FUNDING_AMOUNT, GP2_ADDITIONAL_FUNDING_AMOUNT GP2_ADDITIONAL_FUNDING_AMOUNT, GP2_CANCELLED_FUNDING_AMOUNT GP2_CANCELLED_FUNDING_AMOUNT, GP2_FUNDING_ADJUSTMENT_AMOUNT GP2_FUNDING_ADJUSTMENT_AMOUNT, GP2_REVENUE_WRITEOFF GP2_REVENUE_WRITEOFF, GP2_AR_INVOICE_AMOUNT GP2_AR_INVOICE_AMOUNT, GP2_AR_CASH_APPLIED_AMOUNT GP2_AR_CASH_APPLIED_AMOUNT, GP2_AR_INVOICE_WRITEOFF_AMOUNT GP2_AR_INVOICE_WRITEOFF_AMOUNT, GP2_AR_CREDIT_MEMO_AMOUNT GP2_AR_CREDIT_MEMO_AMOUNT, GP2_UNBILLED_RECEIVABLES GP2_UNBILLED_RECEIVABLES, GP2_UNEARNED_REVENUE GP2_UNEARNED_REVENUE, GP2_AR_UNAPPR_INVOICE_AMOUNT GP2_AR_UNAPPR_INVOICE_AMOUNT, GP2_AR_APPR_INVOICE_AMOUNT GP2_AR_APPR_INVOICE_AMOUNT, GP2_AR_AMOUNT_DUE GP2_AR_AMOUNT_DUE, GP2_AR_AMOUNT_OVERDUE GP2_AR_AMOUNT_OVERDUE from "PJI"."PJI_FM_DNGL_ACT"

View Text - HTML Formatted

SELECT WORKER_ID WORKER_ID
, DANGLING_GL_RATE_FLAG DANGLING_GL_RATE_FLAG
, DANGLING_PA_RATE_FLAG DANGLING_PA_RATE_FLAG
, DANGLING_EN_TIME_FLAG DANGLING_EN_TIME_FLAG
, DANGLING_GL_TIME_FLAG DANGLING_GL_TIME_FLAG
, DANGLING_PA_TIME_FLAG DANGLING_PA_TIME_FLAG
, ROW_ID ROW_ID
, PROJECT_ID PROJECT_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_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
, GG_REVENUE GG_REVENUE
, GG_FUNDING GG_FUNDING
, GG_INITIAL_FUNDING_AMOUNT GG_INITIAL_FUNDING_AMOUNT
, GG_ADDITIONAL_FUNDING_AMOUNT GG_ADDITIONAL_FUNDING_AMOUNT
, GG_CANCELLED_FUNDING_AMOUNT GG_CANCELLED_FUNDING_AMOUNT
, GG_FUNDING_ADJUSTMENT_AMOUNT GG_FUNDING_ADJUSTMENT_AMOUNT
, GG_REVENUE_WRITEOFF GG_REVENUE_WRITEOFF
, GG_AR_INVOICE_AMOUNT GG_AR_INVOICE_AMOUNT
, GG_AR_CASH_APPLIED_AMOUNT GG_AR_CASH_APPLIED_AMOUNT
, GG_AR_INVOICE_WRITEOFF_AMOUNT GG_AR_INVOICE_WRITEOFF_AMOUNT
, GG_AR_CREDIT_MEMO_AMOUNT GG_AR_CREDIT_MEMO_AMOUNT
, GG_UNBILLED_RECEIVABLES GG_UNBILLED_RECEIVABLES
, GG_UNEARNED_REVENUE GG_UNEARNED_REVENUE
, GG_AR_UNAPPR_INVOICE_AMOUNT GG_AR_UNAPPR_INVOICE_AMOUNT
, GG_AR_APPR_INVOICE_AMOUNT GG_AR_APPR_INVOICE_AMOUNT
, GG_AR_AMOUNT_DUE GG_AR_AMOUNT_DUE
, GG_AR_AMOUNT_OVERDUE GG_AR_AMOUNT_OVERDUE
, GP_REVENUE GP_REVENUE
, GP_FUNDING GP_FUNDING
, GP_INITIAL_FUNDING_AMOUNT GP_INITIAL_FUNDING_AMOUNT
, GP_ADDITIONAL_FUNDING_AMOUNT GP_ADDITIONAL_FUNDING_AMOUNT
, GP_CANCELLED_FUNDING_AMOUNT GP_CANCELLED_FUNDING_AMOUNT
, GP_FUNDING_ADJUSTMENT_AMOUNT GP_FUNDING_ADJUSTMENT_AMOUNT
, GP_REVENUE_WRITEOFF GP_REVENUE_WRITEOFF
, GP_AR_INVOICE_AMOUNT GP_AR_INVOICE_AMOUNT
, GP_AR_CASH_APPLIED_AMOUNT GP_AR_CASH_APPLIED_AMOUNT
, GP_AR_INVOICE_WRITEOFF_AMOUNT GP_AR_INVOICE_WRITEOFF_AMOUNT
, GP_AR_CREDIT_MEMO_AMOUNT GP_AR_CREDIT_MEMO_AMOUNT
, GP_UNBILLED_RECEIVABLES GP_UNBILLED_RECEIVABLES
, GP_UNEARNED_REVENUE GP_UNEARNED_REVENUE
, GP_AR_UNAPPR_INVOICE_AMOUNT GP_AR_UNAPPR_INVOICE_AMOUNT
, GP_AR_APPR_INVOICE_AMOUNT GP_AR_APPR_INVOICE_AMOUNT
, GP_AR_AMOUNT_DUE GP_AR_AMOUNT_DUE
, GP_AR_AMOUNT_OVERDUE GP_AR_AMOUNT_OVERDUE
, GL_CALENDAR_ID GL_CALENDAR_ID
, PA_CALENDAR_ID PA_CALENDAR_ID
, DANGLING_GL_RATE2_FLAG DANGLING_GL_RATE2_FLAG
, DANGLING_PA_RATE2_FLAG DANGLING_PA_RATE2_FLAG
, 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
, GG2_REVENUE GG2_REVENUE
, GG2_FUNDING GG2_FUNDING
, GG2_INITIAL_FUNDING_AMOUNT GG2_INITIAL_FUNDING_AMOUNT
, GG2_ADDITIONAL_FUNDING_AMOUNT GG2_ADDITIONAL_FUNDING_AMOUNT
, GG2_CANCELLED_FUNDING_AMOUNT GG2_CANCELLED_FUNDING_AMOUNT
, GG2_FUNDING_ADJUSTMENT_AMOUNT GG2_FUNDING_ADJUSTMENT_AMOUNT
, GG2_REVENUE_WRITEOFF GG2_REVENUE_WRITEOFF
, GG2_AR_INVOICE_AMOUNT GG2_AR_INVOICE_AMOUNT
, GG2_AR_CASH_APPLIED_AMOUNT GG2_AR_CASH_APPLIED_AMOUNT
, GG2_AR_INVOICE_WRITEOFF_AMOUNT GG2_AR_INVOICE_WRITEOFF_AMOUNT
, GG2_AR_CREDIT_MEMO_AMOUNT GG2_AR_CREDIT_MEMO_AMOUNT
, GG2_UNBILLED_RECEIVABLES GG2_UNBILLED_RECEIVABLES
, GG2_UNEARNED_REVENUE GG2_UNEARNED_REVENUE
, GG2_AR_UNAPPR_INVOICE_AMOUNT GG2_AR_UNAPPR_INVOICE_AMOUNT
, GG2_AR_APPR_INVOICE_AMOUNT GG2_AR_APPR_INVOICE_AMOUNT
, GG2_AR_AMOUNT_DUE GG2_AR_AMOUNT_DUE
, GG2_AR_AMOUNT_OVERDUE GG2_AR_AMOUNT_OVERDUE
, GP2_REVENUE GP2_REVENUE
, GP2_FUNDING GP2_FUNDING
, GP2_INITIAL_FUNDING_AMOUNT GP2_INITIAL_FUNDING_AMOUNT
, GP2_ADDITIONAL_FUNDING_AMOUNT GP2_ADDITIONAL_FUNDING_AMOUNT
, GP2_CANCELLED_FUNDING_AMOUNT GP2_CANCELLED_FUNDING_AMOUNT
, GP2_FUNDING_ADJUSTMENT_AMOUNT GP2_FUNDING_ADJUSTMENT_AMOUNT
, GP2_REVENUE_WRITEOFF GP2_REVENUE_WRITEOFF
, GP2_AR_INVOICE_AMOUNT GP2_AR_INVOICE_AMOUNT
, GP2_AR_CASH_APPLIED_AMOUNT GP2_AR_CASH_APPLIED_AMOUNT
, GP2_AR_INVOICE_WRITEOFF_AMOUNT GP2_AR_INVOICE_WRITEOFF_AMOUNT
, GP2_AR_CREDIT_MEMO_AMOUNT GP2_AR_CREDIT_MEMO_AMOUNT
, GP2_UNBILLED_RECEIVABLES GP2_UNBILLED_RECEIVABLES
, GP2_UNEARNED_REVENUE GP2_UNEARNED_REVENUE
, GP2_AR_UNAPPR_INVOICE_AMOUNT GP2_AR_UNAPPR_INVOICE_AMOUNT
, GP2_AR_APPR_INVOICE_AMOUNT GP2_AR_APPR_INVOICE_AMOUNT
, GP2_AR_AMOUNT_DUE GP2_AR_AMOUNT_DUE
, GP2_AR_AMOUNT_OVERDUE GP2_AR_AMOUNT_OVERDUE
FROM "PJI"."PJI_FM_DNGL_ACT"