Product: | OTA - Learning Management |
---|---|
Description: | View to list information about Suppliable Resources. It is scheduled for a future release. |
Implementation/DBA Data: | APPS.OTA_SUPPLIABLE_RESOURCES_VL |
SELECT TSR.ROWID
, TSR.SUPPLIED_RESOURCE_ID
, TSR.BUSINESS_GROUP_ID
, TSR.RESOURCE_DEFINITION_ID
, TSR.CONSUMABLE_FLAG
, TSR.OBJECT_VERSION_NUMBER
, TSR.RESOURCE_TYPE
, TSR.VENDOR_ID
, TSR.CAPACITY
, TSR.COMMENTS
, TSR.COST
, TSR.COST_UNIT
, TSR.CURRENCY_CODE
, TSR.END_DATE
, TSR.INTERNAL_ADDRESS_LINE
, TSR.LEAD_TIME
, SRL.NAME
, TSR.START_DATE
, 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
, TSR.TRAINING_CENTER_ID
, TSR.LOCATION_ID
, TSR.TRAINER_ID
, SRL.SPECIAL_INSTRUCTION
FROM OTA_SUPPLIABLE_RESOURCES TSR
, OTA_SUPPLIABLE_RESOURCES_TL SRL
WHERE SRL.SUPPLIED_RESOURCE_ID=TSR.SUPPLIED_RESOURCE_ID
AND SRL.LANGUAGE= USERENV('LANG')