View: WSM_INV_GENEALOGY_V

Product:	WSM - Shop Floor Management
Description:
Implementation/DBA Data:	APPS.WSM_INV_GENEALOGY_V

View Text

SELECT TRAN.TRANSACTION_ID
, TRAN.SUBINVENTORY_CODE
, TRAN.TRANSACTION_DATE
, TRAN.CREATED_BY
, ORG.ORGANIZATION_CODE
, HOU.NAME
, TRAN_TYPE.DESCRIPTION
, ACTION.MEANING
, SOURCE_TYPE.DESCRIPTION
, TRAN.LOCATOR_ID
, TRAN.ORGANIZATION_ID
FROM MTL_PARAMETERS ORG
, HR_ORGANIZATION_UNITS HOU
, MTL_TRANSACTION_TYPES TRAN_TYPE
, MFG_LOOKUPS ACTION
, MTL_TXN_SOURCE_TYPES SOURCE_TYPE
, MTL_MATERIAL_TRANSACTIONS TRAN
WHERE TRAN.ORGANIZATION_ID = ORG.ORGANIZATION_ID
AND ORG.ORGANIZATION_ID = HOU.ORGANIZATION_ID
AND TRAN.TRANSACTION_TYPE_ID = TRAN_TYPE.TRANSACTION_TYPE_ID
AND TRAN.TRANSACTION_ACTION_ID = ACTION.LOOKUP_CODE
AND ACTION.LOOKUP_TYPE = 'MTL_TRANSACTION_ACTION'
AND TRAN.TRANSACTION_SOURCE_TYPE_ID = SOURCE_TYPE.TRANSACTION_SOURCE_TYPE_ID

Columns