VIEW: APPS.HRI_OBI_CL_PTYP_WKTHLVL1_V

Source

View Text - Preformatted

SELECT lvl1.wkth_lvl1_sk_pk wtl1_wkthlvl1_pk ,hr_bis.bis_decode_lookup('HRI_CL_WKTH_LVL1',lvl1.wkth_lvl1_code) wtl1_wkthlvl1_name ,hr_bis.bis_decode_lookup('HRI_CL_WKTH_LVL1',lvl1.wkth_lvl1_code) wtl1_wkthlvl1_name_unq ,hr_bis.bis_decode_lookup('HRI_CL_WKTH_LVL1',lvl1.wkth_lvl1_code) wtl1_order_by ,hr_general.start_of_time wtl1_valid_from ,hr_general.end_of_time wtl1_valid_to ,lvl1.wkth_wktyp_sk_fk wtyp_wrktyp_fk FROM hri_cs_wkth_lvl1_ct lvl1 WITH READ ONLY

View Text - HTML Formatted

SELECT LVL1.WKTH_LVL1_SK_PK WTL1_WKTHLVL1_PK
, HR_BIS.BIS_DECODE_LOOKUP('HRI_CL_WKTH_LVL1'
, LVL1.WKTH_LVL1_CODE) WTL1_WKTHLVL1_NAME
, HR_BIS.BIS_DECODE_LOOKUP('HRI_CL_WKTH_LVL1'
, LVL1.WKTH_LVL1_CODE) WTL1_WKTHLVL1_NAME_UNQ
, HR_BIS.BIS_DECODE_LOOKUP('HRI_CL_WKTH_LVL1'
, LVL1.WKTH_LVL1_CODE) WTL1_ORDER_BY
, HR_GENERAL.START_OF_TIME WTL1_VALID_FROM
, HR_GENERAL.END_OF_TIME WTL1_VALID_TO
, LVL1.WKTH_WKTYP_SK_FK WTYP_WRKTYP_FK
FROM HRI_CS_WKTH_LVL1_CT LVL1 WITH READ ONLY