INV MTL TXNS Errors

➜ Back to Library
Description
Material Transactions details with account string
Run INV MTL TXNS Errors and other Oracle EBS reports with Blitz Report™ on our demo environment
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
Download
Related Blitz Reports
COPY OF: INV Inventory Item Upload INV Inventory Item Upload GL Account Analysis (Distributions) CAC Inventory to G/L Reconciliation (Restricted by Org Access) GL Account Analysis CAC WIP Jobs With Complete Status But Not Ready for Close CAC Receiving Value (Period-End) CAC WIP Jobs With Complete Status Which Are Ready for Close PO Requisition Upload
Blitz Report™

Blitz Report™ provides multiple benefits: