You can use EBS build in function to get lookup code meaning
ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING(’LOOKUP_TYPE’, LOOKUP_CODE)
Example:
SELECT
CR.CREDIT_REQUEST_ID,
CR.CREATION_DATE,
CR.APPLICATION_NUMBER,
ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_CMGT_REVIEW_TYPE', CR.REVIEW_TYPE) typ_wniosku,
ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_CMGT_APPLICATION_STATUS', CR.STATUS) XX_STATUS_WNIOSKU,
FROM AR_CMGT_CREDIT_REQUESTS CR |
SELECT
CR.CREDIT_REQUEST_ID,
CR.CREATION_DATE,
CR.APPLICATION_NUMBER,
ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_CMGT_REVIEW_TYPE', CR.REVIEW_TYPE) typ_wniosku,
ARPT_SQL_FUNC_UTIL.GET_LOOKUP_MEANING ('AR_CMGT_APPLICATION_STATUS', CR.STATUS) XX_STATUS_WNIOSKU,
FROM AR_CMGT_CREDIT_REQUESTS CR
Ten wpis został opublikowany w kategorii
_EBS - ogólnie,
PLSQL i oznaczony tagami
get lookup,
lookup,
plsql. Dodaj zakładkę do
bezpośredniego odnośnika.