VIEW: APPS.CST_WIP_TXN_TYPE_VIEW

Source

View Text - Preformatted

SELECT 'INV', transaction_type_id, transaction_type_name FROM mtl_transaction_types WHERE transaction_source_type_id = 5 UNION select 'WIP', lookup_code, meaning FROM MFG_LOOKUPS WHERE lookup_type = 'WIP_TRANSACTION_TYPE'

View Text - HTML Formatted

SELECT 'INV'
, TRANSACTION_TYPE_ID
, TRANSACTION_TYPE_NAME
FROM MTL_TRANSACTION_TYPES
WHERE TRANSACTION_SOURCE_TYPE_ID = 5 UNION SELECT 'WIP'
, LOOKUP_CODE
, MEANING
FROM MFG_LOOKUPS
WHERE LOOKUP_TYPE = 'WIP_TRANSACTION_TYPE'