Product: | JL - Latin America Localizations |
---|---|
Description: | |
Implementation/DBA Data: | APPS.JL_ZZ_AR_TX_LGM_V |
SELECT M.ROWID ROW_ID
, M.RULE_ID RULE_ID
, M.RULE_DATA_ID RULE_DATA_ID
, M.EXCEPTION_CODE EXCEPTION_CODE
, SUBSTR(JL_ZZ_AR_TX_LIB_PKG.GET_LOOKUP_MEANING(M.EXCEPTION_CODE
, 'JLZZ_AR_TX_LEGAL_MESSAGE')
, 1
, 80) EXCEPTION_DESC
, M.INVENTORY_ORGANIZATION_ID INVENTORY_ORGANIZATION_ID
, M.INVENTORY_ITEM_FLAG INVENTORY_ITEM_FLAG
, ST.STANDARD_TEXT_ID MESSAGE_ID
, ST.NAME NAME
, ST.TEXT TEXT
, M.ORG_ID ORG_ID
, M.LAST_UPDATED_BY LAST_UPDATED_BY
, M.LAST_UPDATE_DATE LAST_UPDATE_DATE
, M.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, M.CREATION_DATE CREATION_DATE
, M.CREATED_BY CREATED_BY
FROM JL_ZZ_AR_TX_LGL_MSG M
, AR_STANDARD_TEXT_VL ST
, AR_SYSTEM_PARAMETERS_ALL SYS
WHERE M.MESSAGE_ID = ST.STANDARD_TEXT_ID
AND NVL(M.ORG_ID
, -99) = NVL(SYS.ORG_ID
, -99)