DBA Data[Home] [Help]

APPS.ONT_OEXOEORS_XMLP_PKG dependencies on MTL_CROSS_REFERENCES

Line 764: mtl_cross_references items,

760: select items.cross_reference item,
761: nvl(items.description,sitems.description) description
762: into v_item,v_description
763: from mtl_cross_reference_types xtypes,
764: mtl_cross_references items,
765: mtl_system_items_vl sitems
766: where xtypes.cross_reference_type = items.cross_reference_type
767: and items.inventory_item_id = sitems.inventory_item_id
768: and items.cross_reference = ordered_item

Line 782: mtl_cross_references items,

778: select items.cross_reference item,
779: nvl(items.description,sitems.description) description
780: into v_item,v_description
781: from mtl_cross_reference_types xtypes,
782: mtl_cross_references items,
783: mtl_system_items_vl sitems
784: where xtypes.cross_reference_type =
785: items.cross_reference_type
786: and items.inventory_item_id = sitems.inventory_item_id