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.BOMPVALB dependencies on MTL_SECONDARY_LOCATORS

Line 1820: mtl_secondary_locators item

1816: begin
1817: select 'restricted loc exists'
1818: into dummy
1819: from mtl_item_locations loc,
1820: mtl_secondary_locators item
1821: where loc.inventory_location_id = c1rec.SLI
1822: and loc.organization_id = c1rec.OI
1823: and loc.subinventory_code = c1rec.SS
1824: and nvl(loc.disable_date,trunc(c1rec.EDD)+1) >

Line 1872: mtl_secondary_locators item

1868: begin
1869: select 'restricted loc exists'
1870: into dummy
1871: from mtl_item_locations loc,
1872: mtl_secondary_locators item
1873: where loc.inventory_location_id = c1rec.SLI
1874: and loc.organization_id = c1rec.OI
1875: and loc.subinventory_code = c1rec.SS
1876: and nvl(loc.disable_date,trunc(c1rec.EDD)+1) >

Line 1926: mtl_secondary_locators item

1922: begin
1923: select 'restricted loc exists'
1924: into dummy
1925: from mtl_item_locations loc,
1926: mtl_secondary_locators item
1927: where loc.inventory_location_id = c1rec.SLI
1928: and loc.organization_id = c1rec.OI
1929: and loc.subinventory_code = c1rec.SS
1930: and nvl(loc.disable_date,trunc(c1rec.EDD)+1) >