ENGINATICS SYSTEM_ADMINISTRATOR SYSADMIN B24CBF5AD89C6343E0530100007FDCC2 INV Organization Code (no access org restrictions and avoiding master and disabled orgs) Y select mp.organization_code value, haou.name description from mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou where hoi.org_information_context = 'Accounting Information' and hoi.organization_id = mp.organization_id and hoi.organization_id = haou.organization_id and sysdate < nvl(haou.date_to, sysdate +1) and mp.organization_id <> mp.master_organization_id order by 1 US A7AB04F0A881A9D4E053B46B6358068DY 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 US INV MTL TXNS Errors Material Transactions details with account string 1=1 1 10 1=1 mp.organization_code = :p_org_code LOV INV Organization Code (no access org restrictions and avoiding master and disabled orgs) B24CBF5AD89C6343E0530100007FDCC2 Y select mp.organization_code value, haou.name description from mtl_parameters mp, hr_organization_information hoi, hr_all_organization_units haou where hoi.org_information_context = 'Accounting Information' and hoi.organization_id = mp.organization_id and hoi.organization_id = haou.organization_id and sysdate < nvl(haou.date_to, sysdate +1) and mp.organization_id <> mp.master_organization_id order by 1 M1 US Organization Code