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 149: FROM mtl_parameters mp

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

Line 173: , mtl_parameters mp

169: , mici.old_category_id, mici.old_category_name --* Added for Bug #3991044
170: , mici.created_by
171: FROM
172: mtl_item_categories_interface mici
173: , mtl_parameters mp
174: WHERE
175: mici.set_process_id = g_xset_id
176: AND mici.organization_id = mp.organization_id
177: AND mici.process_flag IN (1, 2, 4) --R12C

Line 447: FROM mtl_parameters mp

443: ( mici.organization_id
444: , process_flag
445: ) =
446: ( SELECT mp.organization_id, DECODE(p_validate_rec_flag, 2, 1, 2)
447: FROM mtl_parameters mp
448: WHERE mp.organization_code = mici.organization_code
449: )
450: WHERE
451: mici.set_process_id = g_xset_id

Line 457: FROM mtl_parameters mp2

453: AND mici.organization_id IS NULL
454: AND mici.organization_code IS NOT NULL
455: AND EXISTS
456: ( SELECT mp2.organization_id
457: FROM mtl_parameters mp2
458: WHERE mp2.organization_code = mici.organization_code
459: );
460:
461: -- For missing organization_id, update process_flag and log an error.