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.PA_SST_VIEW_TIMECARD_HISTORY_V

Object Details

Object Name:	PA_SST_VIEW_TIMECARD_HISTORY_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	PA.PA_SST_VIEW_TIMECARD_HISTORY_V
Subobject Name:
Status:	VALID

View Type

A Web view designed to simplify access from Oracle Self-Service Web Applications.

View of Submitted and Approved timecards. Used in View Timecard History function of Self Service Time.

[View Source]

Columns

Name	Datatype	Length	Mandatory	Comments
EXPENDITURE_ID	NUMBER	(15)	Yes	Unique identifier of the timecard in Projects
TIMECARD_NUMBER	VARCHAR2	(60)		External identifier of the timecard.
EXPENDITURE_GROUP	VARCHAR2	(240)	Yes	The expenditure group to which this timecard belongs
TIMECARD_STATUS	VARCHAR2	(80)	Yes	The status of the timecard as it is entered and approved.
WEEK_ENDING_DATE	DATE		Yes	The last day of the expenditure week period.
INCURRED_BY_PERSON	VARCHAR2	(240)		The name of the person who incurred the charges.
INCURRED_BY_PERSON_ID	NUMBER	(15)		The identifier of the person who incurred the charges.
INCURRED_BY_ORGANIZATION_ID	NUMBER	(15)		The identifier of the organization that incurred the charges.
INITIAL_SUBMISSION_DATE	DATE			The date on which the timecard was initially submitted.
TIMECARD_COMMENT	VARCHAR2	(250)		The header level timecard comment.
ENTERED_BY_PERSON_ID	NUMBER	(15)		The identifier of the person who entered the timecard.
OVERRIDING_APPROVER_PERSON_ID	NUMBER			The identifier of the overriding approver, if any, for the timecard.
TOTAL_HOURS	NUMBER			Total hours reported on the timecard.
VIEW_TIMECARD_URL	VARCHAR2	(254)		URL called when the user chooses to view a timecard.
COPY_IMAGE	CHAR	(42)		Image displayed for Copy Timecard.
COPY_TIMECARD_URL	VARCHAR2	(254)		URL called when the user chooses to copy a timecard.
REVERSE_IMAGE	CHAR	(43)		Image displayed for Reverse Timecard.
REVERSE_TIMECARD_URL	VARCHAR2	(257)		URL called when the user reverses a timecard.
ORG_ID	NUMBER	(15)	Yes	Operating Unit Identifier

Query Text

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


SELECT EXPENDITURE_ID
,      TIMECARD_NUMBER
,      EXPENDITURE_GROUP
,      TIMECARD_STATUS
,      WEEK_ENDING_DATE
,      INCURRED_BY_PERSON
,      INCURRED_BY_PERSON_ID
,      INCURRED_BY_ORGANIZATION_ID
,      INITIAL_SUBMISSION_DATE
,      TIMECARD_COMMENT
,      ENTERED_BY_PERSON_ID
,      OVERRIDING_APPROVER_PERSON_ID
,      TOTAL_HOURS
,      VIEW_TIMECARD_URL
,      COPY_IMAGE
,      COPY_TIMECARD_URL
,      REVERSE_IMAGE
,      REVERSE_TIMECARD_URL
,      ORG_ID
FROM APPS.PA_SST_VIEW_TIMECARD_HISTORY_V;

Dependencies

[top of page]

APPS.PA_SST_VIEW_TIMECARD_HISTORY_V references the following:

APPS: PA_EI_DENORM; PA_EXPENDITURES; PA_LOOKUPS; PER_ALL_PEOPLE_F

APPS.PA_SST_VIEW_TIMECARD_HISTORY_V is not referenced by any database object