DBA Data[Home] [Help]

APPS.ONT_OEXOEIOD_XMLP_PKG dependencies on MTL_CROSS_REFERENCES

Line 1113: mtl_cross_references items,

1109: select items.cross_reference item,
1110: nvl(items.description,sitems.description) description
1111: into v_item,v_description
1112: from mtl_cross_reference_types xtypes,
1113: mtl_cross_references items,
1114: mtl_system_items_vl sitems
1115: where xtypes.cross_reference_type = items.cross_reference_type
1116: and items.inventory_item_id = sitems.inventory_item_id
1117: and items.cross_reference = ordered_item

Line 1131: mtl_cross_references items,

1127: select items.cross_reference item,
1128: nvl(items.description,sitems.description) description
1129: into v_item,v_description
1130: from mtl_cross_reference_types xtypes,
1131: mtl_cross_references items,
1132: mtl_system_items_vl sitems
1133: where xtypes.cross_reference_type =
1134: items.cross_reference_type
1135: and items.inventory_item_id =