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 |