Product: | PA - Projects |
---|---|
Description: | 10SC Only |
Implementation/DBA Data: | APPS.PA_PERF_THRESHOLDS_V |
SELECT TH.THRESHOLD_ID
, TH.RULE_TYPE
, TH.THRES_OBJ_ID
, TH.FROM_VALUE
, TH.TO_VALUE
, TH.INDICATOR_CODE
, IND.MEANING
, TH.EXCEPTION_FLAG
, TH.WEIGHTING
, TH.ACCESS_LIST_ID
, TH.RECORD_VERSION_NUMBER
, TH.CREATION_DATE
, TH.CREATED_BY
, TH.LAST_UPDATE_DATE
, TH.LAST_UPDATED_BY
, TH.LAST_UPDATE_LOGIN
FROM PA_PERF_THRESHOLDS TH
, PA_LOOKUPS IND
WHERE IND.LOOKUP_TYPE = 'PA_PERF_INDICATORS'
AND IND.LOOKUP_CODE = TH.INDICATOR_CODE