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_OE_FORM_LINE dependencies on MTL_CROSS_REFERENCE_TYPES

Line 4118: FROM mtl_cross_reference_types types

4114: --,sitems.concatenated_segments /*Bug 1766327 chhung*/
4115: INTO x_line_val_rec.item_description
4116: ,x_line_val_rec.ordered_item_dsp
4117: --,x_line_val_rec.inventory_item /*Bug 1766327 chhung*/
4118: FROM mtl_cross_reference_types types
4119: , mtl_cross_references items
4120: , mtl_system_items_vl sitems
4121: WHERE types.cross_reference_type = items.cross_reference_type
4122: AND items.inventory_item_id = sitems.inventory_item_id

Line 4209: FROM mtl_cross_reference_types types

4205: --,sitems.concatenated_segments
4206: INTO x_line_val_rec.item_description
4207: ,x_line_val_rec.ordered_item_dsp
4208: --,x_line_val_rec.inventory_item
4209: FROM mtl_cross_reference_types types
4210: ,mtl_cross_references items
4211: ,mtl_system_items_vl sitems
4212: WHERE types.cross_reference_type = items.cross_reference_type
4213: AND items.inventory_item_id = sitems.inventory_item_id

Line 4249: FROM mtl_cross_reference_types types

4245: --,sitems.concatenated_segments
4246: INTO x_line_val_rec.item_description
4247: ,x_line_val_rec.ordered_item_dsp
4248: --,x_line_val_rec.inventory_item
4249: FROM mtl_cross_reference_types types
4250: ,mtl_cross_references items
4251: ,mtl_system_items_vl sitems
4252: WHERE types.cross_reference_type = items.cross_reference_type
4253: AND items.inventory_item_id = sitems.inventory_item_id

Line 5432: FROM mtl_cross_reference_types types

5428: oe_debug_pub.add( 'ENTERING GENERIC::EXACT MATCH' ) ;
5429: END IF;
5430: SELECT count(*)
5431: INTO l_count
5432: FROM mtl_cross_reference_types types
5433: , mtl_cross_references items
5434: , mtl_system_items_vl sitems
5435: WHERE types.cross_reference_type = items.cross_reference_type
5436: AND items.inventory_item_id = sitems.inventory_item_id

Line 5448: FROM mtl_cross_reference_types types

5444: oe_debug_pub.add( 'ENTERING GENERIC::PARTIAL' ) ;
5445: END IF;
5446: SELECT count(*)
5447: INTO l_count
5448: FROM mtl_cross_reference_types types
5449: , mtl_cross_references items
5450: , mtl_system_items_vl sitems
5451: WHERE types.cross_reference_type = items.cross_reference_type
5452: AND items.inventory_item_id = sitems.inventory_item_id

Line 5574: FROM mtl_cross_reference_types types

5570: oe_debug_pub.add( 'ENTERING GENERIC::EXACT MATCH' ) ;
5571: END IF;
5572: SELECT count(*)
5573: INTO l_count
5574: FROM mtl_cross_reference_types types
5575: , mtl_cross_references items
5576: , mtl_system_items_vl sitems
5577: WHERE types.cross_reference_type = items.cross_reference_type
5578: AND items.inventory_item_id = sitems.inventory_item_id

Line 5590: FROM mtl_cross_reference_types types

5586: oe_debug_pub.add( 'ENTERING GENERIC::PARTIAL' ) ;
5587: END IF;
5588: SELECT count(*)
5589: INTO l_count
5590: FROM mtl_cross_reference_types types
5591: , mtl_cross_references items
5592: , mtl_system_items_vl sitems
5593: WHERE types.cross_reference_type = items.cross_reference_type
5594: AND items.inventory_item_id = sitems.inventory_item_id

Line 5713: FROM mtl_cross_reference_types types

5709: oe_debug_pub.add( 'ENTERING GENERIC::EXACT MATCH' ) ;
5710: END IF;
5711: SELECT count(*)
5712: INTO l_count
5713: FROM mtl_cross_reference_types types
5714: , mtl_cross_references items
5715: , mtl_system_items_vl sitems
5716: WHERE types.cross_reference_type = items.cross_reference_type
5717: AND items.inventory_item_id = sitems.inventory_item_id

Line 5729: FROM mtl_cross_reference_types types

5725: oe_debug_pub.add( 'ENTERING GENERIC::PARTIAL' ) ;
5726: END IF;
5727: SELECT count(*)
5728: INTO l_count
5729: FROM mtl_cross_reference_types types
5730: , mtl_cross_references items
5731: , mtl_system_items_vl sitems
5732: WHERE types.cross_reference_type = items.cross_reference_type
5733: AND items.inventory_item_id = sitems.inventory_item_id