Product: | OTA - Learning Management |
---|---|
Description: | Business view template from which the flexfield view is generated. |
Implementation/DBA Data: | APPS.OTFV_RESOURCES |
SELECT BGRT.NAME BUSINESS_GROUP_NAME
, HR_BIS.BIS_DECODE_LOOKUP('RESOURCE_TYPE'
, TSR.RESOURCE_TYPE) RESOURCE_TYPE
, TSR.NAME RESOURCE_NAME
, TSR.COMMENTS SUPPLIABLE_RESOURCE_COMMENTS
, TSR.INTERNAL_ADDRESS_LINE ADDRESS
, TSR.COST COST
, TSR.COST_UNIT COST_UNIT
, OTA_GENERAL.FND_CURRENCY_NAME(TSR.CURRENCY_CODE) CURRENCY
, TSR.INTERNAL_ADDRESS_LINE RESOURCE_ADDRESS
, TSR.CAPACITY RESOURCE_CAPACITY
, TSR.START_DATE RESOURCE_START_DATE
, TSR.END_DATE RESOURCE_END_DATE
, HR_BIS.BIS_DECODE_LOOKUP('YES_NO'
, TSR.CONSUMABLE_FLAG) RESOURCE_CONSUMABLE
, TSR.LEAD_TIME SUPPLIER_LEAD_TIME
, TSR.SUPPLIER_REFERENCE SUPPLIER_REFERENCE
, VEN.VENDOR_NAME SUPPLIER_NAME
, '_KF:OTA:RES:RES'
, '_DF:OTA:OTA_SUPPLIABLE_RESOURCES:TSR'
, TSR.BUSINESS_GROUP_ID BUSINESS_GROUP_ID
, TSR.VENDOR_ID VENDOR_ID
, TSR.RESOURCE_DEFINITION_ID RESOURCE_DEFINITION_ID
, TSR.SUPPLIED_RESOURCE_ID SUPPLIED_RESOURCE_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, OTA_SUPPLIABLE_RESOURCES TSR
, PO_VENDORS VEN
, OTA_RESOURCE_DEFINITIONS RES
WHERE TSR.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND TSR.VENDOR_ID = VEN.VENDOR_ID (+)
AND TSR.RESOURCE_DEFINITION_ID = RES.RESOURCE_DEFINITION_ID
AND TSR.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, TSR.BUSINESS_GROUP_ID) WITH READ ONLY