View: MTL_INV_TXNS_MFG_LOTS_V

Product:	INV - Inventory
Description:	This view contains information about all completes WIP transactions with type as 'Firm planned order' & 'Process batch'
Implementation/DBA Data:	APPS.MTL_INV_TXNS_MFG_LOTS_V

View Text

SELECT WE.GEN_OBJECT_ID
, 5
, MMT.TRANSACTION_ID
, MMT.TRANSACTION_DATE
, MP.ORGANIZATION_CODE
, MMT.ORGANIZATION_ID
, MMT.SUBINVENTORY_CODE
, MMT.LOCATOR_ID
, MTST.TRANSACTION_SOURCE_TYPE_NAME
, DECODE(MMT.TRANSACTION_SOURCE_TYPE_ID
, 13
, MMT.TRANSACTION_SOURCE_NAME
, INV_OBJECT_GENEALOGY.GETSOURCE(MMT.ORGANIZATION_ID
, MMT.TRANSACTION_SOURCE_TYPE_ID
, MMT.TRANSACTION_SOURCE_ID) )
, NULL
, NULL
, NULL
, MTLN.TRANSACTION_QUANTITY
, MMT.TRANSACTION_UOM
, MTLN.PRIMARY_QUANTITY
, MTLN.SECONDARY_TRANSACTION_QUANTITY
, MTLN.GRADE_CODE
, MMT.CREATED_BY
, MMT.SOURCE_CODE
, MMT.SOURCE_LINE_ID
, MMT.TRANSACTION_TYPE_ID
, WLPN1.LPN_ID
, WLPN2.LPN_ID
, WLPN3.LPN_ID
, WLPN1.LICENSE_PLATE_NUMBER
, WLPN2.LICENSE_PLATE_NUMBER
, WLPN3.LICENSE_PLATE_NUMBER
, MMT.ORIGINAL_TRANSACTION_TEMP_ID
, MMT.VENDOR_LOT_NUMBER
, MTLN.LOT_NUMBER
FROM WIP_ENTITIES WE
, MTL_TRANSACTION_LOT_NUMBERS MTLN
, MTL_MATERIAL_TRANSACTIONS MMT
, MTL_TXN_SOURCE_TYPES MTST
, MTL_PARAMETERS MP
, WMS_LICENSE_PLATE_NUMBERS WLPN1
, WMS_LICENSE_PLATE_NUMBERS WLPN2
, WMS_LICENSE_PLATE_NUMBERS WLPN3
WHERE MMT.TRANSACTION_SOURCE_ID=WE.WIP_ENTITY_ID
AND MMT.TRANSACTION_SOURCE_TYPE_ID = MTST.TRANSACTION_SOURCE_TYPE_ID
AND MTLN.TRANSACTION_ID = MMT.TRANSACTION_ID
AND MMT.TRANSACTION_SOURCE_TYPE_ID = MTST.TRANSACTION_SOURCE_TYPE_ID
AND MMT.TRANSACTION_ACTION_ID IN (1
, 27
, 30
, 31
, 32
, 33
, 34 )
AND MMT.TRANSACTION_SOURCE_TYPE_ID = 5
AND WE.ENTITY_TYPE IN (9
, 10)
AND MMT.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND WLPN1.LPN_ID(+) = MMT.LPN_ID
AND WLPN2.LPN_ID(+) = MMT.TRANSFER_LPN_ID
AND WLPN3.LPN_ID(+) = MMT.CONTENT_LPN_ID

Columns