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.OE_VALIDATE_LINE dependencies on MTL_CROSS_REFERENCE_TYPES

Line 1662: FROM mtl_cross_reference_types types

1658: item_val_org NUMBER := to_number(OE_Sys_Parameters.VALUE('MASTER_ORGANIZATION_ID'));
1659: CURSOR xref IS
1660: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1661: DECODE(items.organization_id, item_val_org, 1, 2))
1662: FROM mtl_cross_reference_types types
1663: , mtl_cross_references items
1664: , mtl_system_items_vl sitems
1665: WHERE types.cross_reference_type = items.cross_reference_type
1666: AND items.inventory_item_id = sitems.inventory_item_id

Line 1679: FROM mtl_cross_reference_types types

1675: --cursor added for bug 3844345
1676: CURSOR xref_return IS
1677: SELECT DECODE(items.org_independent_flag, 'Y', 1,
1678: DECODE(items.organization_id, item_val_org, 1, 2))
1679: FROM mtl_cross_reference_types types
1680: , mtl_cross_references items
1681: , mtl_system_items_vl sitems
1682: WHERE types.cross_reference_type = items.cross_reference_type
1683: AND items.inventory_item_id = sitems.inventory_item_id