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_PENDING_TXNS_MFG_LOTS_V

Source

View Text - Preformatted


SELECT we.gen_object_id object_id , 5 object_type , mmtt.transaction_temp_id transaction_id , mmtt.transaction_date transaction_date , mp.organization_code organization_code , mmtt.organization_id organization_id , mmtt.subinventory_code subinventory_code , mmtt.locator_id locator_id , mtst.transaction_source_type_name transaction_source_name , DECODE(mmtt.transaction_source_type_id ,13 ,mmtt.transaction_source_name , Inv_Object_Genealogy.getSource(mmtt.organization_id , mmtt.transaction_source_type_id , mmtt.transaction_source_id) ) transaction_source , null trading_partner , null project , null task , decode(mtlt.transaction_quantity ,null ,mmtt.transaction_quantity ,mtlt.transaction_quantity) transaction_quantity , mmtt.transaction_uom , decode(mtlt.primary_quantity ,null ,mmtt.primary_quantity ,mtlt.primary_quantity) primary_quantity , decode(mtlt.secondary_quantity ,null ,mmtt.secondary_transaction_quantity ,mtlt.secondary_quantity) secondary_quantity , mtlt.grade_code grade_code , mmtt.created_by , mmtt.source_code , mmtt.source_line_id , mmtt.transaction_type_id , wlpn1.lpn_id , wlpn2.lpn_id transfer_lpn_id , wlpn3.lpn_id content_lpn_id , wlpn1.license_plate_number lpn_number , wlpn2.license_plate_number transfer_lpn_number , wlpn3.license_plate_number content_lpn_number , mmtt.source_lot_number supplier_lot_number , mtlt.lot_number transaction_lot_number , mmtt.transaction_status transaction_status FROM wip_entities we , mtl_transaction_lots_temp mtlt , mtl_material_transactions_temp mmtt , mtl_txn_source_types mtst , mtl_parameters mp , wms_license_plate_numbers wlpn1 , wms_license_plate_numbers wlpn2 , wms_license_plate_numbers wlpn3 WHERE mmtt.transaction_source_id=we.wip_entity_id AND mmtt.transaction_source_type_id = mtst.transaction_source_type_id AND mtlt.transaction_temp_id (+) = mmtt.transaction_temp_id AND mmtt.transaction_source_type_id = mtst.transaction_source_type_id AND we.entity_type in (9,10) AND mmtt.organization_id = mp.organization_id AND wlpn1.lpn_id(+) = mmtt.lpn_id AND wlpn2.lpn_id(+) = mmtt.transfer_lpn_id AND wlpn3.lpn_id(+) = mmtt.content_lpn_id

View Text - HTML Formatted

SELECT WE.GEN_OBJECT_ID OBJECT_ID
, 5 OBJECT_TYPE
, MMTT.TRANSACTION_TEMP_ID TRANSACTION_ID
, MMTT.TRANSACTION_DATE TRANSACTION_DATE
, MP.ORGANIZATION_CODE ORGANIZATION_CODE
, MMTT.ORGANIZATION_ID ORGANIZATION_ID
, MMTT.SUBINVENTORY_CODE SUBINVENTORY_CODE
, MMTT.LOCATOR_ID LOCATOR_ID
, MTST.TRANSACTION_SOURCE_TYPE_NAME TRANSACTION_SOURCE_NAME
, DECODE(MMTT.TRANSACTION_SOURCE_TYPE_ID
, 13
, MMTT.TRANSACTION_SOURCE_NAME
, INV_OBJECT_GENEALOGY.GETSOURCE(MMTT.ORGANIZATION_ID
, MMTT.TRANSACTION_SOURCE_TYPE_ID
, MMTT.TRANSACTION_SOURCE_ID) ) TRANSACTION_SOURCE
, NULL TRADING_PARTNER
, NULL PROJECT
, NULL TASK
, DECODE(MTLT.TRANSACTION_QUANTITY
, NULL
, MMTT.TRANSACTION_QUANTITY
, MTLT.TRANSACTION_QUANTITY) TRANSACTION_QUANTITY
, MMTT.TRANSACTION_UOM
, DECODE(MTLT.PRIMARY_QUANTITY
, NULL
, MMTT.PRIMARY_QUANTITY
, MTLT.PRIMARY_QUANTITY) PRIMARY_QUANTITY
, DECODE(MTLT.SECONDARY_QUANTITY
, NULL
, MMTT.SECONDARY_TRANSACTION_QUANTITY
, MTLT.SECONDARY_QUANTITY) SECONDARY_QUANTITY
, MTLT.GRADE_CODE GRADE_CODE
, MMTT.CREATED_BY
, MMTT.SOURCE_CODE
, MMTT.SOURCE_LINE_ID
, MMTT.TRANSACTION_TYPE_ID
, WLPN1.LPN_ID
, WLPN2.LPN_ID TRANSFER_LPN_ID
, WLPN3.LPN_ID CONTENT_LPN_ID
, WLPN1.LICENSE_PLATE_NUMBER LPN_NUMBER
, WLPN2.LICENSE_PLATE_NUMBER TRANSFER_LPN_NUMBER
, WLPN3.LICENSE_PLATE_NUMBER CONTENT_LPN_NUMBER
, MMTT.SOURCE_LOT_NUMBER SUPPLIER_LOT_NUMBER
, MTLT.LOT_NUMBER TRANSACTION_LOT_NUMBER
, MMTT.TRANSACTION_STATUS TRANSACTION_STATUS
FROM WIP_ENTITIES WE
, MTL_TRANSACTION_LOTS_TEMP MTLT
, MTL_MATERIAL_TRANSACTIONS_TEMP MMTT
, MTL_TXN_SOURCE_TYPES MTST
, MTL_PARAMETERS MP
, WMS_LICENSE_PLATE_NUMBERS WLPN1
, WMS_LICENSE_PLATE_NUMBERS WLPN2
, WMS_LICENSE_PLATE_NUMBERS WLPN3
WHERE MMTT.TRANSACTION_SOURCE_ID=WE.WIP_ENTITY_ID
AND MMTT.TRANSACTION_SOURCE_TYPE_ID = MTST.TRANSACTION_SOURCE_TYPE_ID
AND MTLT.TRANSACTION_TEMP_ID (+) = MMTT.TRANSACTION_TEMP_ID
AND MMTT.TRANSACTION_SOURCE_TYPE_ID = MTST.TRANSACTION_SOURCE_TYPE_ID
AND WE.ENTITY_TYPE IN (9
, 10)
AND MMTT.ORGANIZATION_ID = MP.ORGANIZATION_ID
AND WLPN1.LPN_ID(+) = MMTT.LPN_ID
AND WLPN2.LPN_ID(+) = MMTT.TRANSFER_LPN_ID
AND WLPN3.LPN_ID(+) = MMTT.CONTENT_LPN_ID