VIEW: APPS.HRBV_PHONE

Source

View Text - Preformatted

SELECT hr_bis.bis_decode_lookup('PHONE_TYPE',phn.phone_type) phone_type ,phn.date_from date_from ,phn.date_to date_to ,phn.phone_number phone_number ,phn.parent_table parent_table ,phn.validity validity ,'_DF:PER:PER_PHONES:phn' ,phn.phone_type phone_type_code ,phn.phone_id phone_id ,phn.party_id party_id ,phn.parent_id parent_id ,phn.last_update_date last_update_date ,phn.last_updated_by last_updated_by ,phn.last_update_login last_update_login ,phn.created_by created_by ,phn.creation_date creation_date FROM per_phones phn

View Text - HTML Formatted

SELECT HR_BIS.BIS_DECODE_LOOKUP('PHONE_TYPE'
, PHN.PHONE_TYPE) PHONE_TYPE
, PHN.DATE_FROM DATE_FROM
, PHN.DATE_TO DATE_TO
, PHN.PHONE_NUMBER PHONE_NUMBER
, PHN.PARENT_TABLE PARENT_TABLE
, PHN.VALIDITY VALIDITY
, '_DF:PER:PER_PHONES:PHN'
, PHN.PHONE_TYPE PHONE_TYPE_CODE
, PHN.PHONE_ID PHONE_ID
, PHN.PARTY_ID PARTY_ID
, PHN.PARENT_ID PARENT_ID
, PHN.LAST_UPDATE_DATE LAST_UPDATE_DATE
, PHN.LAST_UPDATED_BY LAST_UPDATED_BY
, PHN.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, PHN.CREATED_BY CREATED_BY
, PHN.CREATION_DATE CREATION_DATE
FROM PER_PHONES PHN