VIEW: APPS.HXT_TASKS_FMV

Source

View Text - Preformatted

SELECT ht.rowid row_id ,ht.id ,ht.pro_id ,ht.name ,ht.date_from ,ht.description ,ht.estimated_time ,ht.fcl_units ,hrl.meaning ,ht.date_to ,ht.created_by ,ht.creation_date ,ht.last_updated_by ,ht.last_update_date ,ht.last_update_login ,ht.task_number FROM hr_lookups hrl, hxt_tasks ht WHERE hrl.lookup_type(+) = 'HXT_TASK_UNITS' AND hrl.lookup_code(+) = ht.fcl_units AND hrl.application_id(+) = 808

View Text - HTML Formatted

SELECT HT.ROWID ROW_ID
, HT.ID
, HT.PRO_ID
, HT.NAME
, HT.DATE_FROM
, HT.DESCRIPTION
, HT.ESTIMATED_TIME
, HT.FCL_UNITS
, HRL.MEANING
, HT.DATE_TO
, HT.CREATED_BY
, HT.CREATION_DATE
, HT.LAST_UPDATED_BY
, HT.LAST_UPDATE_DATE
, HT.LAST_UPDATE_LOGIN
, HT.TASK_NUMBER
FROM HR_LOOKUPS HRL
, HXT_TASKS HT
WHERE HRL.LOOKUP_TYPE(+) = 'HXT_TASK_UNITS'
AND HRL.LOOKUP_CODE(+) = HT.FCL_UNITS
AND HRL.APPLICATION_ID(+) = 808