[Home] [Help]
View: FA_RX_REP_PARAMETERS_V
View Text
SELECT RX.ROWID ROW_ID
, RX.PARAMETER_COUNTER
, RX.REPORT_ID
, RX.LOV_ID
, RX.COLUMN_NAME
, RX.NAME
, RX.MAX_LENGTH
, RX.DATATYPE
, RX.REQUIRED
, LV.LOV_NAME PARAMETER_LOV
, RX.LAST_UPDATE_DATE
, RX.LAST_UPDATE_LOGIN
, RX.LAST_UPDATED_BY
, RX.CREATION_DATE
, RX.CREATED_BY
, RELATIONAL_OP
FROM FA_RX_REP_PARAMETERS RX
, FA_RX_LOV LV
WHERE RX.LOV_ID = LV.LOV_ID(+)
Columns
| Name |
| ROW_ID |
| PARAMETER_COUNTER |
| REPORT_ID |
| LOV_ID |
| COLUMN_NAME |
| NAME |
| MAX_LENGTH |
| DATATYPE |
| REQUIRED |
| PARAMETER_LOV |
| LAST_UPDATE_DATE |
| LAST_UPDATE_LOGIN |
| LAST_UPDATED_BY |
| CREATION_DATE |
| CREATED_BY |
| RELATIONAL_OP |
APPS.FA_RX_REP_PARAMETERS_V