[Home] [Help]
View: OKL_FNCTN_PRMTRS_UV
View Text
SELECT FPRB.ID ID
, FPRB.DSF_ID DSF_ID
, FPRB.PMR_ID PMR_ID
, FPRB.SEQUENCE_NUMBER SEQUENCE_NUMBER
, PMRB.NAME NAME
, PMRB.DATATYPE DATATYPE
, FPRT.INSTRUCTIONS INSTRUCTIONS
, FPRT.VALUE VALUE
FROM OKL_PARAMETERS_B PMRB
, OKL_PARAMETERS_TL PMRT
, OKL_FNCTN_PRMTRS_B FPRB
, OKL_FNCTN_PRMTRS_TL FPRT
WHERE FPRB.PMR_ID = PMRB.ID
AND PMRB.ID = PMRT.ID
AND PMRT.LANGUAGE = USERENV('LANG')
AND FPRB.ID = FPRT.ID
AND FPRT.LANGUAGE = USERENV('LANG')
Columns
Name |
ID |
DSF_ID |
PMR_ID |
SEQUENCE_NUMBER |
NAME |
DATATYPE |
INSTRUCTIONS |
VALUE |