Oracle EBS - SQL Query to Get Material Transaction Open Interface Errored Transaction Details

Subject: SQL Query to Get Material Transaction Open Interface Errored Transaction Details

SQL Query:

SELECT 

    mtiv.transaction_interface_id,

    mtiv.transaction_type_name,

    msib.segment1                 item,

    mtiv.item_description,

    mtiv.primary_quantity         qty,

    mtiv.organization_code        org,

    milk.concatenated_segments    location,

    mtiv.creation_date,

    mtiv.last_update_date,

    mtiv.error_explanation,

    mtiv.error_code

FROM

    apps.mtl_transactions_interface_v    mtiv,

    apps.mtl_system_items_b              msib,

    apps.mtl_item_locations_kfv          milk

WHERE

        msib.inventory_item_id = mtiv.inventory_item_id

    AND msib.organization_id = mtiv.organization_id

    AND mtiv.locator_id = milk.inventory_location_id

    AND mtiv.organization_id = milk.organization_id

    AND msib.organization_id = (

        SELECT

            organization_id

        FROM

            apps.mtl_parameters

        WHERE

            organization_code = 'CCI' --Need to Enter Organization Code 

    );