VIEW: APPS.HRI_OBI_CL_PTYP_WKTHLVL2_V

Source

View Text - Preformatted

SELECT lvl2.wkth_lvl2_sk_pk wtl2_wkthlvl2_pk ,hr_bis.bis_decode_lookup('HRI_CL_WKTH_LVL2',lvl2.wkth_lvl2_code) wtl2_wkthlvl2_name ,hr_bis.bis_decode_lookup('HRI_CL_WKTH_LVL2',lvl2.wkth_lvl2_code) wtl2_wkthlvl2_name_unq ,hr_bis.bis_decode_lookup('HRI_CL_WKTH_LVL2',lvl2.wkth_lvl2_code) wtl2_order_by ,hr_general.start_of_time wtl2_valid_from ,hr_general.end_of_time wtl2_valid_to ,lvl2.wkth_lvl1_sk_fk wtl1_wkthlvl1_fk FROM hri_cs_wkth_lvl2_ct lvl2 WITH READ ONLY

View Text - HTML Formatted

SELECT LVL2.WKTH_LVL2_SK_PK WTL2_WKTHLVL2_PK
, HR_BIS.BIS_DECODE_LOOKUP('HRI_CL_WKTH_LVL2'
, LVL2.WKTH_LVL2_CODE) WTL2_WKTHLVL2_NAME
, HR_BIS.BIS_DECODE_LOOKUP('HRI_CL_WKTH_LVL2'
, LVL2.WKTH_LVL2_CODE) WTL2_WKTHLVL2_NAME_UNQ
, HR_BIS.BIS_DECODE_LOOKUP('HRI_CL_WKTH_LVL2'
, LVL2.WKTH_LVL2_CODE) WTL2_ORDER_BY
, HR_GENERAL.START_OF_TIME WTL2_VALID_FROM
, HR_GENERAL.END_OF_TIME WTL2_VALID_TO
, LVL2.WKTH_LVL1_SK_FK WTL1_WKTHLVL1_FK
FROM HRI_CS_WKTH_LVL2_CT LVL2 WITH READ ONLY