INV MTL TXNS Errors
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 |
|
LOV |