Deleting the Sourcing Rule Assignments API

 Query to fetch Mtl Material Transactions screen Query.

SELECT

    mmt.transaction_id,

    mmt.transaction_date,

    msi.segment1                         AS item,

    msi.description                      AS item_description,

    mtst.transaction_source_type_name     AS source_type,

    NVL(mgd.segment1,

        NVL(we.wip_entity_name,

            TO_CHAR(mmt.transaction_source_id))) AS source,

    mtt.transaction_type_name             AS transaction_type,

    mmt.primary_quantity,

    mmt.transaction_uom,

    mmt.subinventory_code,

    mmt.locator_id,

    mmt.revision,

    mmt.creation_date

FROM mtl_material_transactions mmt

     JOIN mtl_system_items_b msi

          ON mmt.inventory_item_id = msi.inventory_item_id

         AND mmt.organization_id   = msi.organization_id

     JOIN mtl_transaction_types mtt

          ON mmt.transaction_type_id = mtt.transaction_type_id

     JOIN mtl_txn_source_types mtst

          ON mmt.transaction_source_type_id = mtst.transaction_source_type_id

     LEFT JOIN mtl_generic_dispositions mgd

          ON mmt.transaction_source_id = mgd.disposition_id

     LEFT JOIN wip_entities we

          ON mmt.transaction_source_id = we.wip_entity_id

WHERE 1=1

ORDER BY mmt.transaction_date desc, mmt.transaction_id desc;