VIEW: APPS.OTFV_RESOURCES

Source

View Text - Preformatted

SELECT bgrT.name business_group_name ,hr_bis.bis_decode_lookup('RESOURCE_TYPE',tsr.resource_type) resource_type ,tst.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 ,orgT1.name training_center ,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.training_center_id training_center_id ,tsr.supplied_resource_id supplied_resource_id FROM hr_all_organization_units_tl bgrT ,hr_all_organization_units_tl orgT1 ,ota_suppliable_resources tsr ,ota_suppliable_resources_tl tst ,po_vendors ven ,ota_resource_definitions res WHERE tsr.business_group_id = bgrT.organization_id AND bgrT.language = userenv('LANG') AND tsr.supplied_resource_id = tst.supplied_resource_id AND tst.language = userenv('LANG') AND tsr.vendor_id = ven.vendor_id (+) AND tsr.resource_definition_id = res.resource_definition_id AND tsr.training_center_id = orgT1.organization_id (+) AND orgT1.language (+) = userenv('LANG') AND tsr.business_group_id = NVL(ota_general.get_business_group_id,tsr.business_group_id) WITH READ ONLY

View Text - HTML Formatted

SELECT BGRT.NAME BUSINESS_GROUP_NAME
, HR_BIS.BIS_DECODE_LOOKUP('RESOURCE_TYPE'
, TSR.RESOURCE_TYPE) RESOURCE_TYPE
, TST.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
, ORGT1.NAME TRAINING_CENTER
, 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.TRAINING_CENTER_ID TRAINING_CENTER_ID
, TSR.SUPPLIED_RESOURCE_ID SUPPLIED_RESOURCE_ID
FROM HR_ALL_ORGANIZATION_UNITS_TL BGRT
, HR_ALL_ORGANIZATION_UNITS_TL ORGT1
, OTA_SUPPLIABLE_RESOURCES TSR
, OTA_SUPPLIABLE_RESOURCES_TL TST
, PO_VENDORS VEN
, OTA_RESOURCE_DEFINITIONS RES
WHERE TSR.BUSINESS_GROUP_ID = BGRT.ORGANIZATION_ID
AND BGRT.LANGUAGE = USERENV('LANG')
AND TSR.SUPPLIED_RESOURCE_ID = TST.SUPPLIED_RESOURCE_ID
AND TST.LANGUAGE = USERENV('LANG')
AND TSR.VENDOR_ID = VEN.VENDOR_ID (+)
AND TSR.RESOURCE_DEFINITION_ID = RES.RESOURCE_DEFINITION_ID
AND TSR.TRAINING_CENTER_ID = ORGT1.ORGANIZATION_ID (+)
AND ORGT1.LANGUAGE (+) = USERENV('LANG')
AND TSR.BUSINESS_GROUP_ID = NVL(OTA_GENERAL.GET_BUSINESS_GROUP_ID
, TSR.BUSINESS_GROUP_ID) WITH READ ONLY