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: OTA.OTA_SUPPLIABLE_RESOURCES#

Source

View Text - Preformatted


select SUPPLIED_RESOURCE_ID SUPPLIED_RESOURCE_ID, VENDOR_ID VENDOR_ID, BUSINESS_GROUP_ID BUSINESS_GROUP_ID, RESOURCE_DEFINITION_ID RESOURCE_DEFINITION_ID, CONSUMABLE_FLAG CONSUMABLE_FLAG, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, RESOURCE_TYPE RESOURCE_TYPE, CAPACITY CAPACITY, COMMENTS COMMENTS, COST COST, COST_UNIT COST_UNIT, CURRENCY_CODE CURRENCY_CODE, END_DATE END_DATE, INTERNAL_ADDRESS_LINE INTERNAL_ADDRESS_LINE, LEAD_TIME LEAD_TIME, NAME NAME, START_DATE START_DATE, SUPPLIER_REFERENCE SUPPLIER_REFERENCE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, TSR_INFORMATION_CATEGORY TSR_INFORMATION_CATEGORY, TSR_INFORMATION1 TSR_INFORMATION1, TSR_INFORMATION2 TSR_INFORMATION2, TSR_INFORMATION3 TSR_INFORMATION3, TSR_INFORMATION4 TSR_INFORMATION4, TSR_INFORMATION5 TSR_INFORMATION5, TSR_INFORMATION6 TSR_INFORMATION6, TSR_INFORMATION7 TSR_INFORMATION7, TSR_INFORMATION8 TSR_INFORMATION8, TSR_INFORMATION9 TSR_INFORMATION9, TSR_INFORMATION10 TSR_INFORMATION10, TSR_INFORMATION11 TSR_INFORMATION11, TSR_INFORMATION12 TSR_INFORMATION12, TSR_INFORMATION13 TSR_INFORMATION13, TSR_INFORMATION14 TSR_INFORMATION14, TSR_INFORMATION15 TSR_INFORMATION15, TSR_INFORMATION16 TSR_INFORMATION16, TSR_INFORMATION17 TSR_INFORMATION17, TSR_INFORMATION18 TSR_INFORMATION18, TSR_INFORMATION19 TSR_INFORMATION19, TSR_INFORMATION20 TSR_INFORMATION20, TRAINING_CENTER_ID TRAINING_CENTER_ID, LOCATION_ID LOCATION_ID, TRAINER_ID TRAINER_ID, SPECIAL_INSTRUCTION SPECIAL_INSTRUCTION from "OTA"."OTA_SUPPLIABLE_RESOURCES"

View Text - HTML Formatted

SELECT SUPPLIED_RESOURCE_ID SUPPLIED_RESOURCE_ID
, VENDOR_ID VENDOR_ID
, BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, RESOURCE_DEFINITION_ID RESOURCE_DEFINITION_ID
, CONSUMABLE_FLAG CONSUMABLE_FLAG
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, RESOURCE_TYPE RESOURCE_TYPE
, CAPACITY CAPACITY
, COMMENTS COMMENTS
, COST COST
, COST_UNIT COST_UNIT
, CURRENCY_CODE CURRENCY_CODE
, END_DATE END_DATE
, INTERNAL_ADDRESS_LINE INTERNAL_ADDRESS_LINE
, LEAD_TIME LEAD_TIME
, NAME NAME
, START_DATE START_DATE
, SUPPLIER_REFERENCE SUPPLIER_REFERENCE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, TSR_INFORMATION_CATEGORY TSR_INFORMATION_CATEGORY
, TSR_INFORMATION1 TSR_INFORMATION1
, TSR_INFORMATION2 TSR_INFORMATION2
, TSR_INFORMATION3 TSR_INFORMATION3
, TSR_INFORMATION4 TSR_INFORMATION4
, TSR_INFORMATION5 TSR_INFORMATION5
, TSR_INFORMATION6 TSR_INFORMATION6
, TSR_INFORMATION7 TSR_INFORMATION7
, TSR_INFORMATION8 TSR_INFORMATION8
, TSR_INFORMATION9 TSR_INFORMATION9
, TSR_INFORMATION10 TSR_INFORMATION10
, TSR_INFORMATION11 TSR_INFORMATION11
, TSR_INFORMATION12 TSR_INFORMATION12
, TSR_INFORMATION13 TSR_INFORMATION13
, TSR_INFORMATION14 TSR_INFORMATION14
, TSR_INFORMATION15 TSR_INFORMATION15
, TSR_INFORMATION16 TSR_INFORMATION16
, TSR_INFORMATION17 TSR_INFORMATION17
, TSR_INFORMATION18 TSR_INFORMATION18
, TSR_INFORMATION19 TSR_INFORMATION19
, TSR_INFORMATION20 TSR_INFORMATION20
, TRAINING_CENTER_ID TRAINING_CENTER_ID
, LOCATION_ID LOCATION_ID
, TRAINER_ID TRAINER_ID
, SPECIAL_INSTRUCTION SPECIAL_INSTRUCTION
FROM "OTA"."OTA_SUPPLIABLE_RESOURCES"