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: PA.PA_BUDGET_VERSIONS_EFC#

Source

View Text - Preformatted


select SET_OF_BOOKS_ID SET_OF_BOOKS_ID, BUDGET_VERSION_ID BUDGET_VERSION_ID, PROJECT_ID PROJECT_ID, BUDGET_TYPE_CODE BUDGET_TYPE_CODE, VERSION_NUMBER VERSION_NUMBER, BUDGET_STATUS_CODE BUDGET_STATUS_CODE, CREATION_DATE CREATION_DATE, CURRENT_FLAG CURRENT_FLAG, ORIGINAL_FLAG ORIGINAL_FLAG, CURRENT_ORIGINAL_FLAG CURRENT_ORIGINAL_FLAG, RESOURCE_ACCUMULATED_FLAG RESOURCE_ACCUMULATED_FLAG, RESOURCE_LIST_ID RESOURCE_LIST_ID, VERSION_NAME VERSION_NAME, BUDGET_ENTRY_METHOD_CODE BUDGET_ENTRY_METHOD_CODE, BASELINED_BY_PERSON_ID BASELINED_BY_PERSON_ID, BASELINED_DATE BASELINED_DATE, CHANGE_REASON_CODE CHANGE_REASON_CODE, LABOR_QUANTITY LABOR_QUANTITY, LABOR_UNIT_OF_MEASURE LABOR_UNIT_OF_MEASURE, RAW_COST RAW_COST, BURDENED_COST BURDENED_COST, REVENUE REVENUE, DESCRIPTION DESCRIPTION, FIRST_BUDGET_PERIOD FIRST_BUDGET_PERIOD, PM_PRODUCT_CODE PM_PRODUCT_CODE, PM_BUDGET_REFERENCE PM_BUDGET_REFERENCE, WF_STATUS_CODE WF_STATUS_CODE, ADW_NOTIFY_FLAG ADW_NOTIFY_FLAG, ADJUSTED_EFC_REVENUE_AMT ADJUSTED_EFC_REVENUE_AMT from "PA"."PA_BUDGET_VERSIONS_EFC"

View Text - HTML Formatted

SELECT SET_OF_BOOKS_ID SET_OF_BOOKS_ID
, BUDGET_VERSION_ID BUDGET_VERSION_ID
, PROJECT_ID PROJECT_ID
, BUDGET_TYPE_CODE BUDGET_TYPE_CODE
, VERSION_NUMBER VERSION_NUMBER
, BUDGET_STATUS_CODE BUDGET_STATUS_CODE
, CREATION_DATE CREATION_DATE
, CURRENT_FLAG CURRENT_FLAG
, ORIGINAL_FLAG ORIGINAL_FLAG
, CURRENT_ORIGINAL_FLAG CURRENT_ORIGINAL_FLAG
, RESOURCE_ACCUMULATED_FLAG RESOURCE_ACCUMULATED_FLAG
, RESOURCE_LIST_ID RESOURCE_LIST_ID
, VERSION_NAME VERSION_NAME
, BUDGET_ENTRY_METHOD_CODE BUDGET_ENTRY_METHOD_CODE
, BASELINED_BY_PERSON_ID BASELINED_BY_PERSON_ID
, BASELINED_DATE BASELINED_DATE
, CHANGE_REASON_CODE CHANGE_REASON_CODE
, LABOR_QUANTITY LABOR_QUANTITY
, LABOR_UNIT_OF_MEASURE LABOR_UNIT_OF_MEASURE
, RAW_COST RAW_COST
, BURDENED_COST BURDENED_COST
, REVENUE REVENUE
, DESCRIPTION DESCRIPTION
, FIRST_BUDGET_PERIOD FIRST_BUDGET_PERIOD
, PM_PRODUCT_CODE PM_PRODUCT_CODE
, PM_BUDGET_REFERENCE PM_BUDGET_REFERENCE
, WF_STATUS_CODE WF_STATUS_CODE
, ADW_NOTIFY_FLAG ADW_NOTIFY_FLAG
, ADJUSTED_EFC_REVENUE_AMT ADJUSTED_EFC_REVENUE_AMT
FROM "PA"."PA_BUDGET_VERSIONS_EFC"