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

Source

View Text - Preformatted


select PLAN_RES_DEFAULT_ID PLAN_RES_DEFAULT_ID, RESOURCE_CLASS_ID RESOURCE_CLASS_ID, OBJECT_TYPE OBJECT_TYPE, OBJECT_ID OBJECT_ID, SPREAD_CURVE_ID SPREAD_CURVE_ID, ETC_METHOD_CODE ETC_METHOD_CODE, EXPENDITURE_TYPE EXPENDITURE_TYPE, ITEM_CATEGORY_SET_ID ITEM_CATEGORY_SET_ID, ITEM_MASTER_ID ITEM_MASTER_ID, MFC_COST_TYPE_ID MFC_COST_TYPE_ID, ENABLED_FLAG ENABLED_FLAG, 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, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER, ZD_EDITION_NAME ZD_EDITION_NAME from "PA"."PA_PLAN_RES_DEFAULTS"

View Text - HTML Formatted

SELECT PLAN_RES_DEFAULT_ID PLAN_RES_DEFAULT_ID
, RESOURCE_CLASS_ID RESOURCE_CLASS_ID
, OBJECT_TYPE OBJECT_TYPE
, OBJECT_ID OBJECT_ID
, SPREAD_CURVE_ID SPREAD_CURVE_ID
, ETC_METHOD_CODE ETC_METHOD_CODE
, EXPENDITURE_TYPE EXPENDITURE_TYPE
, ITEM_CATEGORY_SET_ID ITEM_CATEGORY_SET_ID
, ITEM_MASTER_ID ITEM_MASTER_ID
, MFC_COST_TYPE_ID MFC_COST_TYPE_ID
, ENABLED_FLAG ENABLED_FLAG
, 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
, RECORD_VERSION_NUMBER RECORD_VERSION_NUMBER
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "PA"."PA_PLAN_RES_DEFAULTS"