VIEW: PJI.PJI_FM_AGGR_FIN1#

Source

View Text - Preformatted

select WORKER_ID WORKER_ID, SLICE_ID SLICE_ID, TXN_ACCUM_HEADER_ID TXN_ACCUM_HEADER_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PERSON_ID PERSON_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, CUSTOMER_ID CUSTOMER_ID, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, JOB_ID JOB_ID, VENDOR_ID VENDOR_ID, WORK_TYPE_ID WORK_TYPE_ID, EXP_EVT_TYPE_ID EXP_EVT_TYPE_ID, EXPENDITURE_TYPE EXPENDITURE_TYPE, EVENT_TYPE EVENT_TYPE, EVENT_TYPE_CLASSIFICATION EVENT_TYPE_CLASSIFICATION, EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY, REVENUE_CATEGORY REVENUE_CATEGORY, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION, PJI_PROJECT_RECORD_FLAG PJI_PROJECT_RECORD_FLAG, PJI_RESOURCE_RECORD_FLAG PJI_RESOURCE_RECORD_FLAG, CODE_COMBINATION_ID CODE_COMBINATION_ID, PRVDR_GL_DATE PRVDR_GL_DATE, RECVR_GL_DATE RECVR_GL_DATE, GL_PERIOD_NAME GL_PERIOD_NAME, PRVDR_PA_DATE PRVDR_PA_DATE, RECVR_PA_DATE RECVR_PA_DATE, PA_PERIOD_NAME PA_PERIOD_NAME, PRJ_REVENUE PRJ_REVENUE, PRJ_RAW_COST PRJ_RAW_COST, PRJ_BILL_RAW_COST PRJ_BILL_RAW_COST, PRJ_BURDENED_COST PRJ_BURDENED_COST, PRJ_BILL_BURDENED_COST PRJ_BILL_BURDENED_COST, POU_REVENUE POU_REVENUE, POU_RAW_COST POU_RAW_COST, POU_BILL_RAW_COST POU_BILL_RAW_COST, POU_BURDENED_COST POU_BURDENED_COST, POU_BILL_BURDENED_COST POU_BILL_BURDENED_COST, EOU_RAW_COST EOU_RAW_COST, EOU_BILL_RAW_COST EOU_BILL_RAW_COST, EOU_BURDENED_COST EOU_BURDENED_COST, EOU_BILL_BURDENED_COST EOU_BILL_BURDENED_COST, QUANTITY QUANTITY, BILL_QUANTITY BILL_QUANTITY, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS, NON_LABOR_RESOURCE NON_LABOR_RESOURCE, BOM_LABOR_RESOURCE_ID BOM_LABOR_RESOURCE_ID, BOM_EQUIPMENT_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, TXN_CURRENCY_CODE TXN_CURRENCY_CODE, TXN_REVENUE TXN_REVENUE, TXN_RAW_COST TXN_RAW_COST, TXN_BILL_RAW_COST TXN_BILL_RAW_COST, TXN_BURDENED_COST TXN_BURDENED_COST, TXN_BILL_BURDENED_COST TXN_BILL_BURDENED_COST, TXN_UBR TXN_UBR, TXN_UER TXN_UER, PRJ_UBR PRJ_UBR, PRJ_UER PRJ_UER, POU_UBR POU_UBR, POU_UER POU_UER, EOU_UBR EOU_UBR, EOU_UER EOU_UER, PO_LINE_ID PO_LINE_ID, ASSIGNMENT_ID ASSIGNMENT_ID, CBS_ELEMENT_ID CBS_ELEMENT_ID from "PJI"."PJI_FM_AGGR_FIN1"

View Text - HTML Formatted

SELECT WORKER_ID WORKER_ID
, SLICE_ID SLICE_ID
, TXN_ACCUM_HEADER_ID TXN_ACCUM_HEADER_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PERSON_ID PERSON_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, CUSTOMER_ID CUSTOMER_ID
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, JOB_ID JOB_ID
, VENDOR_ID VENDOR_ID
, WORK_TYPE_ID WORK_TYPE_ID
, EXP_EVT_TYPE_ID EXP_EVT_TYPE_ID
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, EVENT_TYPE EVENT_TYPE
, EVENT_TYPE_CLASSIFICATION EVENT_TYPE_CLASSIFICATION
, EXPENDITURE_CATEGORY EXPENDITURE_CATEGORY
, REVENUE_CATEGORY REVENUE_CATEGORY
, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION
, PJI_PROJECT_RECORD_FLAG PJI_PROJECT_RECORD_FLAG
, PJI_RESOURCE_RECORD_FLAG PJI_RESOURCE_RECORD_FLAG
, CODE_COMBINATION_ID CODE_COMBINATION_ID
, PRVDR_GL_DATE PRVDR_GL_DATE
, RECVR_GL_DATE RECVR_GL_DATE
, GL_PERIOD_NAME GL_PERIOD_NAME
, PRVDR_PA_DATE PRVDR_PA_DATE
, RECVR_PA_DATE RECVR_PA_DATE
, PA_PERIOD_NAME PA_PERIOD_NAME
, PRJ_REVENUE PRJ_REVENUE
, PRJ_RAW_COST PRJ_RAW_COST
, PRJ_BILL_RAW_COST PRJ_BILL_RAW_COST
, PRJ_BURDENED_COST PRJ_BURDENED_COST
, PRJ_BILL_BURDENED_COST PRJ_BILL_BURDENED_COST
, POU_REVENUE POU_REVENUE
, POU_RAW_COST POU_RAW_COST
, POU_BILL_RAW_COST POU_BILL_RAW_COST
, POU_BURDENED_COST POU_BURDENED_COST
, POU_BILL_BURDENED_COST POU_BILL_BURDENED_COST
, EOU_RAW_COST EOU_RAW_COST
, EOU_BILL_RAW_COST EOU_BILL_RAW_COST
, EOU_BURDENED_COST EOU_BURDENED_COST
, EOU_BILL_BURDENED_COST EOU_BILL_BURDENED_COST
, QUANTITY QUANTITY
, BILL_QUANTITY BILL_QUANTITY
, EXPENDITURE_ITEM_DATE EXPENDITURE_ITEM_DATE
, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS
, NON_LABOR_RESOURCE NON_LABOR_RESOURCE
, BOM_LABOR_RESOURCE_ID BOM_LABOR_RESOURCE_ID
, BOM_EQUIPMENT_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, TXN_CURRENCY_CODE TXN_CURRENCY_CODE
, TXN_REVENUE TXN_REVENUE
, TXN_RAW_COST TXN_RAW_COST
, TXN_BILL_RAW_COST TXN_BILL_RAW_COST
, TXN_BURDENED_COST TXN_BURDENED_COST
, TXN_BILL_BURDENED_COST TXN_BILL_BURDENED_COST
, TXN_UBR TXN_UBR
, TXN_UER TXN_UER
, PRJ_UBR PRJ_UBR
, PRJ_UER PRJ_UER
, POU_UBR POU_UBR
, POU_UER POU_UER
, EOU_UBR EOU_UBR
, EOU_UER EOU_UER
, PO_LINE_ID PO_LINE_ID
, ASSIGNMENT_ID ASSIGNMENT_ID
, CBS_ELEMENT_ID CBS_ELEMENT_ID
FROM "PJI"."PJI_FM_AGGR_FIN1"