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]

TYPE: APPS.PO_RTRVD_TCS_REC

Object Details

Object Name:	PO_RTRVD_TCS_REC
Object Type:	TYPE
Owner:	APPS
Subobject Name:
Status:	VALID

Type Details

Type Code:	OBJECT
Predefined:	NO
Incomplete:	NO

Attributes

Name	Datatype	Length	Prcn
PO_HEADER_ID	PO_TBL_NUMBER
PO_NUMBER	PO_TBL_VARCHAR50
PO_LINE_ID	PO_TBL_NUMBER
PO_LINE_NUMBER	PO_TBL_NUMBER
ORG_ID	PO_TBL_NUMBER
PO_CREATION_DATE	PO_TBL_DATE
CONTRACTOR_FULL_NAME	PO_TBL_VARCHAR240
PROJECT_ID	PO_TBL_NUMBER
PROJECT_NAME	PO_TBL_VARCHAR240
TASK_ID	PO_TBL_NUMBER
TASK_NUMBER	PO_TBL_NUMBER
TC_ID	PO_TBL_NUMBER
TC_DAY_ID	PO_TBL_NUMBER
TC_DETAIL_ID	PO_TBL_NUMBER
TC_SCOPE	PO_TBL_VARCHAR30
TC_UOM	PO_TBL_VARCHAR30
TC_START_DATE	PO_TBL_DATE
TC_END_DATE	PO_TBL_DATE
TC_ENTRY_DATE	PO_TBL_DATE
TC_TIME_RECEIVED	PO_TBL_NUMBER
TC_SUBMISSION_DATE	PO_TBL_DATE
TC_APPROVAL_DATE	PO_TBL_DATE
TC_APPROVAL_STATUS	PO_TBL_VARCHAR30
CONTINGENT_WORKER_ID	PO_TBL_NUMBER
TC_COMMENT_TEXT	PO_TBL_VARCHAR2000
LINE_RATE_TYPE	PO_TBL_VARCHAR30
LINE_RATE	PO_TBL_NUMBER
PO_CURRENCY	PO_TBL_VARCHAR15
VENDOR_ID	PO_TBL_NUMBER
VENDOR_SITE_ID	PO_TBL_NUMBER
VENDOR_CONTACT_ID	PO_TBL_NUMBER
CONTRACTOR_FIRST_NAME	PO_TBL_VARCHAR240
CONTRACTOR_LAST_NAME	PO_TBL_VARCHAR240

Dependencies

[top of page]

APPS.PO_RTRVD_TCS_REC references the following:

APPS: PO_TBL_DATE; PO_TBL_NUMBER; PO_TBL_VARCHAR15; PO_TBL_VARCHAR2000; PO_TBL_VARCHAR240; PO_TBL_VARCHAR30; PO_TBL_VARCHAR50

APPS.PO_RTRVD_TCS_REC is not referenced by any database object