VIEW: APPS.QPR_TRANSF_HEADERS_VL

Source

View Text - Preformatted

SELECT b.TRANSF_HEADER_ID, tl.NAME, tl.DESCRIPTION, b.TRANSF_GROUP_ID, b.FROM_DIM_MEAS_CODE, b.FROM_DIM_HIER_CODE, b.LIMIT_DIM_FLAG, b.FROM_LEVEL_ID, b.MEAS_CODE, b.TO_DIM_CODE, b.TO_LEVEL_ID, b.TO_VALUE, b.TO_VALUE_DESC, b.CREATED_BY, b.CREATION_DATE, b.LAST_UPDATED_BY, b.LAST_UPDATE_DATE, b.LAST_UPDATE_LOGIN from qpr_transf_headers_b b, qpr_transf_headers_tl tl WHERE b.transf_header_id=tl.transf_header_id and tl.language=userenv('LANG')

View Text - HTML Formatted

SELECT B.TRANSF_HEADER_ID
, TL.NAME
, TL.DESCRIPTION
, B.TRANSF_GROUP_ID
, B.FROM_DIM_MEAS_CODE
, B.FROM_DIM_HIER_CODE
, B.LIMIT_DIM_FLAG
, B.FROM_LEVEL_ID
, B.MEAS_CODE
, B.TO_DIM_CODE
, B.TO_LEVEL_ID
, B.TO_VALUE
, B.TO_VALUE_DESC
, B.CREATED_BY
, B.CREATION_DATE
, B.LAST_UPDATED_BY
, B.LAST_UPDATE_DATE
, B.LAST_UPDATE_LOGIN
FROM QPR_TRANSF_HEADERS_B B
, QPR_TRANSF_HEADERS_TL TL
WHERE B.TRANSF_HEADER_ID=TL.TRANSF_HEADER_ID
AND TL.LANGUAGE=USERENV('LANG')