VIEW: PJI.PJI_FM_PROJ_BATCH_MAP#

Source

View Text - Preformatted

select PROJECT_ID PROJECT_ID, ROW_COUNT ROW_COUNT, START_DATE START_DATE, END_DATE END_DATE, PJI_PROJECT_STATUS PJI_PROJECT_STATUS, BATCH_ID BATCH_ID, EXTRACTION_TYPE EXTRACTION_TYPE, EXTRACTION_STATUS EXTRACTION_STATUS, PROJECT_TYPE PROJECT_TYPE, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, AR_CASH_APPLIED AR_CASH_APPLIED, AR_AMOUNT_DUE_REMAINING AR_AMOUNT_DUE_REMAINING, AR_AMOUNT_OVERDUE_REMAINING AR_AMOUNT_OVERDUE_REMAINING, PLAN_EXTRACTION_STATUS PLAN_EXTRACTION_STATUS, COST_BUDGET_C_VERSION COST_BUDGET_C_VERSION, COST_BUDGET_CO_VERSION COST_BUDGET_CO_VERSION, REVENUE_BUDGET_C_VERSION REVENUE_BUDGET_C_VERSION, REVENUE_BUDGET_CO_VERSION REVENUE_BUDGET_CO_VERSION, COST_FORECAST_C_VERSION COST_FORECAST_C_VERSION, REVENUE_FORECAST_C_VERSION REVENUE_FORECAST_C_VERSION, COST_BUDGET_N_VERSION COST_BUDGET_N_VERSION, COST_BUDGET_NO_VERSION COST_BUDGET_NO_VERSION, REVENUE_BUDGET_N_VERSION REVENUE_BUDGET_N_VERSION, REVENUE_BUDGET_NO_VERSION REVENUE_BUDGET_NO_VERSION, COST_FORECAST_N_VERSION COST_FORECAST_N_VERSION, REVENUE_FORECAST_N_VERSION REVENUE_FORECAST_N_VERSION, POU_UNAPPRV_INVOICE_AMOUNT POU_UNAPPRV_INVOICE_AMOUNT, PRJ_UNAPPRV_INVOICE_AMOUNT PRJ_UNAPPRV_INVOICE_AMOUNT, UNAPPRV_INVOICE_COUNT UNAPPRV_INVOICE_COUNT, POU_APPRV_INVOICE_AMOUNT POU_APPRV_INVOICE_AMOUNT, PRJ_APPRV_INVOICE_AMOUNT PRJ_APPRV_INVOICE_AMOUNT, APPRV_INVOICE_COUNT APPRV_INVOICE_COUNT, ACTIVITY_MIN_GL_DATE ACTIVITY_MIN_GL_DATE, ACTIVITY_MIN_PA_DATE ACTIVITY_MIN_PA_DATE, OLD_CLOSED_DATE OLD_CLOSED_DATE, NEW_CLOSED_DATE NEW_CLOSED_DATE, FUNDING_MIN_DATE FUNDING_MIN_DATE, NEW_PROJECT_ORGANIZATION_ID NEW_PROJECT_ORGANIZATION_ID, BACKLOG_EXTRACTION_STATUS BACKLOG_EXTRACTION_STATUS, PARALLEL_BACKLOG_WORKER_ID PARALLEL_BACKLOG_WORKER_ID, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS, WORKER_ID WORKER_ID from "PJI"."PJI_FM_PROJ_BATCH_MAP"

View Text - HTML Formatted

SELECT PROJECT_ID PROJECT_ID
, ROW_COUNT ROW_COUNT
, START_DATE START_DATE
, END_DATE END_DATE
, PJI_PROJECT_STATUS PJI_PROJECT_STATUS
, BATCH_ID BATCH_ID
, EXTRACTION_TYPE EXTRACTION_TYPE
, EXTRACTION_STATUS EXTRACTION_STATUS
, PROJECT_TYPE PROJECT_TYPE
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, AR_CASH_APPLIED AR_CASH_APPLIED
, AR_AMOUNT_DUE_REMAINING AR_AMOUNT_DUE_REMAINING
, AR_AMOUNT_OVERDUE_REMAINING AR_AMOUNT_OVERDUE_REMAINING
, PLAN_EXTRACTION_STATUS PLAN_EXTRACTION_STATUS
, COST_BUDGET_C_VERSION COST_BUDGET_C_VERSION
, COST_BUDGET_CO_VERSION COST_BUDGET_CO_VERSION
, REVENUE_BUDGET_C_VERSION REVENUE_BUDGET_C_VERSION
, REVENUE_BUDGET_CO_VERSION REVENUE_BUDGET_CO_VERSION
, COST_FORECAST_C_VERSION COST_FORECAST_C_VERSION
, REVENUE_FORECAST_C_VERSION REVENUE_FORECAST_C_VERSION
, COST_BUDGET_N_VERSION COST_BUDGET_N_VERSION
, COST_BUDGET_NO_VERSION COST_BUDGET_NO_VERSION
, REVENUE_BUDGET_N_VERSION REVENUE_BUDGET_N_VERSION
, REVENUE_BUDGET_NO_VERSION REVENUE_BUDGET_NO_VERSION
, COST_FORECAST_N_VERSION COST_FORECAST_N_VERSION
, REVENUE_FORECAST_N_VERSION REVENUE_FORECAST_N_VERSION
, POU_UNAPPRV_INVOICE_AMOUNT POU_UNAPPRV_INVOICE_AMOUNT
, PRJ_UNAPPRV_INVOICE_AMOUNT PRJ_UNAPPRV_INVOICE_AMOUNT
, UNAPPRV_INVOICE_COUNT UNAPPRV_INVOICE_COUNT
, POU_APPRV_INVOICE_AMOUNT POU_APPRV_INVOICE_AMOUNT
, PRJ_APPRV_INVOICE_AMOUNT PRJ_APPRV_INVOICE_AMOUNT
, APPRV_INVOICE_COUNT APPRV_INVOICE_COUNT
, ACTIVITY_MIN_GL_DATE ACTIVITY_MIN_GL_DATE
, ACTIVITY_MIN_PA_DATE ACTIVITY_MIN_PA_DATE
, OLD_CLOSED_DATE OLD_CLOSED_DATE
, NEW_CLOSED_DATE NEW_CLOSED_DATE
, FUNDING_MIN_DATE FUNDING_MIN_DATE
, NEW_PROJECT_ORGANIZATION_ID NEW_PROJECT_ORGANIZATION_ID
, BACKLOG_EXTRACTION_STATUS BACKLOG_EXTRACTION_STATUS
, PARALLEL_BACKLOG_WORKER_ID PARALLEL_BACKLOG_WORKER_ID
, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS
, WORKER_ID WORKER_ID
FROM "PJI"."PJI_FM_PROJ_BATCH_MAP"