APPS.OE_OE_FORM_LINE dependencies on MTL_CROSS_REFERENCES

Line 3954: , mtl_cross_references items

3950: INTO x_line_val_rec.item_description
3951: ,x_line_val_rec.ordered_item_dsp
3952: ,x_line_val_rec.inventory_item /*Bug 1766327 chhung*/
3953: FROM mtl_cross_reference_types types
3954: , mtl_cross_references items
3955: , mtl_system_items_vl sitems
3956: WHERE types.cross_reference_type = items.cross_reference_type
3957: AND items.inventory_item_id = sitems.inventory_item_id
3958: AND sitems.organization_id = l_organization_id

Line 4003: ,mtl_cross_references items

3999: INTO x_line_val_rec.item_description
4000: ,x_line_val_rec.ordered_item_dsp
4001: ,x_line_val_rec.inventory_item
4002: FROM mtl_cross_reference_types types
4003: ,mtl_cross_references items
4004: ,mtl_system_items_vl sitems
4005: WHERE types.cross_reference_type = items.cross_reference_type
4006: AND items.inventory_item_id = sitems.inventory_item_id
4007: AND sitems.organization_id = l_organization_id

Line 4022: ,mtl_cross_references items

4018: INTO x_line_val_rec.item_description
4019: ,x_line_val_rec.ordered_item_dsp
4020: ,x_line_val_rec.inventory_item
4021: FROM mtl_cross_reference_types types
4022: ,mtl_cross_references items
4023: ,mtl_system_items_vl sitems
4024: WHERE types.cross_reference_type = items.cross_reference_type
4025: AND items.inventory_item_id = sitems.inventory_item_id
4026: AND sitems.organization_id = l_organization_id

Line 5151: , mtl_cross_references items

5147: END IF;
5148: SELECT count(*)
5149: INTO l_count
5150: FROM mtl_cross_reference_types types
5151: , mtl_cross_references items
5152: , mtl_system_items_vl sitems
5153: WHERE types.cross_reference_type = items.cross_reference_type
5154: AND items.inventory_item_id = sitems.inventory_item_id
5155: AND sitems.inventory_item_id = p_inventory_item_id

Line 5167: , mtl_cross_references items

5163: END IF;
5164: SELECT count(*)
5165: INTO l_count
5166: FROM mtl_cross_reference_types types
5167: , mtl_cross_references items
5168: , mtl_system_items_vl sitems
5169: WHERE types.cross_reference_type = items.cross_reference_type
5170: AND items.inventory_item_id = sitems.inventory_item_id
5171: AND sitems.inventory_item_id = p_inventory_item_id

Line 5290: , mtl_cross_references items

5286: END IF;
5287: SELECT count(*)
5288: INTO l_count
5289: FROM mtl_cross_reference_types types
5290: , mtl_cross_references items
5291: , mtl_system_items_vl sitems
5292: WHERE types.cross_reference_type = items.cross_reference_type
5293: AND items.inventory_item_id = sitems.inventory_item_id
5294: AND sitems.inventory_item_id = p_inventory_item_id

Line 5306: , mtl_cross_references items

5302: END IF;
5303: SELECT count(*)
5304: INTO l_count
5305: FROM mtl_cross_reference_types types
5306: , mtl_cross_references items
5307: , mtl_system_items_vl sitems
5308: WHERE types.cross_reference_type = items.cross_reference_type
5309: AND items.inventory_item_id = sitems.inventory_item_id
5310: AND sitems.inventory_item_id = p_inventory_item_id

Line 5426: , mtl_cross_references items

5422: END IF;
5423: SELECT count(*)
5424: INTO l_count
5425: FROM mtl_cross_reference_types types
5426: , mtl_cross_references items
5427: , mtl_system_items_vl sitems
5428: WHERE types.cross_reference_type = items.cross_reference_type
5429: AND items.inventory_item_id = sitems.inventory_item_id
5430: AND sitems.inventory_item_id = p_inventory_item_id

Line 5442: , mtl_cross_references items

5438: END IF;
5439: SELECT count(*)
5440: INTO l_count
5441: FROM mtl_cross_reference_types types
5442: , mtl_cross_references items
5443: , mtl_system_items_vl sitems
5444: WHERE types.cross_reference_type = items.cross_reference_type
5445: AND items.inventory_item_id = sitems.inventory_item_id
5446: AND sitems.inventory_item_id = p_inventory_item_id