VIEW: APPS.AHL_RT_OPER_LABOR_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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