VIEW: PJI.PJI_FP_TXN_ACCUM#

Source

View Text - Preformatted

select TXN_ACCUM_HEADER_ID TXN_ACCUM_HEADER_ID, PRJ_RAW_COST PRJ_RAW_COST, POU_RAW_COST POU_RAW_COST, EOU_RAW_COST EOU_RAW_COST, PRJ_BILL_RAW_COST PRJ_BILL_RAW_COST, POU_BILL_RAW_COST POU_BILL_RAW_COST, EOU_BILL_RAW_COST EOU_BILL_RAW_COST, PRJ_BURDENED_COST PRJ_BURDENED_COST, POU_BURDENED_COST POU_BURDENED_COST, EOU_BURDENED_COST EOU_BURDENED_COST, PRJ_BILL_BURDENED_COST PRJ_BILL_BURDENED_COST, POU_BILL_BURDENED_COST POU_BILL_BURDENED_COST, EOU_BILL_BURDENED_COST EOU_BILL_BURDENED_COST, PRJ_REVENUE PRJ_REVENUE, POU_REVENUE POU_REVENUE, POU_UBR POU_UBR, POU_UER POU_UER, QUANTITY QUANTITY, BILL_QUANTITY BILL_QUANTITY, RECVR_PERIOD_TYPE RECVR_PERIOD_TYPE, RECVR_PERIOD_NAME RECVR_PERIOD_NAME, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, RESOURCE_CLASS_ID RESOURCE_CLASS_ID, 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_ID RECVR_PERIOD_ID, TXN_CURRENCY_CODE TXN_CURRENCY_CODE, TXN_RAW_COST TXN_RAW_COST, TXN_BILL_RAW_COST TXN_BILL_RAW_COST, TXN_BRDN_COST TXN_BRDN_COST, TXN_BILL_BRDN_COST TXN_BILL_BRDN_COST, TXN_REVENUE TXN_REVENUE, PRJ_BRDN_COST PRJ_BRDN_COST, PRJ_BILL_BRDN_COST PRJ_BILL_BRDN_COST, POU_BRDN_COST POU_BRDN_COST, POU_BILL_BRDN_COST POU_BILL_BRDN_COST, EOU_BRDN_COST EOU_BRDN_COST, EOU_BILL_BRDN_COST EOU_BILL_BRDN_COST, G1_RAW_COST G1_RAW_COST, G1_BILL_RAW_COST G1_BILL_RAW_COST, G1_BRDN_COST G1_BRDN_COST, G1_BILL_BRDN_COST G1_BILL_BRDN_COST, G1_REVENUE G1_REVENUE, G2_RAW_COST G2_RAW_COST, G2_BILL_RAW_COST G2_BILL_RAW_COST, G2_BRDN_COST G2_BRDN_COST, G2_BILL_BRDN_COST G2_BILL_BRDN_COST, G2_REVENUE G2_REVENUE, ASSIGNMENT_ID ASSIGNMENT_ID, NAMED_ROLE NAMED_ROLE, CBS_ELEMENT_ID CBS_ELEMENT_ID, CBS_VERSION_ID CBS_VERSION_ID from "PJI"."PJI_FP_TXN_ACCUM"

View Text - HTML Formatted

SELECT TXN_ACCUM_HEADER_ID TXN_ACCUM_HEADER_ID
, PRJ_RAW_COST PRJ_RAW_COST
, POU_RAW_COST POU_RAW_COST
, EOU_RAW_COST EOU_RAW_COST
, PRJ_BILL_RAW_COST PRJ_BILL_RAW_COST
, POU_BILL_RAW_COST POU_BILL_RAW_COST
, EOU_BILL_RAW_COST EOU_BILL_RAW_COST
, PRJ_BURDENED_COST PRJ_BURDENED_COST
, POU_BURDENED_COST POU_BURDENED_COST
, EOU_BURDENED_COST EOU_BURDENED_COST
, PRJ_BILL_BURDENED_COST PRJ_BILL_BURDENED_COST
, POU_BILL_BURDENED_COST POU_BILL_BURDENED_COST
, EOU_BILL_BURDENED_COST EOU_BILL_BURDENED_COST
, PRJ_REVENUE PRJ_REVENUE
, POU_REVENUE POU_REVENUE
, POU_UBR POU_UBR
, POU_UER POU_UER
, QUANTITY QUANTITY
, BILL_QUANTITY BILL_QUANTITY
, RECVR_PERIOD_TYPE RECVR_PERIOD_TYPE
, RECVR_PERIOD_NAME RECVR_PERIOD_NAME
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, RESOURCE_CLASS_ID RESOURCE_CLASS_ID
, 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_ID RECVR_PERIOD_ID
, TXN_CURRENCY_CODE TXN_CURRENCY_CODE
, TXN_RAW_COST TXN_RAW_COST
, TXN_BILL_RAW_COST TXN_BILL_RAW_COST
, TXN_BRDN_COST TXN_BRDN_COST
, TXN_BILL_BRDN_COST TXN_BILL_BRDN_COST
, TXN_REVENUE TXN_REVENUE
, PRJ_BRDN_COST PRJ_BRDN_COST
, PRJ_BILL_BRDN_COST PRJ_BILL_BRDN_COST
, POU_BRDN_COST POU_BRDN_COST
, POU_BILL_BRDN_COST POU_BILL_BRDN_COST
, EOU_BRDN_COST EOU_BRDN_COST
, EOU_BILL_BRDN_COST EOU_BILL_BRDN_COST
, G1_RAW_COST G1_RAW_COST
, G1_BILL_RAW_COST G1_BILL_RAW_COST
, G1_BRDN_COST G1_BRDN_COST
, G1_BILL_BRDN_COST G1_BILL_BRDN_COST
, G1_REVENUE G1_REVENUE
, G2_RAW_COST G2_RAW_COST
, G2_BILL_RAW_COST G2_BILL_RAW_COST
, G2_BRDN_COST G2_BRDN_COST
, G2_BILL_BRDN_COST G2_BILL_BRDN_COST
, G2_REVENUE G2_REVENUE
, ASSIGNMENT_ID ASSIGNMENT_ID
, NAMED_ROLE NAMED_ROLE
, CBS_ELEMENT_ID CBS_ELEMENT_ID
, CBS_VERSION_ID CBS_VERSION_ID
FROM "PJI"."PJI_FP_TXN_ACCUM"