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.WMS_UCC_128_PVT dependencies on MTL_CROSS_REFERENCES

Line 46: FROM MTL_CROSS_REFERENCES mx, MTL_ITEM_REVISIONS_B mr

42: print_debug('Begin get_xref_values: p_org_id:'||p_org_id||',p_xref='||p_cross_reference);
43:
44: SELECT mx.inventory_item_id, mx.uom_code, mr.revision
45: INTO x_item_id, x_uom_code, x_revision
46: FROM MTL_CROSS_REFERENCES mx, MTL_ITEM_REVISIONS_B mr
47: WHERE mx.organization_id = mr.organization_id(+)
48: and mx.inventory_item_id = mr.inventory_item_id(+)
49: and mx.revision_id = mr.revision_id(+)
50: and mx.cross_reference_type = g_gtin_cross_ref_type

Line 95: FROM MTL_CROSS_REFERENCES mx, MTL_ITEM_REVISIONS_B mr,

91: print_debug('Begin get_xref_values: p_org_id:'||p_org_id||',p_cross_reference='||p_cross_reference||',g_gtin_cross_ref_type='||g_gtin_cross_ref_type);
92:
93: SELECT msi.concatenated_segments, mx.uom_code, mr.revision
94: INTO x_concatenated_segments, x_uom_code, x_revision
95: FROM MTL_CROSS_REFERENCES mx, MTL_ITEM_REVISIONS_B mr,
96: mtl_system_items_kfv msi
97: WHERE mx.organization_id = mr.organization_id(+)
98: and mx.inventory_item_id = mr.inventory_item_id(+)
99: and mx.revision_id = mr.revision_id(+)