eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: PJI.PJI_FP_TXN_ACCUM1#

Source

View Text - Preformatted


select TXN_ACCUM_HEADER_ID TXN_ACCUM_HEADER_ID, PROJECT_ID PROJECT_ID, PROJECT_ORG_ID PROJECT_ORG_ID, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID, TASK_ID TASK_ID, RECVR_PERIOD_TYPE RECVR_PERIOD_TYPE, RECVR_PERIOD_ID RECVR_PERIOD_ID, TXN_CURRENCY_CODE TXN_CURRENCY_CODE, 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_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_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_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, 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_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, 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, CBS_ELEMENT_ID CBS_ELEMENT_ID, CBS_VERSION_ID CBS_VERSION_ID from "PJI"."PJI_FP_TXN_ACCUM1"

View Text - HTML Formatted

SELECT TXN_ACCUM_HEADER_ID TXN_ACCUM_HEADER_ID
, PROJECT_ID PROJECT_ID
, PROJECT_ORG_ID PROJECT_ORG_ID
, PROJECT_ORGANIZATION_ID PROJECT_ORGANIZATION_ID
, TASK_ID TASK_ID
, RECVR_PERIOD_TYPE RECVR_PERIOD_TYPE
, RECVR_PERIOD_ID RECVR_PERIOD_ID
, TXN_CURRENCY_CODE TXN_CURRENCY_CODE
, 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_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_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_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
, 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_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
, 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
, CBS_ELEMENT_ID CBS_ELEMENT_ID
, CBS_VERSION_ID CBS_VERSION_ID
FROM "PJI"."PJI_FP_TXN_ACCUM1"