VIEW: APPS.OPI_MFG_MTL_TRX_REASONS_LVL_V

Source

View Text - Preformatted

SELECT reason_id id, reason_name value, reason_type type FROM mtl_transaction_reasons UNION ALL SELECT To_number (fnd_lv.lookup_code) id, fnd_lv.meaning value, NULL type FROM fnd_lookups fnd_lv WHERE FND_LV.lookup_type = 'OPI_DBI_TRX_REASON_DIM' AND FND_LV.lookup_code = '-1'

View Text - HTML Formatted

SELECT REASON_ID ID
, REASON_NAME VALUE
, REASON_TYPE TYPE
FROM MTL_TRANSACTION_REASONS UNION ALL SELECT TO_NUMBER (FND_LV.LOOKUP_CODE) ID
, FND_LV.MEANING VALUE
, NULL TYPE
FROM FND_LOOKUPS FND_LV
WHERE FND_LV.LOOKUP_TYPE = 'OPI_DBI_TRX_REASON_DIM'
AND FND_LV.LOOKUP_CODE = '-1'