VIEW: APPS.JL_ZZ_AR_TX_LGM_V

Source

View Text - Preformatted

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)

View Text - HTML Formatted

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)