DBA Data[Home] [Help]

VIEW: APPS.EDR_PSIG_SIGN_PARAMS_VL

Source

View Text - Preformatted

SELECT B.ROWID ROW_ID, B.PARAMETER_ID, B.SIGNATURE_ID, B.NAME, B.VALUE, T.DISPLAY_NAME from EDR_PSIG_SIGN_PARAMS_TL T, EDR_PSIG_SIGN_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.SIGNATURE_ID
, B.NAME
, B.VALUE
, T.DISPLAY_NAME
FROM EDR_PSIG_SIGN_PARAMS_TL T
, EDR_PSIG_SIGN_PARAMS_B B
WHERE B.PARAMETER_ID = T.PARAMETER_ID
AND T.LANGUAGE = USERENV('LANG')