VIEW: APPS.QPR_TRANSF_GROUPS_VL

Source

View Text - Preformatted

SELECT b.TRANSF_GROUP_ID, b.TRANSF_TYPE_CODE, tl.NAME, tl.DESCRIPTION, b.CREATION_DATE, b.CREATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_LOGIN from qpr_transf_groups_b b, qpr_transf_groups_tl tl WHERE b.transf_group_id=tl.transf_group_id and tl.language=userenv('LANG')

View Text - HTML Formatted

SELECT B.TRANSF_GROUP_ID
, B.TRANSF_TYPE_CODE
, TL.NAME
, TL.DESCRIPTION
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
FROM QPR_TRANSF_GROUPS_B B
, QPR_TRANSF_GROUPS_TL TL
WHERE B.TRANSF_GROUP_ID=TL.TRANSF_GROUP_ID
AND TL.LANGUAGE=USERENV('LANG')