Product: | OTA - Learning Management |
---|---|
Description: | View to list information about Suppliable Resources. |
Implementation/DBA Data: | APPS.OTA_SUPPLIABLE_RESOURCES_V |
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')