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_API dependencies on MTL_PARAMETERS

Line 429: , MTL_PARAMETERS MP1

425: -- Fix for Bug#6644711
426: ,MSI.DEFAULT_MATERIAL_STATUS_ID
427: FROM
428: MTL_SYSTEM_ITEMS_B MSI
429: , MTL_PARAMETERS MP1
430: WHERE
431: INVENTORY_ITEM_ID = p_Item_ID
432: AND MSI.ORGANIZATION_ID = MP1.ORGANIZATION_ID
433: AND ( ( p_fetch_Master = g_TRUE AND MSI.ORGANIZATION_ID = p_Org_ID ) OR

Line 437: FROM MTL_PARAMETERS MP2

433: AND ( ( p_fetch_Master = g_TRUE AND MSI.ORGANIZATION_ID = p_Org_ID ) OR
434: ( p_fetch_Orgs = g_TRUE AND
435: MSI.ORGANIZATION_ID IN
436: ( SELECT MP2.ORGANIZATION_ID
437: FROM MTL_PARAMETERS MP2
438: WHERE MP2.MASTER_ORGANIZATION_ID = p_Org_ID
439: AND MP2.ORGANIZATION_ID <> p_Org_ID
440: )
441: )

Line 481: FROM MTL_PARAMETERS

477: AND ( ( p_fetch_Master = g_TRUE AND ORGANIZATION_ID = p_Org_ID ) OR
478: ( p_fetch_Orgs = g_TRUE AND
479: ORGANIZATION_ID IN
480: ( SELECT ORGANIZATION_ID
481: FROM MTL_PARAMETERS
482: WHERE MASTER_ORGANIZATION_ID = p_Org_ID
483: AND ORGANIZATION_ID <> p_Org_ID
484: )
485: )