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.

VIEW: BIM.BIM_R_FDSP_WEEKLY_FACTS#

Source

View Text - Preformatted


select SPEND_TRANSACTION_ID SPEND_TRANSACTION_ID, CREATION_DATE CREATION_DATE, CREATED_BY CREATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, FUND_ID FUND_ID, BUSINESS_UNIT_ID BUSINESS_UNIT_ID, OBJECT_ID OBJECT_ID, OBJECT_TYPE OBJECT_TYPE, STANDARD_DISCOUNT STANDARD_DISCOUNT, ACCRUAL ACCRUAL, MARKET_EXPENSE MARKET_EXPENSE, COMMITED_AMT COMMITED_AMT, PLANNED_AMT PLANNED_AMT, PAID_AMT PAID_AMT, DELETE_FLAG DELETE_FLAG, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE, LOAD_DATE LOAD_DATE, UTIL_ORG_ID UTIL_ORG_ID, SECURITY_GROUP_ID SECURITY_GROUP_ID, METRICS1 METRICS1, METRICS2 METRICS2, METRICS3 METRICS3, METRICS4 METRICS4, METRICS5 METRICS5, METRICS6 METRICS6, METRICS7 METRICS7, METRICS8 METRICS8, METRICS9 METRICS9, METRICS10 METRICS10, METRICS11 METRICS11, METRICS12 METRICS12, METRICS13 METRICS13, METRICS14 METRICS14, METRICS15 METRICS15, FIS_MONTH FIS_MONTH, FIS_QTR FIS_QTR, FIS_YEAR FIS_YEAR from "BIM"."BIM_R_FDSP_WEEKLY_FACTS"

View Text - HTML Formatted

SELECT SPEND_TRANSACTION_ID SPEND_TRANSACTION_ID
, CREATION_DATE CREATION_DATE
, CREATED_BY CREATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, FUND_ID FUND_ID
, BUSINESS_UNIT_ID BUSINESS_UNIT_ID
, OBJECT_ID OBJECT_ID
, OBJECT_TYPE OBJECT_TYPE
, STANDARD_DISCOUNT STANDARD_DISCOUNT
, ACCRUAL ACCRUAL
, MARKET_EXPENSE MARKET_EXPENSE
, COMMITED_AMT COMMITED_AMT
, PLANNED_AMT PLANNED_AMT
, PAID_AMT PAID_AMT
, DELETE_FLAG DELETE_FLAG
, TRANSACTION_CREATE_DATE TRANSACTION_CREATE_DATE
, LOAD_DATE LOAD_DATE
, UTIL_ORG_ID UTIL_ORG_ID
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, METRICS1 METRICS1
, METRICS2 METRICS2
, METRICS3 METRICS3
, METRICS4 METRICS4
, METRICS5 METRICS5
, METRICS6 METRICS6
, METRICS7 METRICS7
, METRICS8 METRICS8
, METRICS9 METRICS9
, METRICS10 METRICS10
, METRICS11 METRICS11
, METRICS12 METRICS12
, METRICS13 METRICS13
, METRICS14 METRICS14
, METRICS15 METRICS15
, FIS_MONTH FIS_MONTH
, FIS_QTR FIS_QTR
, FIS_YEAR FIS_YEAR
FROM "BIM"."BIM_R_FDSP_WEEKLY_FACTS"