eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

View: HXT_TASKS_FMV

Product:	HXT - Time and Labor
Description:
Implementation/DBA Data:	APPS.HXT_TASKS_FMV

View Text

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

Columns

Name
ROW_ID
ID
PRO_ID
NAME
DATE_FROM
DESCRIPTION
ESTIMATED_TIME
FCL_UNITS
MEANING
DATE_TO
CREATED_BY
CREATION_DATE
LAST_UPDATED_BY
LAST_UPDATE_DATE
LAST_UPDATE_LOGIN
TASK_NUMBER