APPS.OE_OE_FORM_LINE dependencies on MTL_CROSS_REFERENCES

Line 4119: , mtl_cross_references items

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
4123: AND sitems.organization_id = l_organization_id

Line 4210: ,mtl_cross_references items

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
4214: AND sitems.organization_id = l_organization_id

Line 4250: ,mtl_cross_references items

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
4254: AND sitems.organization_id = l_organization_id

Line 5433: , mtl_cross_references items

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
5437: AND sitems.inventory_item_id = p_inventory_item_id

Line 5449: , mtl_cross_references items

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
5453: AND sitems.inventory_item_id = p_inventory_item_id

Line 5575: , mtl_cross_references items

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
5579: AND sitems.inventory_item_id = p_inventory_item_id

Line 5591: , mtl_cross_references items

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
5595: AND sitems.inventory_item_id = p_inventory_item_id

Line 5714: , mtl_cross_references items

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
5718: AND sitems.inventory_item_id = p_inventory_item_id

Line 5730: , mtl_cross_references items

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
5734: AND sitems.inventory_item_id = p_inventory_item_id