VIEW: APPS.WSM_INV_GENEALOGY_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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