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: IPA.IPA_APIS_INTERFACE#

Source

View Text - Preformatted


select INTERFACE_ID INTERFACE_ID, BATCH_NAME BATCH_NAME, PROJECT_ID PROJECT_ID, PROJECT_NUMBER PROJECT_NUMBER, PROJECT_NAME PROJECT_NAME, PROJECT_ASSET_ID PROJECT_ASSET_ID, ASSET_NUMBER ASSET_NUMBER, ASSET_NAME ASSET_NAME, ASSET_STATUS ASSET_STATUS, GROUPING_METHOD1 GROUPING_METHOD1, GROUPING_METHOD2 GROUPING_METHOD2, GROUPING_METHOD3 GROUPING_METHOD3, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE, RECORD_STATUS RECORD_STATUS, ASSET_UNITS ASSET_UNITS from "IPA"."IPA_APIS_INTERFACE"

View Text - HTML Formatted

SELECT INTERFACE_ID INTERFACE_ID
, BATCH_NAME BATCH_NAME
, PROJECT_ID PROJECT_ID
, PROJECT_NUMBER PROJECT_NUMBER
, PROJECT_NAME PROJECT_NAME
, PROJECT_ASSET_ID PROJECT_ASSET_ID
, ASSET_NUMBER ASSET_NUMBER
, ASSET_NAME ASSET_NAME
, ASSET_STATUS ASSET_STATUS
, GROUPING_METHOD1 GROUPING_METHOD1
, GROUPING_METHOD2 GROUPING_METHOD2
, GROUPING_METHOD3 GROUPING_METHOD3
, DATE_PLACED_IN_SERVICE DATE_PLACED_IN_SERVICE
, RECORD_STATUS RECORD_STATUS
, ASSET_UNITS ASSET_UNITS
FROM "IPA"."IPA_APIS_INTERFACE"