VIEW: PJI.PJI_FM_AGGR_FIN6#

Source

View Text - Preformatted

select WORKER_ID WORKER_ID, RECORD_TYPE RECORD_TYPE, PERSON_ID PERSON_ID, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID, RESOURCE_CLASS_ID RESOURCE_CLASS_ID, JOB_ID JOB_ID, VENDOR_ID VENDOR_ID, WORK_TYPE_ID WORK_TYPE_ID, EXPENDITURE_CATEGORY_ID EXPENDITURE_CATEGORY_ID, EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_ID, EVENT_TYPE_ID EVENT_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, NON_LABOR_RESOURCE_ID NON_LABOR_RESOURCE_ID, BOM_LABOR_RESOURCE_ID BOM_LABOR_RESOURCE_ID, BOM_EQUIPMENT_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID, ITEM_CATEGORY_ID ITEM_CATEGORY_ID, INVENTORY_ITEM_ID INVENTORY_ITEM_ID, PROJECT_ROLE_ID PROJECT_ROLE_ID, NAMED_ROLE NAMED_ROLE, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION, PROJECT_ID PROJECT_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS, TASK_ID TASK_ID, RECVR_PERIOD_TYPE RECVR_PERIOD_TYPE, RECVR_PERIOD_ID RECVR_PERIOD_ID, TXN_CURRENCY_CODE TXN_CURRENCY_CODE, TXN_REVENUE TXN_REVENUE, TXN_RAW_COST TXN_RAW_COST, TXN_BRDN_COST TXN_BRDN_COST, TXN_BILL_RAW_COST TXN_BILL_RAW_COST, TXN_BILL_BRDN_COST TXN_BILL_BRDN_COST, TXN_SUP_INV_COMMITTED_COST TXN_SUP_INV_COMMITTED_COST, TXN_PO_COMMITTED_COST TXN_PO_COMMITTED_COST, TXN_PR_COMMITTED_COST TXN_PR_COMMITTED_COST, TXN_OTH_COMMITTED_COST TXN_OTH_COMMITTED_COST, PRJ_REVENUE PRJ_REVENUE, PRJ_RAW_COST PRJ_RAW_COST, PRJ_BRDN_COST PRJ_BRDN_COST, PRJ_BILL_RAW_COST PRJ_BILL_RAW_COST, PRJ_BILL_BRDN_COST PRJ_BILL_BRDN_COST, PRJ_REVENUE_WRITEOFF PRJ_REVENUE_WRITEOFF, PRJ_SUP_INV_COMMITTED_COST PRJ_SUP_INV_COMMITTED_COST, PRJ_PO_COMMITTED_COST PRJ_PO_COMMITTED_COST, PRJ_PR_COMMITTED_COST PRJ_PR_COMMITTED_COST, PRJ_OTH_COMMITTED_COST PRJ_OTH_COMMITTED_COST, POU_REVENUE POU_REVENUE, POU_RAW_COST POU_RAW_COST, POU_BRDN_COST POU_BRDN_COST, POU_BILL_RAW_COST POU_BILL_RAW_COST, POU_BILL_BRDN_COST POU_BILL_BRDN_COST, POU_REVENUE_WRITEOFF POU_REVENUE_WRITEOFF, POU_SUP_INV_COMMITTED_COST POU_SUP_INV_COMMITTED_COST, POU_PO_COMMITTED_COST POU_PO_COMMITTED_COST, POU_PR_COMMITTED_COST POU_PR_COMMITTED_COST, POU_OTH_COMMITTED_COST POU_OTH_COMMITTED_COST, EOU_REVENUE EOU_REVENUE, EOU_RAW_COST EOU_RAW_COST, EOU_BRDN_COST EOU_BRDN_COST, EOU_BILL_RAW_COST EOU_BILL_RAW_COST, EOU_BILL_BRDN_COST EOU_BILL_BRDN_COST, EOU_SUP_INV_COMMITTED_COST EOU_SUP_INV_COMMITTED_COST, EOU_PO_COMMITTED_COST EOU_PO_COMMITTED_COST, EOU_PR_COMMITTED_COST EOU_PR_COMMITTED_COST, EOU_OTH_COMMITTED_COST EOU_OTH_COMMITTED_COST, QUANTITY QUANTITY, BILL_QUANTITY BILL_QUANTITY, G1_REVENUE G1_REVENUE, G1_RAW_COST G1_RAW_COST, G1_BRDN_COST G1_BRDN_COST, G1_BILL_RAW_COST G1_BILL_RAW_COST, G1_BILL_BRDN_COST G1_BILL_BRDN_COST, G1_REVENUE_WRITEOFF G1_REVENUE_WRITEOFF, G1_SUP_INV_COMMITTED_COST G1_SUP_INV_COMMITTED_COST, G1_PO_COMMITTED_COST G1_PO_COMMITTED_COST, G1_PR_COMMITTED_COST G1_PR_COMMITTED_COST, G1_OTH_COMMITTED_COST G1_OTH_COMMITTED_COST, G2_REVENUE G2_REVENUE, G2_RAW_COST G2_RAW_COST, G2_BRDN_COST G2_BRDN_COST, G2_BILL_RAW_COST G2_BILL_RAW_COST, G2_BILL_BRDN_COST G2_BILL_BRDN_COST, G2_REVENUE_WRITEOFF G2_REVENUE_WRITEOFF, G2_SUP_INV_COMMITTED_COST G2_SUP_INV_COMMITTED_COST, G2_PO_COMMITTED_COST G2_PO_COMMITTED_COST, G2_PR_COMMITTED_COST G2_PR_COMMITTED_COST, G2_OTH_COMMITTED_COST G2_OTH_COMMITTED_COST, PERSON_TYPE PERSON_TYPE, ASSIGNMENT_ID ASSIGNMENT_ID, CBS_ELEMENT_ID CBS_ELEMENT_ID from "PJI"."PJI_FM_AGGR_FIN6"

View Text - HTML Formatted

SELECT WORKER_ID WORKER_ID
, RECORD_TYPE RECORD_TYPE
, PERSON_ID PERSON_ID
, EXPENDITURE_ORG_ID EXPENDITURE_ORG_ID
, EXPENDITURE_ORGANIZATION_ID EXPENDITURE_ORGANIZATION_ID
, RESOURCE_CLASS_ID RESOURCE_CLASS_ID
, JOB_ID JOB_ID
, VENDOR_ID VENDOR_ID
, WORK_TYPE_ID WORK_TYPE_ID
, EXPENDITURE_CATEGORY_ID EXPENDITURE_CATEGORY_ID
, EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_ID
, EVENT_TYPE_ID EVENT_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
, NON_LABOR_RESOURCE_ID NON_LABOR_RESOURCE_ID
, BOM_LABOR_RESOURCE_ID BOM_LABOR_RESOURCE_ID
, BOM_EQUIPMENT_RESOURCE_ID BOM_EQUIPMENT_RESOURCE_ID
, ITEM_CATEGORY_ID ITEM_CATEGORY_ID
, INVENTORY_ITEM_ID INVENTORY_ITEM_ID
, PROJECT_ROLE_ID PROJECT_ROLE_ID
, NAMED_ROLE NAMED_ROLE
, SYSTEM_LINKAGE_FUNCTION SYSTEM_LINKAGE_FUNCTION
, PROJECT_ID PROJECT_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, PROJECT_TYPE_CLASS PROJECT_TYPE_CLASS
, TASK_ID TASK_ID
, RECVR_PERIOD_TYPE RECVR_PERIOD_TYPE
, RECVR_PERIOD_ID RECVR_PERIOD_ID
, TXN_CURRENCY_CODE TXN_CURRENCY_CODE
, TXN_REVENUE TXN_REVENUE
, TXN_RAW_COST TXN_RAW_COST
, TXN_BRDN_COST TXN_BRDN_COST
, TXN_BILL_RAW_COST TXN_BILL_RAW_COST
, TXN_BILL_BRDN_COST TXN_BILL_BRDN_COST
, TXN_SUP_INV_COMMITTED_COST TXN_SUP_INV_COMMITTED_COST
, TXN_PO_COMMITTED_COST TXN_PO_COMMITTED_COST
, TXN_PR_COMMITTED_COST TXN_PR_COMMITTED_COST
, TXN_OTH_COMMITTED_COST TXN_OTH_COMMITTED_COST
, PRJ_REVENUE PRJ_REVENUE
, PRJ_RAW_COST PRJ_RAW_COST
, PRJ_BRDN_COST PRJ_BRDN_COST
, PRJ_BILL_RAW_COST PRJ_BILL_RAW_COST
, PRJ_BILL_BRDN_COST PRJ_BILL_BRDN_COST
, PRJ_REVENUE_WRITEOFF PRJ_REVENUE_WRITEOFF
, PRJ_SUP_INV_COMMITTED_COST PRJ_SUP_INV_COMMITTED_COST
, PRJ_PO_COMMITTED_COST PRJ_PO_COMMITTED_COST
, PRJ_PR_COMMITTED_COST PRJ_PR_COMMITTED_COST
, PRJ_OTH_COMMITTED_COST PRJ_OTH_COMMITTED_COST
, POU_REVENUE POU_REVENUE
, POU_RAW_COST POU_RAW_COST
, POU_BRDN_COST POU_BRDN_COST
, POU_BILL_RAW_COST POU_BILL_RAW_COST
, POU_BILL_BRDN_COST POU_BILL_BRDN_COST
, POU_REVENUE_WRITEOFF POU_REVENUE_WRITEOFF
, POU_SUP_INV_COMMITTED_COST POU_SUP_INV_COMMITTED_COST
, POU_PO_COMMITTED_COST POU_PO_COMMITTED_COST
, POU_PR_COMMITTED_COST POU_PR_COMMITTED_COST
, POU_OTH_COMMITTED_COST POU_OTH_COMMITTED_COST
, EOU_REVENUE EOU_REVENUE
, EOU_RAW_COST EOU_RAW_COST
, EOU_BRDN_COST EOU_BRDN_COST
, EOU_BILL_RAW_COST EOU_BILL_RAW_COST
, EOU_BILL_BRDN_COST EOU_BILL_BRDN_COST
, EOU_SUP_INV_COMMITTED_COST EOU_SUP_INV_COMMITTED_COST
, EOU_PO_COMMITTED_COST EOU_PO_COMMITTED_COST
, EOU_PR_COMMITTED_COST EOU_PR_COMMITTED_COST
, EOU_OTH_COMMITTED_COST EOU_OTH_COMMITTED_COST
, QUANTITY QUANTITY
, BILL_QUANTITY BILL_QUANTITY
, G1_REVENUE G1_REVENUE
, G1_RAW_COST G1_RAW_COST
, G1_BRDN_COST G1_BRDN_COST
, G1_BILL_RAW_COST G1_BILL_RAW_COST
, G1_BILL_BRDN_COST G1_BILL_BRDN_COST
, G1_REVENUE_WRITEOFF G1_REVENUE_WRITEOFF
, G1_SUP_INV_COMMITTED_COST G1_SUP_INV_COMMITTED_COST
, G1_PO_COMMITTED_COST G1_PO_COMMITTED_COST
, G1_PR_COMMITTED_COST G1_PR_COMMITTED_COST
, G1_OTH_COMMITTED_COST G1_OTH_COMMITTED_COST
, G2_REVENUE G2_REVENUE
, G2_RAW_COST G2_RAW_COST
, G2_BRDN_COST G2_BRDN_COST
, G2_BILL_RAW_COST G2_BILL_RAW_COST
, G2_BILL_BRDN_COST G2_BILL_BRDN_COST
, G2_REVENUE_WRITEOFF G2_REVENUE_WRITEOFF
, G2_SUP_INV_COMMITTED_COST G2_SUP_INV_COMMITTED_COST
, G2_PO_COMMITTED_COST G2_PO_COMMITTED_COST
, G2_PR_COMMITTED_COST G2_PR_COMMITTED_COST
, G2_OTH_COMMITTED_COST G2_OTH_COMMITTED_COST
, PERSON_TYPE PERSON_TYPE
, ASSIGNMENT_ID ASSIGNMENT_ID
, CBS_ELEMENT_ID CBS_ELEMENT_ID
FROM "PJI"."PJI_FM_AGGR_FIN6"