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]

TABLE: PO.PO_RETRIEVED_TIMECARDS

Object Details

Object Name:	PO_RETRIEVED_TIMECARDS
Object Type:	TABLE
Owner:	PO
FND Design Data:	PO.PO_RETRIEVED_TIMECARDS
Subobject Name:
Status:	VALID

Table that stores the timecard entry retrieved from OTL tables.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
PO_RETRIEVED_TIMECARDS_N1	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	VENDOR_ID VENDOR_SITE_ID
PO_RETRIEVED_TIMECARDS_N2	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_NUMBER
PO_RETRIEVED_TIMECARDS_N3	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	PO_CREATION_DATE
PO_RETRIEVED_TIMECARDS_N4	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TC_ID
PO_RETRIEVED_TIMECARDS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TC_DETAIL_ID
PO_RETRIEVED_TIMECARDS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	ACTION_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
VENDOR_ID	NUMBER		Yes	Vendor for whom the timecard entry is made.
VENDOR_SITE_ID	NUMBER			Vendor Site Id for whom the timecard entry is made.
VENDOR_CONTACT_ID	NUMBER			Vendor Contact ID for the time entry made
PO_HEADER_ID	NUMBER		Yes	HEADER_ID of the PO against which the timeentry is made.
PO_NUMBER	VARCHAR2	(20)	Yes	PO Number for wich the time entry is made.
PO_LINE_ID	NUMBER		Yes	LINE_ID of the PO for which the time entry is made.
PO_LINE_NUMBER	NUMBER		Yes	Line Number for which the time entry is made.
ORG_ID	NUMBER		Yes	Organization identifier
PO_CREATION_DATE	DATE		Yes	Date on which the PO is approved.
PO_CONTRACTOR_FULL_NAME	VARCHAR2	(240)	Yes	The full name of the contract for whom the time entry is made.
PROJECT_ID	NUMBER			Project_ID that may be associated with this PO.
PROJECT_NAME	VARCHAR2	(240)		Name of the project that the PO may be associated with.
TASK_ID	NUMBER			The task that may be associated with the project
TASK_NAME	VARCHAR2	(240)		The name of the task that may be associated with the PO.
TC_ID	NUMBER		Yes	Time card ID which references the timeentry made
TC_DAY_ID	NUMBER		Yes	The Day ID in the timecard in which the timeentry is made.
TC_DETAIL_ID	NUMBER		Yes	The id in which the timeentry is associated with under the TC_DAY_ID.
TC_UOM	VARCHAR2	(30)	Yes	UOM for the time entry
TC_START_DATE	DATE		Yes	The date on which the time entry is made.
TC_END_DATE	DATE			End date of the time entry
TC_ENTRY_DATE	DATE		Yes	Entry date of the time entry
TC_TIME_RECEIVED	NUMBER			Amount of time received
TC_SUBMISSION_DATE	DATE			Date on which the timecard is submitted
TC_APPROVAL_STATUS	VARCHAR2	(30)		Approval status of the timecard
TC_APPROVED_DATE	DATE		Yes	Date on which the Timecard is approved.
TC_SCOPE	VARCHAR2	(30)		Scope of this time entry
CONTINGENT_WORKER_ID	NUMBER		Yes	ID of the worker who made the time entry
TC_COMMENT_TEXT	VARCHAR2	(2000)		Comment stored along with the time entry
LINE_RATE_TYPE	VARCHAR2	(30)	Yes	Type of the time entry made
LINE_RATE	NUMBER		Yes	The agreed rate for the line rate type
LINE_RATE_CURRENCY	VARCHAR2	(3)	Yes	Currency in which the line rate is calculated.
PO_CONTRACTOR_LAST_NAME	VARCHAR2	(240)		Last name of the worker who entered the time.
PO_CONTRACTOR_FIRST_NAME	VARCHAR2	(240)		First name of the worker who entered the time.
INTERFACE_TRANSACTION_ID	NUMBER		Yes	Corresponding Recieving transaction id that actually made this entry.
ACTION_FLAG	VARCHAR2	(2)	Yes	Can have I, U or D to indicate the row is a result of insertion or update or a delete. This will be null if the transaction is completed.
TC_ENTRY_SEQUENCE	NUMBER		Yes	Uses the timecard sequence order

Query Text

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


SELECT VENDOR_ID
,      VENDOR_SITE_ID
,      VENDOR_CONTACT_ID
,      PO_HEADER_ID
,      PO_NUMBER
,      PO_LINE_ID
,      PO_LINE_NUMBER
,      ORG_ID
,      PO_CREATION_DATE
,      PO_CONTRACTOR_FULL_NAME
,      PROJECT_ID
,      PROJECT_NAME
,      TASK_ID
,      TASK_NAME
,      TC_ID
,      TC_DAY_ID
,      TC_DETAIL_ID
,      TC_UOM
,      TC_START_DATE
,      TC_END_DATE
,      TC_ENTRY_DATE
,      TC_TIME_RECEIVED
,      TC_SUBMISSION_DATE
,      TC_APPROVAL_STATUS
,      TC_APPROVED_DATE
,      TC_SCOPE
,      CONTINGENT_WORKER_ID
,      TC_COMMENT_TEXT
,      LINE_RATE_TYPE
,      LINE_RATE
,      LINE_RATE_CURRENCY
,      PO_CONTRACTOR_LAST_NAME
,      PO_CONTRACTOR_FIRST_NAME
,      INTERFACE_TRANSACTION_ID
,      ACTION_FLAG
,      TC_ENTRY_SEQUENCE
FROM PO.PO_RETRIEVED_TIMECARDS;

Dependencies

[top of page]

PO.PO_RETRIEVED_TIMECARDS does not reference any database object

PO.PO_RETRIEVED_TIMECARDS is referenced by following:

PO: PO_RETRIEVED_TIMECARDS#