Wip Completion (intellinum/Telnet) Query to Fetch Work Order, Lot and LPN Numbers Details

 SELECT

    we.wip_entity_name,

    wlc.organization_id,

    wlc.wip_entity_id,

    wlc.inventory_item_id,

    msik.concatenated_segments item,

    mmt.transaction_id,

    mmt.transaction_quantity,

    mmt.transaction_date,

    lpn.attribute4 lot_number,

    lpn.license_plate_number

FROM

    wip_lpn_completions       wlc,

    wip_entities              we,

    mtl_material_transactions mmt,

    mtl_transaction_lot_numbers lot,

    wms_license_plate_numbers lpn,

    mtl_system_items_kfv      msik

WHERE

        we.wip_entity_id = wlc.wip_entity_id

    AND we.organization_id = wlc.organization_id

    AND mmt.completion_transaction_id = wlc.completion_transaction_id

    AND lot.transaction_id = mmt.transaction_id

    AND lpn.lpn_id = wlc.lpn_id

    AND msik.inventory_item_id = wlc.inventory_item_id

    AND msik.organization_id = wlc.organization_id

--    AND we.wip_entity_name = '129465'--'129502'

    AND we.organization_id IN (91, 93)

    AND msik.item_type = 'FG'

ORDER BY

    mmt.transaction_date DESC;