View: CST_WIP_TXN_TYPE_VIEW

Product:	BOM - Bills of Material
Description:	Types of WIP transactions : SINGLE-ORG view
Implementation/DBA Data:	APPS.CST_WIP_TXN_TYPE_VIEW

View Text

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'

Columns