VIEW: APPS.PSP_AUTO_PARAMS_V

Source

View Text - Preformatted

SELECT a.rowid ROW_ID, a.acct_id, a.param_line_num, a.lookup_id, b.parameter_class, b.parameter, b.datatype, b.validation_type, a.operand, a.user_value, a.last_update_date, a.last_updated_by, a.last_update_login, a.created_by, a.creation_date FROM psp_auto_params a, psp_auto_lookups b WHERE a.lookup_id = b.lookup_id

View Text - HTML Formatted

SELECT A.ROWID ROW_ID
, A.ACCT_ID
, A.PARAM_LINE_NUM
, A.LOOKUP_ID
, B.PARAMETER_CLASS
, B.PARAMETER
, B.DATATYPE
, B.VALIDATION_TYPE
, A.OPERAND
, A.USER_VALUE
, A.LAST_UPDATE_DATE
, A.LAST_UPDATED_BY
, A.LAST_UPDATE_LOGIN
, A.CREATED_BY
, A.CREATION_DATE
FROM PSP_AUTO_PARAMS A
, PSP_AUTO_LOOKUPS B
WHERE A.LOOKUP_ID = B.LOOKUP_ID