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.BOMPVALR dependencies on MTL_SECONDARY_INVENTORIES

Line 414: from mtl_secondary_inventories

410: IF (X_expense_to_asset_transfer = 1) THEN
411: begin
412: select locator_type
413: into sub_loc_code
414: from mtl_secondary_inventories
415: where secondary_inventory_name = c1rec.CS
416: and organization_id = c1rec.OI
417: and nvl(disable_date,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
418: and quantity_tracked = 1;

Line 427: from mtl_secondary_inventories

423: ELSE
424: begin
425: select locator_type
426: into sub_loc_code
427: from mtl_secondary_inventories
428: where secondary_inventory_name = c1rec.CS
429: and organization_id = c1rec.OI
430: and nvl(disable_date,TRUNC(SYSDATE)+1) > TRUNC(SYSDATE)
431: and ((inv_asst = 'Y' and asset_inventory = 1 and

Line 446: from mtl_secondary_inventories sub,

442: IF (X_expense_to_asset_transfer = 1) THEN
443: begin
444: select locator_type
445: into sub_loc_code
446: from mtl_secondary_inventories sub,
447: mtl_item_sub_inventories item
448: where item.organization_id = sub.organization_id
449: and item.secondary_inventory = sub.secondary_inventory_name
450: and item.inventory_item_id = c1rec.AII

Line 464: from mtl_secondary_inventories sub,

460: ELSE
461: begin
462: select locator_type
463: into sub_loc_code
464: from mtl_secondary_inventories sub,
465: mtl_item_sub_inventories item
466: where item.organization_id = sub.organization_id
467: and item.secondary_inventory = sub.secondary_inventory_name
468: and item.inventory_item_id = c1rec.AII