INV MTL TXNS Errors

➜ Back to Library
Description
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
Download
Related Blitz Reports
INV Item Upload GL Account Analysis (Distributions) CAC Inventory to G/L Reconciliation (Restricted by Org Access) GL Account Analysis (Drilldown) (with inventory and WIP) 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 AR Transactions and Lines 11i
Blitz Report™

Blitz Report™ provides multiple benefits: