VIEW: APPS.OPI_WMS_TASK_EXC_REASONS_LVL_V

Source

View Text - Preformatted

SELECT reason_id id, reason_name value from mtl_transaction_reasons WHERE reason_type in (select lookup_code from fnd_lookup_values where lookup_type = 'WMS_REASON_TYPES' and language = userenv('LANG') and view_application_id = 700 and security_group_id = fnd_global.lookup_security_group(lookup_type, view_application_id))

View Text - HTML Formatted

SELECT REASON_ID ID
, REASON_NAME VALUE
FROM MTL_TRANSACTION_REASONS
WHERE REASON_TYPE IN (SELECT LOOKUP_CODE
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = 'WMS_REASON_TYPES'
AND LANGUAGE = USERENV('LANG')
AND VIEW_APPLICATION_ID = 700
AND SECURITY_GROUP_ID = FND_GLOBAL.LOOKUP_SECURITY_GROUP(LOOKUP_TYPE
, VIEW_APPLICATION_ID))