VIEW: APPS.QPR_DISCOUNT_GRPS_VL

Source

View Text - Preformatted

SELECT b.discount_grp_id, tl.name, tl.description, b.creation_date, b.created_by, b.last_update_date, b.last_updated_by, b.last_update_login, b.program_id, b.program_login_id, b.program_application_id, b.request_id FROM qpr_discount_grps_b b, qpr_discount_grps_tl tl WHERE b.discount_grp_id = tl.discount_grp_id AND tl.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.DISCOUNT_GRP_ID
, TL.NAME
, TL.DESCRIPTION
, B.CREATION_DATE
, B.CREATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_LOGIN
, B.PROGRAM_ID
, B.PROGRAM_LOGIN_ID
, B.PROGRAM_APPLICATION_ID
, B.REQUEST_ID
FROM QPR_DISCOUNT_GRPS_B B
, QPR_DISCOUNT_GRPS_TL TL
WHERE B.DISCOUNT_GRP_ID = TL.DISCOUNT_GRP_ID
AND TL.LANGUAGE = USERENV('LANG')