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.

VIEW: APPS.HRI_OBI_CS_PTYP_PERTYP_V

Source

View Text - Preformatted


SELECT prsntyp_sk_pk ptyp_pertyp_pk ,wkth_wktyp_sk_fk ptyp_wktyp_sk_fk ,wkth_lvl1_sk_fk ptyp_wkthlvl1_fk ,wkth_lvl2_sk_fk ptyp_wkthlvl2_fk ,wkth_wktyp_code ptyp_wktyp_code ,wkth_lvl1_code ptyp_lvl1_code ,wkth_lvl2_code ptyp_lvl2_code ,person_type_id ptyp_person_type_id ,primary_flag_code ptyp_primary_flag_code ,assignment_type_code ptyp_assgn_type_code ,employment_category_code ptyp_emp_cat_code ,include_flag_code ptyp_include_flag_code FROM hri_cs_prsntyp_ct WITH READ ONLY

View Text - HTML Formatted

SELECT PRSNTYP_SK_PK PTYP_PERTYP_PK
, WKTH_WKTYP_SK_FK PTYP_WKTYP_SK_FK
, WKTH_LVL1_SK_FK PTYP_WKTHLVL1_FK
, WKTH_LVL2_SK_FK PTYP_WKTHLVL2_FK
, WKTH_WKTYP_CODE PTYP_WKTYP_CODE
, WKTH_LVL1_CODE PTYP_LVL1_CODE
, WKTH_LVL2_CODE PTYP_LVL2_CODE
, PERSON_TYPE_ID PTYP_PERSON_TYPE_ID
, PRIMARY_FLAG_CODE PTYP_PRIMARY_FLAG_CODE
, ASSIGNMENT_TYPE_CODE PTYP_ASSGN_TYPE_CODE
, EMPLOYMENT_CATEGORY_CODE PTYP_EMP_CAT_CODE
, INCLUDE_FLAG_CODE PTYP_INCLUDE_FLAG_CODE
FROM HRI_CS_PRSNTYP_CT WITH READ ONLY