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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: APPS.HXC_TIMECARD_AUDIT_SUMMARY

Object Details

Object Name:	HXC_TIMECARD_AUDIT_SUMMARY
Object Type:	VIEW
Owner:	APPS
FND Design Data:	HXC.HXC_TIMECARD_AUDIT_SUMMARY
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
HOURS	NUMBER		Hours entered
REASON	VARCHAR2	(80)	Reason type
REASON_COMMENT	VARCHAR2	(150)	Reason comments
REASON_TYPE	VARCHAR2	(150)	Change or late reason
PROJECT_NAME	VARCHAR2	(25)	Project name
TASK_NUMBER	VARCHAR2	(278)	task number
EXPENDITURE_TYPE	VARCHAR2	(150)	Expenditure type
DATE_ENTERED	DATE		Date entered
DAY_ENTERED	DATE		Day entered
TIMECARD_ID	NUMBER	(15)	Timecard id
DETAIL_ID	NUMBER	(15)	Detail id
DETAIL_OVN	NUMBER	(9)	Detail OVN

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT HOURS
,      REASON
,      REASON_COMMENT
,      REASON_TYPE
,      PROJECT_NAME
,      TASK_NUMBER
,      EXPENDITURE_TYPE
,      DATE_ENTERED
,      DAY_ENTERED
,      TIMECARD_ID
,      DETAIL_ID
,      DETAIL_OVN
FROM APPS.HXC_TIMECARD_AUDIT_SUMMARY;

Dependencies

[top of page]

APPS.HXC_TIMECARD_AUDIT_SUMMARY references the following:

APPS: FND_LOOKUP_VALUES; HR_GENERAL - show dependent code; HXC_BASE_PA_ONLINE_PROJECTS_V; HXC_BASE_PA_ONLINE_TASKS_V; HXC_TIME_ATTRIBUTES; HXC_TIME_ATTRIBUTE_USAGES; HXC_TIME_BUILDING_BLOCKS

APPS.HXC_TIMECARD_AUDIT_SUMMARY is not referenced by any database object