View: AHL_RT_OPER_LABOR_V

Product:	AHL - Complex Maintenance Repair and Overhaul
Description:	View based on the table AHL_RT_OPER_LABOR and the view FND_LOOKUP_VALUES_VL to include all the corresponding descriptions of the codes.
Implementation/DBA Data:	APPS.AHL_RT_OPER_LABOR_V

View Text

SELECT AOB.RT_OPER_LABOR_ID
, AOB.OBJECT_VERSION_NUMBER
, AOB.LAST_UPDATE_DATE
, AOB.LAST_UPDATED_BY
, AOB.CREATION_DATE
, AOB.CREATED_BY
, AOB.LAST_UPDATE_LOGIN
, AOB.OBJECT_ID
, SKILL_COMPETENCE_ID
, SKILLTYPE.NAME SKILL_NAME
, SKILL_RATING_LEVEL_ID
, DECODE(SKILLLEVEL.NAME
, NULL
, NULL
, TO_CHAR(SKILLLEVEL.STEP_VALUE)||'-'||SKILLLEVEL.NAME) SKILL_LEVEL_DESCRIPTION
, ASSOCIATION_TYPE_CODE
, REVISION_NUMBER
, HEADCOUNT
, DURATION
, TIME_SPAN
, SIGN_OFF_FLAG
FROM AHL_RT_OPER_LABOR AOB
, PER_COMPETENCES SKILLTYPE
, PER_RATING_LEVELS SKILLLEVEL
WHERE SKILLTYPE.COMPETENCE_ID = AOB.SKILL_COMPETENCE_ID
AND SKILLLEVEL.RATING_LEVEL_ID (+) = AOB.SKILL_RATING_LEVEL_ID

Columns