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.CN_NOTIFY_ORDERS dependencies on MTL_SYSTEM_ITEMS

Line 221: FROM mtl_system_items mtl

217: AND asoh.org_id = asol.org_id -- R12 MOAC Changes
218: -- also collect 'RETURN's AND asol.line_category_code = 'ORDER' -- only collect 'Order' lines
219: AND EXISTS
220: (SELECT 1
221: FROM mtl_system_items mtl
222: WHERE
223: --+
224: -- Because this procedure is looking at orders for any
225: -- org_id, we have to get the inventory organization for

Line 1402: FROM mtl_system_items mtl

1398: BETWEEN TRUNC(nvl(l_start_date,asoh.booked_date))
1399: AND TRUNC(nvl(l_end_date,asoh.booked_date))
1400: AND EXISTS
1401: (SELECT 1
1402: FROM mtl_system_items mtl
1403: WHERE NVL(mtl.organization_id,l_so_org_id) = l_so_org_id
1404: AND mtl.inventory_item_id = asol.inventory_item_id
1405: AND mtl.invoiceable_item_flag = 'Y') -- only want invoiceable items
1406: AND NOT EXISTS