eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_ITEM_CATEGORY_OI dependencies on MTL_PARAMETERS

Line 150: FROM mtl_parameters mp

146: AND ( organization_id IS NULL
147: OR ( organization_id IS NOT NULL
148: AND NOT EXISTS
149: ( SELECT mp.organization_id
150: FROM mtl_parameters mp
151: WHERE mp.organization_id = mici.organization_id
152: )
153: )
154: )

Line 176: , mtl_parameters mp

172: , mici.set_process_id,mici.source_system_reference -- Added for Bug 9305193 Fix
173: , mici.source_system_id
174: FROM
175: mtl_item_categories_interface mici
176: , mtl_parameters mp
177: WHERE
178: mici.set_process_id = g_xset_id
179: AND mici.organization_id = mp.organization_id
180: AND mici.process_flag IN (1, 2, 4) --R12C

Line 454: FROM mtl_parameters mp

450: ( mici.organization_id
451: , process_flag
452: ) =
453: ( SELECT mp.organization_id, DECODE(p_validate_rec_flag, 2, 1, 2)
454: FROM mtl_parameters mp
455: WHERE mp.organization_code = mici.organization_code
456: )
457: WHERE
458: mici.set_process_id = g_xset_id

Line 464: FROM mtl_parameters mp2

460: AND mici.organization_id IS NULL
461: AND mici.organization_code IS NOT NULL
462: AND EXISTS
463: ( SELECT mp2.organization_id
464: FROM mtl_parameters mp2
465: WHERE mp2.organization_code = mici.organization_code
466: );
467:
468: -- For missing organization_id, update process_flag and log an error.