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: APPS.OTA_SUPPLIABLE_RESOURCES_V

Source

View Text - Preformatted


SELECT TSR.ROWID , TSR.SUPPLIED_RESOURCE_ID , SRT.NAME , TSR.VENDOR_ID , VEN.VENDOR_NAME , TSR.BUSINESS_GROUP_ID , TSR.RESOURCE_DEFINITION_ID , TSR.CONSUMABLE_FLAG , CF_LOOK.MEANING , TSR.OBJECT_VERSION_NUMBER , TSR.START_DATE , TSR.COMMENTS , TSR.COST , TSR.COST_UNIT , TSR.CURRENCY_CODE ,ota_general.fnd_currency_name(tsr.currency_code) , TSR.END_DATE , TSR.INTERNAL_ADDRESS_LINE , TSR.LEAD_TIME , SRT.NAME , TSR.RESOURCE_TYPE , RT_LOOK.MEANING , TSR.SUPPLIER_REFERENCE , TSR.LAST_UPDATE_DATE , TSR.LAST_UPDATED_BY , TSR.LAST_UPDATE_LOGIN , TSR.CREATED_BY , TSR.CREATION_DATE , TSR.TSR_INFORMATION_CATEGORY , TSR.TSR_INFORMATION1 , TSR.TSR_INFORMATION2 , TSR.TSR_INFORMATION3 , TSR.TSR_INFORMATION4 , TSR.TSR_INFORMATION5 , TSR.TSR_INFORMATION6 , TSR.TSR_INFORMATION7 , TSR.TSR_INFORMATION8 , TSR.TSR_INFORMATION9 , TSR.TSR_INFORMATION10 , TSR.TSR_INFORMATION11 , TSR.TSR_INFORMATION12 , TSR.TSR_INFORMATION13 , TSR.TSR_INFORMATION14 , TSR.TSR_INFORMATION15 , TSR.TSR_INFORMATION16 , TSR.TSR_INFORMATION17 , TSR.TSR_INFORMATION18 , TSR.TSR_INFORMATION19 , TSR.TSR_INFORMATION20 , RES.ID_FLEX_NUM ,TSR.TRAINING_CENTER_ID ,TSR.LOCATION_ID ,TSR.TRAINER_ID ,SRT.SPECIAL_INSTRUCTION FROM OTA_SUPPLIABLE_RESOURCES TSR , OTA_SUPPLIABLE_RESOURCES_TL SRT , OTA_RESOURCE_DEFINITIONS RES , PO_VENDORS VEN , HR_LOOKUPS CF_LOOK , HR_LOOKUPS RT_LOOK WHERE TSR.VENDOR_ID = VEN.VENDOR_ID (+) AND CF_LOOK.LOOKUP_TYPE = 'YES_NO' AND CF_LOOK.LOOKUP_CODE = TSR.CONSUMABLE_FLAG AND RT_LOOK.LOOKUP_TYPE = 'RESOURCE_TYPE' AND RT_LOOK.LOOKUP_CODE = TSR.RESOURCE_TYPE AND TSR.RESOURCE_DEFINITION_ID = RES.RESOURCE_DEFINITION_ID AND SRT.SUPPLIED_RESOURCE_ID = TSR.SUPPLIED_RESOURCE_ID AND SRT.LANGUAGE = USERENV('LANG')

View Text - HTML Formatted

SELECT TSR.ROWID
, TSR.SUPPLIED_RESOURCE_ID
, SRT.NAME
, TSR.VENDOR_ID
, VEN.VENDOR_NAME
, TSR.BUSINESS_GROUP_ID
, TSR.RESOURCE_DEFINITION_ID
, TSR.CONSUMABLE_FLAG
, CF_LOOK.MEANING
, TSR.OBJECT_VERSION_NUMBER
, TSR.START_DATE
, TSR.COMMENTS
, TSR.COST
, TSR.COST_UNIT
, TSR.CURRENCY_CODE
, OTA_GENERAL.FND_CURRENCY_NAME(TSR.CURRENCY_CODE)
, TSR.END_DATE
, TSR.INTERNAL_ADDRESS_LINE
, TSR.LEAD_TIME
, SRT.NAME
, TSR.RESOURCE_TYPE
, RT_LOOK.MEANING
, TSR.SUPPLIER_REFERENCE
, TSR.LAST_UPDATE_DATE
, TSR.LAST_UPDATED_BY
, TSR.LAST_UPDATE_LOGIN
, TSR.CREATED_BY
, TSR.CREATION_DATE
, TSR.TSR_INFORMATION_CATEGORY
, TSR.TSR_INFORMATION1
, TSR.TSR_INFORMATION2
, TSR.TSR_INFORMATION3
, TSR.TSR_INFORMATION4
, TSR.TSR_INFORMATION5
, TSR.TSR_INFORMATION6
, TSR.TSR_INFORMATION7
, TSR.TSR_INFORMATION8
, TSR.TSR_INFORMATION9
, TSR.TSR_INFORMATION10
, TSR.TSR_INFORMATION11
, TSR.TSR_INFORMATION12
, TSR.TSR_INFORMATION13
, TSR.TSR_INFORMATION14
, TSR.TSR_INFORMATION15
, TSR.TSR_INFORMATION16
, TSR.TSR_INFORMATION17
, TSR.TSR_INFORMATION18
, TSR.TSR_INFORMATION19
, TSR.TSR_INFORMATION20
, RES.ID_FLEX_NUM
, TSR.TRAINING_CENTER_ID
, TSR.LOCATION_ID
, TSR.TRAINER_ID
, SRT.SPECIAL_INSTRUCTION
FROM OTA_SUPPLIABLE_RESOURCES TSR
, OTA_SUPPLIABLE_RESOURCES_TL SRT
, OTA_RESOURCE_DEFINITIONS RES
, PO_VENDORS VEN
, HR_LOOKUPS CF_LOOK
, HR_LOOKUPS RT_LOOK
WHERE TSR.VENDOR_ID = VEN.VENDOR_ID (+)
AND CF_LOOK.LOOKUP_TYPE = 'YES_NO'
AND CF_LOOK.LOOKUP_CODE = TSR.CONSUMABLE_FLAG
AND RT_LOOK.LOOKUP_TYPE = 'RESOURCE_TYPE'
AND RT_LOOK.LOOKUP_CODE = TSR.RESOURCE_TYPE
AND TSR.RESOURCE_DEFINITION_ID = RES.RESOURCE_DEFINITION_ID
AND SRT.SUPPLIED_RESOURCE_ID = TSR.SUPPLIED_RESOURCE_ID
AND SRT.LANGUAGE = USERENV('LANG')