VIEW: APPS.QPR_POLICIES_VL

Source

View Text - Preformatted

SELECT b.policy_id, tl.name, tl.description, b.active_flag, b.creation_date, b.created_by, b.last_update_date, b.last_updated_by, b.last_update_login FROM qpr_policies_b b, qpr_policies_tl tl WHERE b.policy_id = tl.policy_id AND tl.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.POLICY_ID
, TL.NAME
, TL.DESCRIPTION
, B.ACTIVE_FLAG
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
FROM QPR_POLICIES_B B
, QPR_POLICIES_TL TL
WHERE B.POLICY_ID = TL.POLICY_ID
AND TL.LANGUAGE = USERENV('LANG')