Inventory Transactions not Costed in PA (Oracle Projects)

SELECT DISTINCT 'WIP' trx_type, pa.segment1 project_number, mtl.transaction_id, mtl.transaction_quantity, mtl.inventory_item_id,
                          b.concatenated_segments, ood.organization_name, mtl.pm_cost_collector_group_id, mtl.pm_cost_collected
                     FROM wip_entities wp, mtl_material_transactions mtl, pa_projects_all pa, mtl_system_items_kfv b, org_organization_definitions ood
                    WHERE 1 = 1
                      AND wp.wip_entity_id = mtl.transaction_source_id
                      AND mtl.transaction_source_type_id =
                                   5
                                    -- WIP or Schedule                                                                                        -- WIP or Schedule
                      AND mtl.source_project_id = pa.project_id
                      AND pa.org_id = 1090        --entity IT                      
                      AND mtl.inventory_item_id = b.inventory_item_id
                      AND mtl.organization_id = b.organization_id
                      AND mtl.organization_id = ood.organization_id
                      AND mtl.pm_cost_collected IS NULL
                      AND mtl.pm_cost_collector_group_id IS NOT NULL
                      AND mtl.transaction_type_id IN
                              (43, 48, 35) --43.WIP Component Return,48.WIP Neg Comp Return,35.WIP component issue,17.WIP Assembly Return,44.WIP Assy Completion
                      AND NOT EXISTS (SELECT 1
                                        FROM pa_transaction_interface_all pti
                                       WHERE pti.project_number = pa.segment1 AND pti.orig_transaction_reference = mtl.transaction_id AND pti.org_id = pa.org_id)
                      AND NOT EXISTS (
                             SELECT 1
                               FROM pa_expenditure_items_all pa1
                              WHERE 1 = 1
                                AND pa1.project_id = mtl.source_project_id
                                AND pa1.inventory_item_id = mtl.inventory_item_id
                                AND pa1.cc_prvdr_organization_id = mtl.organization_id
                                AND pa1.org_id = pa.org_id
                                AND pa1.orig_transaction_reference = TO_CHAR (mtl.transaction_id)
                                                                                                 --AND pa1.system_linkage_function IN ('WIP', 'BTC', 'INV')
                          )
          UNION ALL
          SELECT DISTINCT 'Project Transfer' trx_type, pa.segment1 project_number, mmt.transaction_id, mmt.transaction_quantity, mmt.inventory_item_id,
                          b.concatenated_segments, ood.organization_name, mmt.pm_cost_collector_group_id, mmt.pm_cost_collected
                     FROM org_organization_definitions ood, mtl_material_transactions mmt, pa_projects_all pa, mtl_system_items_kfv b
                    WHERE 1 = 1
                      AND mmt.transaction_source_type_id = 13
                      AND mmt.inventory_item_id = b.inventory_item_id
                      AND mmt.organization_id = b.organization_id
                      AND pa.org_id = :p_org_id      
                      AND mmt.organization_id = ood.organization_id
                      AND mmt.project_id = pa.project_id
                      AND mmt.transaction_type_id =
                             67
                             --Project Transfer                                                                                               --project transfer
                      AND mmt.pm_cost_collected IS NULL
                      AND mmt.pm_cost_collector_group_id IS NOT NULL
                      AND NOT EXISTS (
                              SELECT 1
                                FROM pa_transaction_interface_all pti
                               WHERE pti.project_number = pa.segment1 AND pti.orig_transaction_reference = TO_CHAR (mmt.transaction_id)
                                     AND pti.org_id = pa.org_id)
                      AND NOT EXISTS (
                             SELECT 1
                               FROM pa_expenditure_items_all pa1
                              WHERE 1 = 1
                                AND pa1.project_id = mmt.project_id
                                AND pa1.org_id = pa.org_id
                                AND pa1.orig_transaction_reference = TO_CHAR (mmt.transaction_id)
                                AND pa1.inventory_item_id = mmt.inventory_item_id
                                AND pa1.cc_prvdr_organization_id = mmt.organization_id)
          UNION ALL
          SELECT DISTINCT 'PO Receipt' trx_type, pa.segment1 project_number, mtl.transaction_id, mtl.transaction_quantity, mtl.inventory_item_id,
                          b.concatenated_segments, ood.organization_name, mtl.pm_cost_collector_group_id, mtl.pm_cost_collected
                     FROM mtl_material_transactions mtl, pa_projects_all pa, mtl_system_items_kfv b, org_organization_definitions ood
                    WHERE 1 = 1
                      --AND wp.wip_entity_id = mtl.transaction_source_id
                      AND mtl.transaction_source_type_id = 1
                      AND mtl.project_id = pa.project_id
                      AND pa.org_id = :p_org_id
                      AND mtl.inventory_item_id = b.inventory_item_id
                      AND mtl.organization_id = b.organization_id
                      AND mtl.organization_id = ood.organization_id
                      AND mtl.pm_cost_collected IS NULL
                      AND mtl.pm_cost_collector_group_id IS NOT NULL
                      AND mtl.transaction_type_id IN (18)                                                                                           --PO Receipt
                      AND NOT EXISTS (SELECT 1
                                        FROM pa_transaction_interface_all pti
                                       WHERE pti.project_number = pa.segment1 AND pti.orig_transaction_reference = mtl.transaction_id AND pti.org_id = pa.org_id)
                      AND NOT EXISTS (
                             SELECT 1
                               FROM pa_expenditure_items_all pa1
                              WHERE 1 = 1
                                AND pa1.project_id = mtl.project_id
                                AND pa1.inventory_item_id = mtl.inventory_item_id
                                AND pa1.cc_prvdr_organization_id = mtl.organization_id
                                AND pa1.org_id = pa.org_id
                                AND pa1.orig_transaction_reference = TO_CHAR (mtl.transaction_id))
          UNION ALL
          SELECT DISTINCT 'Stock Issue/Receipt' trx_type, pa.segment1 project_number, mtl.transaction_id, mtl.transaction_quantity, mtl.inventory_item_id,
                 b.concatenated_segments, ood.organization_name, mtl.pm_cost_collector_group_id, mtl.pm_cost_collected
            FROM mtl_material_transactions mtl, pa_projects_all pa, mtl_system_items_kfv b, org_organization_definitions ood
           WHERE 1 = 1
             AND mtl.transaction_source_type_id = 6
             AND mtl.project_id = pa.project_id
             AND pa.org_id = :p_org_id
             AND mtl.inventory_item_id = b.inventory_item_id
             AND mtl.organization_id = b.organization_id
             AND mtl.organization_id = ood.organization_id
             AND mtl.pm_cost_collected IS NULL
             AND mtl.pm_cost_collector_group_id IS NOT NULL
             AND mtl.transaction_type_id IN (103, 107)                                                                                     --Stock Issue/Receipt
             AND NOT EXISTS (SELECT 1
                               FROM pa_transaction_interface_all pti
                              WHERE pti.project_number = pa.segment1 AND pti.orig_transaction_reference = mtl.transaction_id AND pti.org_id = pa.org_id)
             AND NOT EXISTS (
                    SELECT 1
                      FROM pa_expenditure_items_all pa1
                     WHERE 1 = 1
                       AND pa1.project_id = mtl.project_id
                       AND pa1.inventory_item_id = mtl.inventory_item_id
                       AND pa1.cc_prvdr_organization_id = mtl.organization_id
                       AND pa1.org_id = pa.org_id
                       AND pa1.orig_transaction_reference = TO_CHAR (mtl.transaction_id))
          UNION ALL
          SELECT DISTINCT 'Sales Order Pick' trx_type, pa.segment1 project_number, mtl.transaction_id, mtl.transaction_quantity, mtl.inventory_item_id,
                 b.concatenated_segments, ood.organization_name, mtl.pm_cost_collector_group_id, mtl.pm_cost_collected
            FROM mtl_material_transactions mtl, pa_projects_all pa, mtl_system_items_kfv b, org_organization_definitions ood
           WHERE 1 = 1
             AND mtl.transaction_source_type_id = 2
             AND mtl.project_id = pa.project_id
             AND pa.org_id = :p_org_id  
             AND mtl.inventory_item_id = b.inventory_item_id
             AND mtl.organization_id = b.organization_id
             AND mtl.organization_id = ood.organization_id
             AND mtl.pm_cost_collected IS NULL
             AND mtl.pm_cost_collector_group_id IS NOT NULL
             AND mtl.transaction_type_id IN (52)                                                                                              --Sales Order Pick
             AND NOT EXISTS (SELECT 1
                               FROM pa_transaction_interface_all pti
                              WHERE pti.project_number = pa.segment1 AND pti.orig_transaction_reference = mtl.transaction_id AND pti.org_id = pa.org_id)
             AND NOT EXISTS (
                    SELECT 1
                      FROM pa_expenditure_items_all pa1
                     WHERE 1 = 1
                       AND pa1.project_id = mtl.project_id
                       AND pa1.inventory_item_id = mtl.inventory_item_id
                       AND pa1.cc_prvdr_organization_id = mtl.organization_id
                       AND pa1.org_id = pa.org_id
                       AND pa1.orig_transaction_reference = TO_CHAR (mtl.transaction_id))