VIEW: APPS.EDR_PSIG_DOC_PARAMS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.PARAMETER_ID, B.DOCUMENT_ID, B.NAME, B.VALUE, T.DISPLAY_NAME from EDR_PSIG_DOC_PARAMS_TL T, EDR_PSIG_DOC_PARAMS_B B WHERE B.PARAMETER_ID = T.PARAMETER_ID and T.LANGUAGE = userenv('LANG')

View Text - HTML Formatted

SELECT B.ROWID ROW_ID
, B.PARAMETER_ID
, B.DOCUMENT_ID
, B.NAME
, B.VALUE
, T.DISPLAY_NAME
FROM EDR_PSIG_DOC_PARAMS_TL T
, EDR_PSIG_DOC_PARAMS_B B
WHERE B.PARAMETER_ID = T.PARAMETER_ID
AND T.LANGUAGE = USERENV('LANG')