View: INVBV_SERIAL_NUMBER_TXNS

Product:	INV - Inventory
Description:	- Retrofitted
Implementation/DBA Data:	APPS.INVBV_SERIAL_NUMBER_TXNS

View Text

SELECT MLN.TRANSACTION_ID
, MLN.SERIAL_TRANSACTION_ID
, MUT.SERIAL_NUMBER
, MUT.INVENTORY_ITEM_ID
, MLN.LOT_NUMBER
, MUT.ORGANIZATION_ID
, MUT.SUBINVENTORY_CODE
, MUT.LOCATOR_ID
, MUT.TRANSACTION_DATE
, MUT.TRANSACTION_SOURCE_ID
, MUT.TRANSACTION_SOURCE_TYPE_ID
, MUT.TRANSACTION_SOURCE_NAME
, MUT.RECEIPT_ISSUE_TYPE
, MUT.CREATED_BY
, MUT.CREATION_DATE
, MUT.LAST_UPDATED_BY
, MUT.LAST_UPDATE_DATE
FROM MTL_TRANSACTION_LOT_NUMBERS MLN
, MTL_UNIT_TRANSACTIONS MUT WHERE MLN.SERIAL_TRANSACTION_ID = MUT.TRANSACTION_ID
AND '_SEC:MUT.ORGANIZATION_ID' IS NOT NULL UNION ALL /*-- IF THE ITEM IS NOT UNDER LOT CONTROL THEN JOIN TO MTL_MATERIAL_TRANSACTIONS DIRECTLY AS THE MTL_UNIT_TRANSACTIONS.TRANSACTION_ID IS ACTUALLY = MTL_MATERIAL_TRANSACTIONS.TRANSACTION_ID*/ SELECT MMT.TRANSACTION_ID
, TO_NUMBER(NULL)
, MUT.SERIAL_NUMBER
, MUT.INVENTORY_ITEM_ID
, NULL
, MUT.ORGANIZATION_ID
, MUT.SUBINVENTORY_CODE
, MUT.LOCATOR_ID
, MUT.TRANSACTION_DATE
, MUT.TRANSACTION_SOURCE_ID
, MUT.TRANSACTION_SOURCE_TYPE_ID
, MUT.TRANSACTION_SOURCE_NAME
, MUT.RECEIPT_ISSUE_TYPE
, MUT.CREATED_BY
, MUT.CREATION_DATE
, MUT.LAST_UPDATED_BY
, MUT.LAST_UPDATE_DATE
FROM MTL_MATERIAL_TRANSACTIONS MMT
, MTL_UNIT_TRANSACTIONS MUT WHERE MMT.TRANSACTION_ID = MUT.TRANSACTION_ID
AND '_SEC:MUT.ORGANIZATION_ID' IS NOT NULL
AND MMT.ORGANIZATION_ID = NVL (MMT.OWNING_ORGANIZATION_ID
, MMT.ORGANIZATION_ID)
AND NVL (MMT.OWNING_TP_TYPE
, 2) = 2
AND NVL (MMT.LOGICAL_TRANSACTION
, -99) <> 1 WITH READ ONLY

Columns