INV MTL TXNS Errors

Description
Categories: Toolkit - Setup & Support
Columns: Error Explanation, Account, Error Code, Transaction Date, Distribution Account Id, Segment1, Org Code, Source Code, Primary Quantity, Transaction Cost ...
Material Transactions details with account string
select mti.error_explanation ,
   (GCC.SEGMENT1||'-'|| --COMPANY
    GCC.SEGMENT2||'-'|| --LOCATION
    GCC.SEGMENT3||'-'|| --NAT ACCOUNT
    GCC.SEGMENT4||'-'|| --BUSINESS SEGMENT
    GCC.SEGMENT5||'-'|| -- COST CENTRE
    GCC.SEGMENT6||'-'|| --INTERCO
    GCC.SEGMENT1||'-'|| --PROD SOURCE
    GCC.SEGMENT2||'-'|| --PROD GRP
    GCC.SEGMENT9) ACCOUNT ,--PROJECT     --10 11 = SPARE,
MTI.ERROR_CODE, 
mti.transaction_date,
mti.DISTRIBUTION_ACCOUNT_ID,
mti.transaction_date,
msiB.segment1, mp.organization_code, 
MTI.SOURCE_CODE, 
MTI.PRIMARY_QUANTITY,  
MTI.TRANSACTION_COST, 
MTI.TRANSACTION_ACTION_ID, 
MTI.TRANSACTION_TYPE_ID,
MTI.TRANSACTION_UOM,
MTI.SUBINVENTORY_CODE
from 
apps.MTL_TRANSACTIONS_INTERFACE mti,
apps.mtl_system_items_b msib,
apps.mtl_parameters mp,
apps.gl_code_combinations gcc
where 1=1
and mti.distribution_account_id=gcc.code_combination_id
and mti.inventory_item_id =msib.INVENTORY_ITEM_ID
and mti.ORGANIZATION_ID =msib.ORGANIZATION_ID
and mti.ORGANIZATION_ID = mp.organization_id
Parameter Name SQL text Validation
Organization Code
mp.organization_code = :p_org_code
LOV