eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

VIEW: APPS.MTL_INV_TXNS_MFG_LOTS_V

Source

View Text - Preformatted


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

View Text - HTML Formatted

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