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

Object Details

Object Name:	AHL_RT_OPER_LABOR_V
Object Type:	VIEW
Owner:	APPS
FND Design Data:	AHL.AHL_RT_OPER_LABOR_V
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
RT_OPER_LABOR_ID	NUMBER		Yes
OBJECT_VERSION_NUMBER	NUMBER		Yes
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
CREATED_BY	NUMBER	(15)	Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
OBJECT_ID	NUMBER		Yes
SKILL_COMPETENCE_ID	NUMBER	(15)
SKILL_NAME	VARCHAR2	(700)	Yes
SKILL_RATING_LEVEL_ID	NUMBER	(15)
SKILL_LEVEL_DESCRIPTION	VARCHAR2	(121)
ASSOCIATION_TYPE_CODE	VARCHAR2	(30)	Yes
REVISION_NUMBER	NUMBER		Yes
HEADCOUNT	NUMBER		Yes
DURATION	NUMBER
TIME_SPAN	NUMBER
SIGN_OFF_FLAG	VARCHAR2	(1)

Query Text

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


SELECT RT_OPER_LABOR_ID
,      OBJECT_VERSION_NUMBER
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      OBJECT_ID
,      SKILL_COMPETENCE_ID
,      SKILL_NAME
,      SKILL_RATING_LEVEL_ID
,      SKILL_LEVEL_DESCRIPTION
,      ASSOCIATION_TYPE_CODE
,      REVISION_NUMBER
,      HEADCOUNT
,      DURATION
,      TIME_SPAN
,      SIGN_OFF_FLAG
FROM APPS.AHL_RT_OPER_LABOR_V;

Dependencies

[top of page]

APPS.AHL_RT_OPER_LABOR_V references the following:

APPS: AHL_RT_OPER_LABOR; PER_COMPETENCES; PER_RATING_LEVELS

APPS.AHL_RT_OPER_LABOR_V is not referenced by any database object