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_ACCUM_HEADER#

Source

View Text - Preformatted


select TXN_ACCUM_HEADER_ID TXN_ACCUM_HEADER_ID, PROJECT_ID PROJECT_ID, TASK_ID TASK_ID, PERSON_ID PERSON_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, 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, EXPENDITURE_CATEGORY_ID EXPENDITURE_CATEGORY_ID, EVENT_TYPE_ID EVENT_TYPE_ID, 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, EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_ID, PERSON_TYPE PERSON_TYPE, CBS_ELEMENT_ID CBS_ELEMENT_ID from "PJI"."PJI_FP_TXN_ACCUM_HEADER"

View Text - HTML Formatted

SELECT TXN_ACCUM_HEADER_ID TXN_ACCUM_HEADER_ID
, PROJECT_ID PROJECT_ID
, TASK_ID TASK_ID
, PERSON_ID PERSON_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
, 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
, EXPENDITURE_CATEGORY_ID EXPENDITURE_CATEGORY_ID
, EVENT_TYPE_ID EVENT_TYPE_ID
, 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
, EXPENDITURE_TYPE_ID EXPENDITURE_TYPE_ID
, PERSON_TYPE PERSON_TYPE
, CBS_ELEMENT_ID CBS_ELEMENT_ID
FROM "PJI"."PJI_FP_TXN_ACCUM_HEADER"